Re: Indexed constraint comments not working - Mailing list pgadmin-hackers

From Thom Brown
Subject Re: Indexed constraint comments not working
Date
Msg-id CAA-aLv586_38qsWhYUyBRfO3XfUXC=QQo+N5UNBymj+-ZmeFRQ@mail.gmail.com
Whole thread Raw
In response to Indexed constraint comments not working  (Thom Brown <thom@linux.com>)
List pgadmin-hackers
On 26 May 2013 18:20, Thom Brown <thom@linux.com> wrote:
> Hi all,
>
> Comments on indexed constraints (primary keys, exclusion constraints
> etc.) are failing due to referencing the wrong alias of the relevant
> pg_description join in the join clause.
>
> Test case:
>
> CREATE TABLE test (id int);
>
> ALTER TABLE test
> ADD CONSTRAINT cnt_x_test
> EXCLUDE USING btree (id WITH =);
>
> COMMENT ON CONSTRAINT cnt_x_test ON
> COMMENT ON CONSTRAINT cnt_x_test
>   ON test IS 'Hello';

Paste fail.  Please ignore the first "COMMENT ON..." line.

--
Thom


pgadmin-hackers by date:

Previous
From: Thom Brown
Date:
Subject: Indexed constraint comments not working
Next
From: Dave Page
Date:
Subject: pgAdmin III commit: Fix comments on constraints