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

From Jim Nasby
Subject Re: obj_unique_identifier(oid)
Date
Msg-id 3FFEEAAD-9BBE-4429-AF21-FD29A27F7A23@nasby.net
Whole thread Raw
In response to Re: obj_unique_identifier(oid)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: obj_unique_identifier(oid)  (Joel Jacobson <joel@gluefinance.com>)
List pgsql-hackers
On Jan 7, 2011, at 1:46 PM, Tom Lane wrote:
> 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.

BTW, if you're looking at making pg_depnd easier to use, see
http://archives.postgresql.org/message-id/1290000774-sup-2218@alvh.no-ip.org
--
Jim C. Nasby, Database Architect                   jim@nasby.net
512.569.9461 (cell)                         http://jim.nasby.net




pgsql-hackers by date:

Previous
From: Joel Jacobson
Date:
Subject: Re: obj_unique_identifier(oid)
Next
From: Joachim Wieland
Date:
Subject: pg_dump directory archive format / parallel pg_dump