From: | Dave Page <dpage(at)pgadmin(dot)org> |
---|---|
To: | Thom Brown <thom(at)linux(dot)com> |
Cc: | pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org> |
Subject: | Re: Indexed constraint comments not working |
Date: | 2013-05-26 22:35:12 |
Message-ID: | CA+OCxoxk-2Qx-odEmeTZPz=h6-73RJNZTCxUZ8addHebjV-iKg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
Thanks - patch applied.
On Sun, May 26, 2013 at 10:20 PM, Thom Brown <thom(at)linux(dot)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';
>
> Viewing the property list of the constraint, the SQL pane and the
> constraint editor dialogue doesn't show the comment.
>
> Fix attached.
>
> --
> Thom
>
>
> --
> Sent via pgadmin-hackers mailing list (pgadmin-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-hackers
>
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
From | Date | Subject | |
---|---|---|---|
Next Message | Neel Patel | 2013-05-28 12:51:49 | Materialized View Patch File |
Previous Message | Dave Page | 2013-05-26 22:35:03 | pgAdmin III commit: Fix comments on constraints |