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

[PostGIS]

#3821: Don't drop st_union when updating postgis extension to 2.4
--------------------------+---------------------------
  Reporter:  nextstopsun  |      Owner:  robe
      Type:  defect       |     Status:  new
  Priority:  medium       |  Milestone:  PostGIS 2.4.0
 Component:  postgis      |    Version:  2.3.x
Resolution:               |   Keywords:
--------------------------+---------------------------
Changes (by robe):

 * milestone:  PostGIS 2.5.0 => PostGIS 2.4.0


Comment:

 Alright we'll just do this for ST_Union cause everyone just so loves
 ST_Union.


 If people complain about other aggs we can add them too.

 I like nextstopsum's idea of only updating if it is not set already.  We
 might have to do that anyway for folks going from 9.4 to 10 using the
 pg_upgrade going from 2.4 to 2.4.


 So I'll include script:


 {{{
 UPDATE pg_proc SET proparallel = 's'
 WHERE oid = 'st_union(geometry)'::regprocedure AND proparallel = 'u';
 }}}


 and change the note so our proc upgrade helper doesn't try to help out.

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