Ticket #543 (closed defect: fixed)

Opened 3 years ago

Last modified 17 months ago

uninstall_postgis.sql doesn't remove operator family

Reported by: nicklas Owned by: nicklas
Priority: medium Milestone: PostGIS 2.0.0
Component: build/upgrade/install Version: 1.5.X
Keywords: Cc:

Description

The operator families is not removed with uninstall_postgis.sql

It seems to work by just droping the families instead of the classes with cascade then all of it seems to be droped so the suggestion is to change:

DROP OPERATOR CLASS gist_geometry_ops USING gist CASCADE; DROP OPERATOR CLASS gist_geometry_ops USING gist CASCADE; to DROP OPERATOR FAMILY gist_geometry_ops USING gist CASCADE; DROP OPERATOR FAMILY gist_geometry_ops USING gist CASCADE;

and

DROP OPERATOR CLASS gist_geography_ops USING gist CASCADE; DROP OPERATOR CLASS btree_geography_ops USING btree CASCADE; to DROP OPERATOR FAMILY gist_geography_ops USING gist CASCADE; DROP OPERATOR FAMILY btree_geography_ops USING btree CASCADE;

or is that risky in any way. Should we drop both the classes and the families instead?

I guess it is the same thing with trunk and 1.4.x branch

Change History

Changed 3 years ago by nicklas

  • owner changed from pramsey to nicklas

Changed 3 years ago by robe

  • milestone changed from PostGIS 1.5.2 to PostGIS 1.4.3

Changed 3 years ago by mwtoews

  • milestone changed from PostGIS 1.4.3 to PostGIS 1.5.3

Changed 2 years ago by robe

  • milestone changed from PostGIS 1.5.3 to PostGIS 2.0.0

Changed 17 months ago by strk

  • component changed from postgis to build/upgrade/install

Changed 17 months ago by strk

  • status changed from new to closed
  • resolution set to fixed

Confirmed by new uninstall regression tester and fixed with r8510

Note: See TracTickets for help on using tickets.