[postgis-tickets] [PostGIS] #2258: Can't upgrade from 2.1.0 to 2.1.0 when postgis in non-default schema

[PostGIS]

#2258: Can't upgrade from 2.1.0 to 2.1.0 when postgis in non-default schema
-----------------------------------+----------------------------------------
 Reporter:  robe                   |       Owner:  strk         
     Type:  defect                 |      Status:  new          
 Priority:  blocker                |   Milestone:  PostGIS 2.1.0
Component:  build/upgrade/install  |     Version:  trunk        
 Keywords:                         |  
-----------------------------------+----------------------------------------
 I just tried to upgrade one of my databases running:

 {{{
 postgis_full_version
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  POSTGIS="2.1.0SVN r11230" GEOS="3.4.0dev-CAPI-1.8.0 r0" PROJ="Rel. 4.8.0,
 6 March 2012" GDAL="GDAL 1.9.2, released 2012/10/08" LIBXML="2.7.8"
 LIBJSON="UNKNOWN" (core procs from "2.1.0SVN r11197" need upgrade) RASTER
 (raster procs from "2.1.0SVN r11197" need upgrade)
 (1 row)
 }}}

 to the latest using my favorite:


 {{{
 ALTER EXTENSION postgis UPDATE TO "2.1.0SVNnext";

 }}}

 and to my horror, I got this error:


 {{{

 ERROR:  function public.st_estimatedextent(text, text, text) does not
 exist
 LINE 3:     SELECT public.ST_EstimatedExtent($1, $2, $3);
                    ^
 HINT:  No function matches the given name and argument types. You might
 need to add explicit type casts.
 QUERY:   SELECT _postgis_deprecate('ST_Estimated_Extent',
 'ST_EstimatedExtent', '2.1.0');
     -- explicit schema for security reason
     SELECT public.ST_EstimatedExtent($1, $2, $3);
 ---------------------------
 }}}


 I suspect its because this particular database I have has postgis
 installed in a separate schema called postgis
 and we've got public.ST_EstimatedExtent hardcoded somewhere.

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