[postgis-tickets] [PostGIS] #3893: Add safety check for raster support to be in same schema as postgis

[PostGIS]

#3893: Add safety check for raster support to be in same schema as postgis
----------------------+---------------------------
  Reporter:  strk     |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  medium   |  Milestone:  PostGIS 2.4.1
 Component:  postgis  |    Version:  2.4.x
Resolution:           |   Keywords:
----------------------+---------------------------

Comment (by robe):

 strk,

 In PostGIS 2.3, everything was schema qualified to make dump and restore
 easy.

 Since raster is part of postgis, I schema qualified all the PostGIS calls
 in it.

 So if you install postgis say in schema called postgis;

 and install postgis_raster in schema postgis_raster.  All calls to postgis
 functions in your raster extension would be pointing at postgis_raster.
 It will not find the functions and well error out.


 Take a look at:


 {{{
 https://git.osgeo.org/gogs/postgis/postgis/src/svn-
 trunk/raster/rt_pg/rtpostgis.sql.in#L5767

 CREATE OR REPLACE FUNCTION raster_overlap(raster, raster)
     RETURNS bool
     AS 'select $1::geometry OPERATOR(@extschema at .&&) $2::geometry'
     LANGUAGE 'sql' IMMUTABLE STRICT _PARALLEL;
 }}}

 Granted a lot of places I missed.  So any way all your raster indexes will
 be broken.

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3893#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.