[email protected] writes:
> I'd like to bring attention to a metadata visibility issue when multiple
> schemas contain sequences with identical names, and a table column references
> one of them via nextval(). Currently, there appears to be no reliable way to
> determine which schema's sequence is actually referenced through system
> catalogs or views.
The documented behavior of type regclass is that it schema-qualifies
the output name if the table/sequence/whatever would not be found by
searching the current search_path. If you want something more
predictable, you could "set search_path = pg_catalog" before
inspecting the system catalogs.
regards, tom lane
