| From: | Thom Brown <thom(at)linux(dot)com> |
|---|---|
| To: | pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org> |
| Subject: | Indexed constraint comments not working |
| Date: | 2013-05-26 22:20:18 |
| Message-ID: | CAA-aLv5hvE9XEZE8yOP58uS+QCLVv7vHEb+tapfx0ytpW1Fbnw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-hackers |
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
| Attachment | Content-Type | Size |
|---|---|---|
| fix_indexed_constraint_comment.patch | application/octet-stream | 1.1 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thom Brown | 2013-05-26 22:23:12 | Re: Indexed constraint comments not working |
| Previous Message | Dave Page | 2013-05-26 22:02:22 | pgAdmin III commit: Fix schema prefixes in cast definitions in the brow |