Opened 2 years ago
Last modified 2 years ago
#5077 closed defect
Upgrading from PostGIS 2.4.9 to master (3.3.0dev) on PG12 results in error — at Initial Version
Reported by: | robe | Owned by: | strk |
---|---|---|---|
Priority: | blocker | Milestone: | PostGIS 2.4.10 |
Component: | QA/buildbots | Version: | 2.4.x |
Keywords: | Cc: |
Description
It seems on dronie, we managed to get a PostGIS with 2.4.9 installed in PG12.
Now that we made PG12 live, it is trying to upgrade from PG 12 2.4.9 to 3.3.0dev
and failing on topology. This looks like issue with changes made in PG12 they took out. I think we had fixed the views for geography_columns and geometry_columns. So I suspect a similar change can be made on topology.
CREATE FUNCTION 2147s 28875psql:/usr/share/postgresql/12/contrib/postgis-2.4/topology.sql:822: NOTICE: function topology.populate_topology_layer() does not exist, skipping 2147s 28876DROP FUNCTION 2147s 28877psql:/usr/share/postgresql/12/contrib/postgis-2.4/topology.sql:856: ERROR: column c.consrc does not exist 2147s 28878LINE 11: regexp_matches(c.consrc, 2147s 28879 ^ 2147s 28880HINT: Perhaps you meant to reference the column "c.conkey" or the column "c.conbin". 2147s 28881NOTICE: schema "public" already exists, skipping 2147s 28882CREATE SCHEMA 2147s 28883SET 2147s 28884psql:/usr/share/postgresql/12/contrib/postgis-2.4/topology_comments.sql:2: ERROR: type "topology.getfaceedges_returntype" does not exist 2147s 28885NOTICE: schema "public" already exists, skipping 2147s 28886CREATE SCHEMA 2147s 28887SET 2147s 28888psql:/drone/src/topology/test/regress/hooks/hook-before-upgrade-topology.sql:1: ERROR: function topology.createtopology(unknown) does not exist 2147s 28889LINE 1: SELECT topology.createTopology('upgrade_test'); 2147s 28890 ^ 2147s 28891HINT: No function matches the given name and argument types. You might need to add explicit type casts. 2147s 28892----------------------------------------------------------------------------- 2147s 28893/drone/src/regress/runtest.mk:22: recipe for target 'check-regress' failed 2147s 28894make: Leaving directory '/tmp/postgis-build/12/topology/test' 2147s 28895FAIL: postgis_topology upgrade unpackaged2.4--3.3.0dev!
Note:
See TracTickets
for help on using tickets.