COMMENT ON CONSTRAINT

From: Sascha Ziemann <ziemann(at)secunet(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: COMMENT ON CONSTRAINT
Date: 2004-08-11 14:29:28
Message-ID: m31xid21fb.fsf_-_@sn-e0310.ek.secunet.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

I have a problem with the COMMENT command. Here:

http://www.postgresql.org/docs/7.4/static/sql-comment.html

it is defined in this way:

COMMENT ON
{
TABLE object_name |
COLUMN table_name.column_name |
AGGREGATE agg_name (agg_type) |
CONSTRAINT constraint_name ON table_name |
DATABASE object_name |
DOMAIN object_name |
FUNCTION func_name (arg1_type, arg2_type, ...) |
INDEX object_name |
OPERATOR op (leftoperand_type, rightoperand_type) |
RULE rule_name ON table_name |
SCHEMA object_name |
SEQUENCE object_name |
TRIGGER trigger_name ON table_name |
TYPE object_name |
VIEW object_name
} IS 'text'

I would like to comment a constraint but it doesn't work. I did the
following:

create table tab3 (
a integer,
b integer,
constraint uni unique (a, b)
);

comment on constraint uni on table tab3 is 'unique pair';

Did I do anything wrong or is this a bug?

cu Sascha

--
secunet Security Networks AG, Im Teelbruch 116, 45219 Essen
Tel: +49-2054-123-408 Fax: +49-2054-123-123
PGP: FBE2 A49B 6526 C1B4 7F10 24E4 5004 7C27 6E9A 9698

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Rosser Schwarz 2004-08-11 14:41:37 Re: function expression in FROM may not refer to other relations of same query level
Previous Message David Garamond 2004-08-11 14:11:50 Displaying two tables side by side