Re: Bug in pg_describe_object - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Bug in pg_describe_object
Date
Msg-id 17558.1294758723@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  (Joel Jacobson <joel@gluefinance.com>)
Re: Bug in pg_describe_object  (Florian Pflug <fgp@phlo.org>)
List pgsql-hackers
Joel Jacobson <joel@gluefinance.com> writes:
> I instead propose we introduce a new function named
> pg_get_object_unique_identifier( classid oid, objid oid, objsubid
> integer ) returns text.

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 name would make sense since we already have a
> pg_get_function_identity_arguments( func_oid ), for a similar purpose
> but solely for functions.

No, that does not exist for the purpose you claim it does.  And it's far
from obvious what the extension of that to all object classes would
look like.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Jan Urbański
Date:
Subject: Re: autogenerating error code lists (was Re: [COMMITTERS] pgsql: Add foreign data wrapper error code values for SQL/MED.)
Next
From: Alvaro Herrera
Date:
Subject: Re: Bug in pg_describe_object