COMMENT ON CONSTRAINT
От | Sascha Ziemann |
---|---|
Тема | COMMENT ON CONSTRAINT |
Дата | |
Msg-id | m31xid21fb.fsf_-_@sn-e0310.ek.secunet.de обсуждение исходный текст |
Ответ на | Re: UNIQUE constraint (Michael Glaesemann <grzm@myrealbox.com>) |
Ответы |
Re: COMMENT ON CONSTRAINT
|
Список | 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 | SEQUENCEobject_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
В списке pgsql-sql по дате отправления: