| 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: | Whole Thread | Raw Message | 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
| 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 |