[postgis-tickets] [PostGIS] #3686: perl upgrade scripts should not touch DO

[PostGIS]

#3686: perl upgrade scripts should not touch DO
---------------------+---------------------------
 Reporter:  robe     |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  medium   |  Milestone:  PostGIS 2.4.0
Component:  postgis  |    Version:  2.3.x
 Keywords:           |
---------------------+---------------------------
 So in trying to fix up #3683, I'm forced to move the postgis brin stuff
 into a separate file because

 1) Since there is not create if not exists for operator and operator
 family, the only way to future version proof this is to check if those
 operator / families are in the catalog and only run those parts if they
 are not in the users catalog.

 2) Our perl scripts, if I include the DO right in there, mangles with my
 DO so I still end up with those operator stuff being filtered out if they
 have an availability tag on top.


 At anyrate I think it's dangerous for it to be touching DO constructs at
 all.  Not quite sure what logic to put in there to prevent that.

 So far it hasn't been a non-issue since all our DO's happen in before or
 after.sql files that are tacked on later and never pass thru the perl
 scripts.

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