[postgis-tickets] [PostGIS] #2258: ST_Estimated_Extent assumes postgis is installed in public (was: Can't upgrade from 2.1.0 to 2.1.0 when postgis in non-default schema)

[PostGIS]

#2258: ST_Estimated_Extent assumes postgis is installed in public
-----------------------------------+----------------------------------------
 Reporter:  robe                   |       Owner:  strk         
     Type:  defect                 |      Status:  new          
 Priority:  blocker                |   Milestone:  PostGIS 2.1.0
Component:  build/upgrade/install  |     Version:  trunk        
 Keywords:                         |  
-----------------------------------+----------------------------------------

Comment(by robe):

 Ahah -- the smoking gun --
 You have this defined as:


 {{{
 CREATE OR REPLACE FUNCTION ST_estimated_extent(text,text,text) RETURNS
 box2d AS
   $$ SELECT _postgis_deprecate('ST_Estimated_Extent',
 'ST_EstimatedExtent', '2.1.0');
     -- explicit schema for security reason
     SELECT public.ST_EstimatedExtent($1, $2, $3);
   $$
         LANGUAGE 'sql' IMMUTABLE STRICT SECURITY DEFINER;
 }}}


 And evidentally gets called during upgrade for some reason.

 We can't assume anything about where PostGIS  is installed.

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