Re: Bug in pg_describe_object - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Bug in pg_describe_object
Date
Msg-id 4514.1294710963@sss.pgh.pa.us
Whole thread Raw
In response to Re: Bug in pg_describe_object  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Bug in pg_describe_object  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Mon, Jan 10, 2011 at 7:52 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> My point is that this isn't a bug fix, it's more like moving the
>> goalposts on what getObjectDescription is supposed to do.

> I think that adding the types to the description string is a pretty
> sensible thing to do.

Not really.  AFAIR, there are two cases that exist in practice,
depending on which AM you're talking about:

1. The recorded types match the input types of the operator/function  (btree & hash).
2. The recorded types are always the same as the opclass's input type  (gist & gin).

In neither case does printing those types really add much information.
That's why it's not there now.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Itagaki Takahiro
Date:
Subject: Fwd: [TESTERS] [TEST REPORT] 9.1Alpha3 Feature E.1.4.7.2 in release notes.
Next
From: Tom Lane
Date:
Subject: Re: Fwd: [TESTERS] [TEST REPORT] 9.1Alpha3 Feature E.1.4.7.2 in release notes.