Indexed constraint comments not working

Поиск
Список
Период
Сортировка
От Thom Brown
Тема Indexed constraint comments not working
Дата
Msg-id CAA-aLv5hvE9XEZE8yOP58uS+QCLVv7vHEb+tapfx0ytpW1Fbnw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Indexed constraint comments not working  (Thom Brown <thom@linux.com>)
Re: Indexed constraint comments not working  (Dave Page <dpage@pgadmin.org>)
Список 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

Вложения

В списке pgadmin-hackers по дате отправления:

Предыдущее
От: Dave Page
Дата:
Сообщение: pgAdmin III commit: Fix schema prefixes in cast definitions in the brow
Следующее
От: Thom Brown
Дата:
Сообщение: Re: Indexed constraint comments not working