[postgis-tickets] [PostGIS] #4553: tickets.sql fail with --schema postgis (UpdateGeometrySRID?)

[PostGIS]

#4553: tickets.sql fail with --schema postgis (UpdateGeometrySRID?)
---------------------+---------------------------
 Reporter:  strk     |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  medium   |  Milestone:  PostGIS 3.0.0
Component:  postgis  |    Version:  trunk
 Keywords:           |
---------------------+---------------------------
 Running this:
 {{{
 regress/run_test.pl --schema postgis -v regress/core/tickets.sql
 }}}

 Fail as follows:
 {{{
  regress/core/tickets .. failed (diff expected obtained:
 /tmp/pgis_reg/test_1_diff)
 -----------------------------------------------------------------------------
 --- regress/core/tickets_expected       2019-08-26 14:00:15.408731758
 +0200
 +++ /tmp/pgis_reg/test_1_out    2019-10-18 17:17:23.518001330 +0200
 @@ -198,13 +198,12 @@
  ERROR:  transform: tolerance condition error (-20)
  #1580.3|Point[S]
  #1596.1|public.road_pg.roads_geom SRID:3395 TYPE:POINT DIMS:2
 -ERROR:  invalid SRID: 330000 not found in spatial_ref_sys
 +ERROR:  column not found in geometry_columns table
  #1596.3|3395
 -ERROR:  invalid SRID: 999000 not found in spatial_ref_sys
 +ERROR:  column not found in geometry_columns table
  #1596.5|3395
 -NOTICE:  SRID value -1 converted to the officially unknown SRID value 0
 -#1596.6|public.road_pg.roads_geom SRID changed to 0
 -#1596.7|0
 +ERROR:  column not found in geometry_columns table
 +#1596.7|3395
  #1596|Point[GS]
  #1695|MULTIPOLYGON EMPTY
  #1697.1|0
 -----------------------------------------------------------------------------
 }}}

 It looks like there's some wrong assumption in {{{ UpdateGeometrySRID }}}

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