Re: obj_unique_identifier(oid) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: obj_unique_identifier(oid)
Date
Msg-id 28358.1294429588@sss.pgh.pa.us
Whole thread Raw
In response to obj_unique_identifier(oid)  (Joel Jacobson <joel@gluefinance.com>)
Responses Re: obj_unique_identifier(oid)  (Joel Jacobson <joel@gluefinance.com>)
Re: obj_unique_identifier(oid)  (Jim Nasby <jim@nasby.net>)
Re: obj_unique_identifier(oid)  (Joel Jacobson <joel@gluefinance.com>)
List pgsql-hackers
Joel Jacobson <joel@gluefinance.com> writes:
> The function obj_unique_identifier(oid) will return a unique name for _any_ oid.

Surely this is broken by design?  You can *not* assume that the same OID
isn't in use for different things in different system catalogs.  They're
only guaranteed unique within a catalog.  That's the main reason why
pg_depend has to include the classid.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: system views for walsender activity
Next
From: Tom Lane
Date:
Subject: Re: system views for walsender activity