Opened 5 years ago

Closed 5 years ago

#4588 closed defect (fixed)

Update from PG9.3/Postgis 2.2 to PG11/Postgis 2.5.2 fails due to ST_Union update

Reported by: Algunenano Owned by: Algunenano
Priority: medium Milestone: PostGIS 2.4.9
Component: postgis Version: 2.4.x
Keywords: Cc:

Description

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.

Change History (6)

comment:2 by Raúl Marín <git@…>, 5 years ago

In 5887c91/git:

Avoid throwing during update if st_union(geometry) doesn't exist

Closes https://github.com/postgis/postgis/pull/517
References #4588

comment:3 by Raúl Marín <git@…>, 5 years ago

In 1e39cf0/git:

Avoid throwing during update if st_union(geometry) doesn't exist

References #4588

comment:4 by Raúl Marín <git@…>, 5 years ago

In a4a040c/git:

Avoid throwing during update if st_union(geometry) doesn't exist

References #4588

comment:5 by Raúl Marín <git@…>, 5 years ago

In b1732eb/git:

Avoid throwing during update if st_union(geometry) doesn't exist

References #4588

comment:6 by Algunenano, 5 years ago

Resolution: fixed
Status: assignedclosed

Pushed to all affected branches

Note: See TracTickets for help on using tickets.