Re: patch: Allow \dd to show constraint comments - Mailing list pgsql-hackers

From Thom Brown
Subject Re: patch: Allow \dd to show constraint comments
Date
Msg-id CAA-aLv44JH6v0isfA6mMkDL-WjQpTDWXyqGyUh9EdtscM6QQEA@mail.gmail.com
Whole thread Raw
In response to Re: patch: Allow \dd to show constraint comments  (Josh Kupershmidt <schmiddy@gmail.com>)
Responses Re: patch: Allow \dd to show constraint comments
List pgsql-hackers
On 18 August 2011 00:22, Josh Kupershmidt <schmiddy@gmail.com> wrote:
> On Wed, Jul 20, 2011 at 11:38 PM, Josh Kupershmidt <schmiddy@gmail.com> wrote:
>
>> Updated patch attached, along with a revised SQL script to make
>> testing easier. I can add this to the next CF.
>>
>> Note, there is a separate thread[1] with just the psql changes broken
>> out, if it's helpful to consider the psql changes separately from
>> pg_comments. I do need to update the patch posted there with this
>> latest set of changes.
>
> The psql changes mentioned above have been committed, so the only
> piece remaining is the pg_comments view. I did some light touching up
> of the changes in catalogs.sgml: clarify that 'objoid' comes from
> either pg_description or pg_shdescription, and try to use periods a
> bit more consistently.
>
> Rebased and updated patch attached.

Just tested this out on current master.  I tried this on every object
capable of having a comment, and the view reports all of them with the
correct details.  Doc changes look fine, except for some reason you
removed a full-stop (period) from after "For all other object types,
this column is zero."

-- 
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [REVIEW] prepare plans of embedded sql on function start
Next
From: Josh Berkus
Date:
Subject: Re: [WIP] Caching constant stable expressions per execution