[postgis-tickets] [PostGIS] #5077: Upgrading from PostGIS 2.4.9 to master (3.3.0dev) on PG12 results in error

[PostGIS]

#5077: Upgrading from PostGIS 2.4.9 to master (3.3.0dev) on PG12 results in error
-----------------------+----------------------------
  Reporter:  robe      |      Owner:  strk
      Type:  defect    |     Status:  new
  Priority:  blocker   |  Milestone:  PostGIS 2.4.10
 Component:  topology  |    Version:  2.4.x
Resolution:            |   Keywords:
-----------------------+----------------------------
Description changed by robe:

Old 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!
> }}}

New description:

 It seems on dronie, we managed to get a PostGIS with 2.4.9 installed in
 PG12.  https://dronie.osgeo.org/postgis/postgis/2702/1/6

 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!
 }}}

--

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