[postgis-devel] [PostGIS] #543: uninstall_postgis.sql doesn't remove operator family

PostGIS trac at osgeo.org
Mon Jun 14 02:17:55 PDT 2010


#543: uninstall_postgis.sql doesn't remove operator family
---------------------+------------------------------------------------------
 Reporter:  nicklas  |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  medium   |   Milestone:  PostGIS 1.5.2
Component:  postgis  |     Version:  1.5.X        
 Keywords:           |  
---------------------+------------------------------------------------------
 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

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/543>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.


More information about the postgis-devel mailing list