X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 76F1414B2825 for ; Wed, 11 Aug 2004 11:30:03 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 10762-05 for ; Wed, 11 Aug 2004 14:29:47 +0000 (GMT) Received: from mailgate.cubis.de (send.cubis.de [195.226.172.140]) by svr1.postgresql.org (Postfix) with ESMTP id 6400F14B2800 for ; Wed, 11 Aug 2004 11:29:40 -0300 (ADT) Received: from mailscan-1.tuev-mitte.de (mailscan-1.tuev-mitte.de [10.0.142.44] (may be forged)) by mailgate.cubis.de (Switch-2.2.9/Switch-2.2.4) with SMTP id W7BE0TYH0000126C for ; Wed, 11 Aug 2004 16:29:34 +0200 Received: From mailscan-2.tuev-mitte.de ([10.0.142.43]) by mailscan-1.tuev-mitte.de (WebShield SMTP v4.5 MR1a P0803.345); id 109223458184; Wed, 11 Aug 2004 16:29:41 +0200 Received: From sn-e0310.ek.secunet.de ([10.36.13.215]) by mailscan-2.tuev-mitte.de (WebShield SMTP v4.5 MR1a P0803.354); id 10922345748; Wed, 11 Aug 2004 16:29:34 +0200 Received: from sn-e0310.ek.secunet.de (localhost [127.0.0.1]) by sn-e0310.ek.secunet.de (Postfix) with ESMTP id 92E6F57A84 for ; Wed, 11 Aug 2004 16:29:28 +0200 (CEST) To: pgsql-sql@postgresql.org Subject: COMMENT ON CONSTRAINT From: Sascha Ziemann Date: 11 Aug 2004 16:29:28 +0200 In-Reply-To: <7E5F5B5E-E996-11D8-B87D-000A95C88220@myrealbox.com> Message-ID: Lines: 46 User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.2 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.6 tagged_above=0.0 required=5.0 tests=LINES_OF_YELLING, SUBJ_ALL_CAPS X-Spam-Level: X-Archive-Number: 200408/126 X-Sequence-Number: 18623 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