[PostGIS] #6038: Using public.geometry_columns causes 'could not open relation with OID 188954716' after drop geometry tables

[PostGIS]

#6038: Using public.geometry_columns causes  'could not open relation with OID
188954716' after drop geometry tables
--------------------------------+---------------------
  Reporter:  Lars Aksel Opsahl  |      Owner:  pramsey
      Type:  defect             |     Status:  new
  Priority:  blocker            |  Milestone:
 Component:  postgis            |    Version:  master
Resolution:                     |   Keywords:
--------------------------------+---------------------
Comment (by Lars Aksel Opsahl):

 The problem seems not to be related to public.geometry_columns changing
 OID

 {{{

 [local] lop at t1=# SELECT 'public.geometry_columns'::regclass::oid;
     oid
 -----------
  188950672
 (1 row)

 [local] lop at t1=# select SRID from public.geometry_columns where
 (f_table_schema = 't1') and f_table_name = 'edge_data' and
 f_geometry_column = 'geom';
 ERROR:  XX000: could not open relation with OID 188967127
 LOCATION:  relation_open, relation.c:62
 [local] lop at t1=# SELECT 'public.geometry_columns'::regclass::oid;
 ERROR:  25P02: current transaction is aborted, commands ignored until end
 of transaction block
 LOCATION:  exec_simple_query, postgres.c:1144
 [local] lop at t1=# \q
 lop at Larss-MacBook-Pro-2 rmp_ws_03 % psql t1
 Null display is "[NULL]".
 Expanded display is used automatically.
 psql (16.10 (Homebrew))
 Type "help" for help.

 [local] lop at t1=# SELECT 'public.geometry_columns'::regclass::oid;
     oid
 -----------
  188950672
 (1 row)

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