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:1 by , 5 years ago
comment:6 by , 5 years ago
Resolution: | → fixed |
---|---|
Status: | assigned → closed |
Pushed to all affected branches
Note:
See TracTickets
for help on using tickets.
GH PR: https://github.com/postgis/postgis/pull/517