Indexed constraint comments not working

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

Responses

Browse pgadmin-hackers by date

  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