Re: Bug in psql (\dd query)

On 08/21/13 16:34, Ivan Radovanovic napisa:
> On 08/21/13 16:03, Tom Lane napisa:
>> Ivan Radovanovic<radovanovic@gmail.com> writes:
>>> I was checking for way to get object comments, and it seems that \dd has
>>> bug when it comes to extracting descriptions for constraints.
>>
>> That code looks right to me, and it works according to a simple test:
>>
>> d1=# create table foo (f1 int primary key);
>> CREATE TABLE
>> d1=# comment on constraint foo_pkey on foo is 'here is a comment';
>> COMMENT
>> d1=# \dd
>> Object descriptions
>> Schema | Name | Object | Description
>> --------+----------+------------+-------------------
>> public | foo_pkey | constraint | here is a comment
>> (1 row)
>>
>> What exactly do you think the problem is?
>>
>> regards, tom lane
>
> Problem is if you create table in schema other than public (I am not
> sure if \dd should show comments only for objects in public schema, I
> assumed not?)
>
> db=# create schema test;
> CREATE SCHEMA
> db=# create table test.foo (f1 int primary key);
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "foo_pkey"
> for table "foo"
> CREATE TABLE
> db=# comment on constraint foo_pkey on test.foo is 'here is a comment';
> COMMENT
> db=# \dd
> Object descriptions
> Schema | Name | Object | Description
> --------+------+--------+-------------
> (0 rows)
>

Obviously there is optional pattern argument for \dd which would show
comments in different schema, so I it was my mistake after all.

Sorry for false alarm