comment on COLUMN, broken or misunderstanding?

From: Bryce Nesbitt <bryce1(at)obviously(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: comment on COLUMN, broken or misunderstanding?
Date: 2008-02-18 02:18:26
Message-ID: 47B8EAF2.6070208@obviously.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I'm expecting COLUMN comments to work much like table comments, but I'm
getting nothing back. Is this a reportable bug, or a misunderstanding?

# comment on column sched.days is 'Bitmask 0=Sunday,7=Holiday, 8=School
day, 9=Special';
COMMENT
# \dd sched.days;
Schema | Name | Object | Description
--------+------+--------+-------------
(0 rows)

# comment on table sched is 'Table comment';
COMMENT
ez-sched=# \dd sched;
Object descriptions
Schema | Name | Object | Description
--------+-------+--------+---------------
public | sched | table | Table comment
(1 row)

# select * from version();
PostgreSQL 8.2.6 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.2.1
(SUSE Linux)

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2008-02-18 02:35:03 Re: comment on COLUMN, broken or misunderstanding?
Previous Message Peter Eisentraut 2008-02-17 15:23:04 Re: Backward compatibility psql 8.1 to 8.2