[PostGIS] #5590: loading topology.sql: ERROR: schema "topology" already exists

PostGIS trac at osgeo.org
Thu Oct 26 09:41:57 PDT 2023


#5590: loading topology.sql: ERROR:  schema "topology" already exists
----------------------+---------------------------
 Reporter:  strk      |      Owner:  strk
     Type:  defect    |     Status:  new
 Priority:  medium    |  Milestone:  PostGIS 3.4.1
Component:  topology  |    Version:  3.4.x
 Keywords:            |
----------------------+---------------------------
 In master branch, topology.sql doesn't load:

 {{{
 [strk at c19:/usr/local/src/postgis/postgis/build/pg13(main)] psql -f
 topology/topology.sql tt --set ON_ERROR_STOP=1
 CREATE SCHEMA
 COMMENT
 BEGIN
 CREATE TABLE
 CREATE FUNCTION
 CREATE TABLE
 CREATE TRIGGER
 CREATE TYPE
 CREATE DOMAIN
 ALTER DOMAIN
 psql:topology/topology.sql:388: NOTICE:  constraint "type_range" of domain
 "topology.topoelement" does not exist, skipping
 ALTER DOMAIN
 ALTER DOMAIN
 CREATE DOMAIN
 ALTER DOMAIN
 ALTER DOMAIN
 CREATE FUNCTION
 ...
 CREATE CAST
 CREATE FUNCTION
 psql:topology/topology.sql:1312: ERROR:  type "topogeometry" does not
 exist
 [strk at c19:/usr/local/src/postgis/postgis/build/pg13(main)] grep  -n .
 topology/topology.sql  | grep ^1312
 1312:CREATE CAST (topogeometry AS int[]) WITH FUNCTION
 TopoElement(topogeometry) AS ASSIGNMENT;
 }}}

 It sounds like a lack of qualification for the type.

 Thing work ok in stable-3.3 but fail in stable-3.4 and master branches
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5590>
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.


More information about the postgis-tickets mailing list