[postgis-tickets] [PostGIS] #3821: Don't drop st_union when updating postgis extension to 2.4

PostGIS trac at osgeo.org
Mon Aug 28 00:52:56 PDT 2017


#3821: Don't drop st_union when updating postgis extension to 2.4
-------------------------+---------------------------
 Reporter:  nextstopsun  |      Owner:  pramsey
     Type:  defect       |     Status:  new
 Priority:  medium       |  Milestone:  PostGIS 2.4.0
Component:  postgis      |    Version:  2.3.x
 Keywords:               |
-------------------------+---------------------------
 When doing an `ALTER EXTENSION postgis UPDATE TO '2.4.0dev'` I get an
 error
 `ERROR: cannot drop function st_union(geometry) because other objects
 depend on it` with a list of my views using this function.

 Can it be upgraded without dropping it first?
 Otherwise I'll have to recreate a lot of objects in my DB.

 This line causes trouble:
 `DROP AGGREGATE IF EXISTS ST_Union (geometry)`

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