[postgis-tickets] [PostGIS] #4588: Update from PG9.3/Postgis 2.2 to PG11/Postgis 2.5.2 fails due to ST_Union update

[PostGIS]

#4588: Update from PG9.3/Postgis 2.2 to PG11/Postgis 2.5.2 fails due to ST_Union
update
------------------------+---------------------------
 Reporter:  Algunenano  |      Owner:  Algunenano
     Type:  defect      |     Status:  assigned
 Priority:  medium      |  Milestone:  PostGIS 2.4.9
Component:  postgis     |    Version:  2.4.x
 Keywords:              |
------------------------+---------------------------
 Mail: https://lists.osgeo.org/pipermail/postgis-
 users/2019-November/043751.html

 {{{
 If I try to upgrade I obtain this error :
 $ psql -d OSU -c "ALTER EXTENSION postgis UPDATE;"
 ERROR:  function "st_union(geometry)" does not exist
 LINE 2:  WHERE oid = 'st_union(geometry)'::regprocedure AND proparal...
                      ^
 QUERY:  UPDATE pg_proc SET proparallel = 's'
         WHERE oid = 'st_union(geometry)'::regprocedure AND proparallel =
 'u'
 CONTEXT:  PL/pgSQL function inline_code_block line 5 at SQL statement
 }}}


 Affected 2.4+

 In 2.4 and 2.5: postgis/postgis_drop_after.sql
 In 3.0 and master: postgis/postgis_after_upgrade.sql


 A try catch should be enough to be able to continue if
 `st_union(geometry)` doesn't exist.

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