On 11/24/2010 09:05 AM, Joachim Wieland wrote:
> On Wed, Nov 24, 2010 at 1:15 AM, Tom Lane<tgl@sss.pgh.pa.us> wrote:
>> Nope ... those strings are just helpful comments, they aren't really
>> guaranteed to be unique identifiers. In any case, it seems unlikely
>> that a user could expect to get the more complicated cases exactly right
>> other than by consulting "pg_dump | pg_restore -l" output. Which makes
>> the use-case kind of dubious to me.
> In which case would the catalogId, i.e. (tableoid, oid) not be unique?
> Or do you rather mean that it does not necessarily refer to the same
> object if that object got somehow recreated or that it could be
> different on different installations of the same database?
It would be unique, but a pain in the neck for users to get. Robert's
idea will have more traction with users.
cheers
andrew