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

PostGIS trac at osgeo.org
Mon Oct 9 08:22:30 PDT 2017


#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 strk):

 But {{{ @schema at . }}} is stripped off when generating
 the extension-less script, so the problem is only with
 extension. Do we want to make the two versions
 comparable when it comes to security, by maybe
 setting search_path against each installed function
 so it matches the schema of installation ?

 Then we can threat both cases the same and introduce
 the safety check ensuring that the same schema of
 PostGIS is used to also load raster... (I'm not sure
 if any user would currently be installing raster in
 a different directory).

 Or we could accept installing raster in any schema
 *but* set the search_path to be sure it includes
 the schema in which postgis is loaded ?

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