Re: Bug in pg_describe_object - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Bug in pg_describe_object
Date
Msg-id 19441.1294764192@sss.pgh.pa.us
Whole thread Raw
In response to Re: Bug in pg_describe_object  (Joel Jacobson <joel@gluefinance.com>)
Responses Re: Bug in pg_describe_object  (Andreas Karlsson <andreas@proxel.se>)
List pgsql-hackers
Joel Jacobson <joel@gluefinance.com> writes:
> 2011/1/11 Tom Lane <tgl@sss.pgh.pa.us>:
>> Seems like concatenating the OIDs would accomplish that. �(If you
>> think not, well, you still haven't explained what problem you're trying
>> to solve...)

> The can be different in two different databases sharing the same
> original schema, but of two different versions.
> In this case it is better to compare textual strings describing the
> objects than to compare based on oids.

If that's what you're after, getObjectDescription is entirely
unsuitable, because of the fact that its results are dependent
on search path and language settings.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Joel Jacobson
Date:
Subject: Re: pg_depend explained
Next
From: Tom Lane
Date:
Subject: Re: pg_depend explained