Skip site navigation (1) Skip section navigation (2)

Re: obj_unique_identifier(oid)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joel Jacobson <joel(at)gluefinance(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: obj_unique_identifier(oid)
Date: 2011-01-07 19:46:28
Message-ID: 28358.1294429588@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Joel Jacobson <joel(at)gluefinance(dot)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

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2011-01-07 19:51:39
Subject: Re: system views for walsender activity
Previous:From: Simon RiggsDate: 2011-01-07 19:41:38
Subject: Re: system views for walsender activity

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group