[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:40:08 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 robe):

 Setting search_path against each installed function breaks sql inlining
 and a whole bunch of other things too unpredicatable to guess.

 Remember that was what I tried and it slowed some functions to a crawl.  I
 brought it up on hackers mailing list.

 https://www.postgresql.org/message-
 id/flat/CA%2BTgmob_WSEo1xNKHz6xZB4NLGfwAa9TTsf4_edA7zJtOXbzjQ%40mail.gmail.com#CA+Tgmob_WSEo1xNKHz6xZB4NLGfwAa9TTsf4_edA7zJtOXbzjQ at mail.gmail.com

 So it needs to be hard-coded until PostgreSQL comes up with a solution.

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