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  (Andreas Seltenreich <seltenreich@gmx.de>)
Список 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 по дате отправления:

Предыдущее
От: Michalis Kabrianis
Дата:
Сообщение: Re: Sum and count weird results
Следующее
От: "Richard Hurst"
Дата:
Сообщение: Returning A Varchar From A Function