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
fix_indexed_constraint_comment.patch
Description: Binary data
-- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers
