[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:  strk
      Type:  defect             |     Status:  closed
  Priority:  blocker            |  Milestone:  PostGIS 3.7.0
 Component:  topology           |    Version:  master
Resolution:  fixed              |   Keywords:
--------------------------------+---------------------------
Comment (by Darafei Praliaskouski <me@…>):

 In [changeset:"d8c292cc72989b8f151a20ee7ddce73f8a2784a4/git"
 d8c292cc/git]:
 {{{#!CommitTicketReference repository="git"
 revision="d8c292cc72989b8f151a20ee7ddce73f8a2784a4"
 postgis: avoid stale geometry_columns relation lookups

 Filter stale pg_class rows from geometry_columns by re-resolving visible
 schema-qualified names before exposing metadata, while keeping
 inaccessible schemas on OID-based privilege checks that do not resolve
 hidden names. Require the current SELECT privilege result in both visible
 and hidden paths so stale snapshots do not keep exposing metadata after
 relation drops or SELECT revokes.

 Closes #6038

 Closes https://github.com/postgis/postgis/pull/915

 (cherry picked from commit 6f11ffd051915508ef244399043b484a2de46295)
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/6038#comment:16>
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.