[postgis-tickets] [PostGIS] #2279: Can't upgrade PostGIS from 2.0

[PostGIS]

#2279: Can't upgrade PostGIS from 2.0
---------------------+------------------------------------------------------
 Reporter:  robe     |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  blocker  |   Milestone:  PostGIS 2.1.0
Component:  postgis  |     Version:  trunk        
 Keywords:           |  
---------------------+------------------------------------------------------

Comment(by robe):

 hmm I realize we have another problem that I don't think is resolvable
 without a dump restore for people who want to use 3D &&& selectivity
 benefits:


 {{{
 -- 2.0 &&& looked like this --
 CREATE OPERATOR &&&(
   PROCEDURE = geometry_overlaps_nd,
   LEFTARG = geometry,
   RIGHTARG = geometry,
   COMMUTATOR = &&&,
   RESTRICT = contsel,
   JOIN = contjoinsel);

 }}}

 but new operator looks like this:


 {{{
 CREATE OPERATOR &&&(
   PROCEDURE = geometry_overlaps_nd,
   LEFTARG = geometry,
   RIGHTARG = geometry,
   COMMUTATOR = &&&,
   RESTRICT = gserialized_gist_sel_nd,
   JOIN = gserialized_gist_joinsel_nd);
 }}}

 So I guess the good news is I can get rid of the geography (  RESTRICT =
 geography_gist_selectivity,
   JOIN = geography_gist_join_selectivity) name simply by renaming it to
 gserialized_gist_sel_nd etc and rolling over it with a steam iron.

 The bad news is the 3D case seems hopeless however you look at it.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2279#comment:8>
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.