[postgis-tickets] [PostGIS] #4251: topology failing on PostgreSQL 12devel

[PostGIS]

#4251: topology failing on PostgreSQL 12devel
----------------------+---------------------------
 Reporter:  robe      |      Owner:  robe
     Type:  defect    |     Status:  assigned
 Priority:  blocker   |  Milestone:  PostGIS 2.5.2
Component:  topology  |    Version:  2.4.x
 Keywords:            |
----------------------+---------------------------
 {{{
  regress/legacy_predicate .. failed (diff expected obtained:
 /var/lib/jenkins/workspace/postgis/tmp/3_0_pg12w64/test_2_diff)
 -----------------------------------------------------------------------------
 --- regress/legacy_predicate_expected   2018-09-16 16:55:15.018504025
 +0000
 +++ /var/lib/jenkins/workspace/postgis/tmp/3_0_pg12w64/test_2_out
 2018-11-22 07:43:13.490101967 +0000
 @@ -5,116 +5,75 @@
  26
  COMMIT
  BEGIN
 -1
 -2
 -3
 +ERROR:  syntax error at or near "oids" at character 80
 +ERROR:  syntax error at or near "oids" at character 80
 +ERROR:  syntax error at or near "oids" at character 81
 +ERROR:  current transaction is aborted, commands ignored until end of
 transaction block
 +ERROR:  current transaction is aborted, commands ignored until end of
 transaction block
 +ERROR:  current transaction is aborted, commands ignored until end of
 transaction block
 +ERROR:  current transaction is aborted, commands ignored until end of
 transaction block
 +ERROR:  current transaction is aborted, commands ignored until end of
 transaction block
 +ERROR:  current transaction is aborted, commands ignored until end of
 transaction block
 +ERROR:  current transaction is aborted, commands ignored until end of
 transaction block
 +ERROR:  current transaction is aborted, commands ignored until end of
 transaction block
 +ERROR:  current transaction is aborted, commands ignored until end of
 transaction block
 +ERROR:  current transaction is aborted, commands ignored until end of
 transaction block
 +ERROR:  current transaction is aborted, commands ignored until end of
 transaction block
 +ERROR:  current transaction is aborted, commands ignored until end of
 transaction block
 +ERROR:  current transaction is aborted, commands ignored until end of
 transaction block
 +ERROR:  current transaction is aborted, commands ignored until end of
 transaction block
 +ERROR:  current transaction is aborted, commands ignored until end of
 transaction block
 +ERROR:  current transaction is aborted, commands ignored until end of
 transaction block
  COMMIT
 -4
 -features.big_parcels.the_geom SRID:0 TYPE:MULTIPOLYGON DIMS:2
 -5
 -6
 -features.big_signs.the_geom SRID:0 TYPE:MULTIPOINT DIMS:2
 +ERROR:  relation "features.land_parcels" does not exist at character 13
 +ERROR:  relation "features.land_parcels" does not exist at character 13
 +ERROR:  relation "features.land_parcels" does not exist at character 13
 +ERROR:  relation "features.land_parcels" does not exist at character 13
 +ERROR:  relation "features.traffic_signs" does not exist at character 13
 +ERROR:  relation "features.traffic_signs" does not exist at character 13
 +ERROR:  relation "features.traffic_signs" does not exist at character 13
 +ERROR:  relation "features.traffic_signs" does not exist at character 13
 +ERROR:  relation "features.city_streets" does not exist at character 13
 +ERROR:  relation "features.city_streets" does not exist at character 13
 +ERROR:  relation "features.city_streets" does not exist at character 13
 +ERROR:  relation "features.city_streets" does not exist at character 13
 +ERROR:  syntax error at or near "OIDS" at character 78
 +ERROR:  schema "features" does not exist
 +ERROR:  Schema 'features' is not a valid schemaname
 +ERROR:  relation "features.big_parcels" does not exist at character 13
 +ERROR:  relation "features.big_parcels" does not exist at character 13
 +ERROR:  relation "features.big_parcels" does not exist at character 13
 +ERROR:  syntax error at or near "OIDS" at character 78
 +ERROR:  schema "features" does not exist
 +ERROR:  relation "features.big_streets" does not exist at character 13
 +ERROR:  relation "features.big_streets" does not exist at character 13
 +ERROR:  syntax error at or near "OIDS" at character 76
 +ERROR:  schema "features" does not exist
 +ERROR:  Schema 'features' is not a valid schemaname
 +ERROR:  relation "features.big_signs" does not exist at character 13
  BEGIN
 }}}


 topology is still failing for 12 for topoology even after adding the
 pg_constraint fix

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4251>
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.