pgAdmin3 1.16 and 1.14 don't show Covering Index on Foreign Keys

Поиск
Список
Период
Сортировка
От Nikolay Ulyanitsky
Тема pgAdmin3 1.16 and 1.14 don't show Covering Index on Foreign Keys
Дата
Msg-id CA+MediyAyqQOCjBPPdKA7UZx6H=_dW0VRxGmYtn2hbJAYw_NDg@mail.gmail.com
обсуждение исходный текст
Список pgadmin-support
Hello

pgAdmin3 1.16 / 1.14 don't show "Covering Index" values on Foreign Keys.
"Covering Index" values are always empty on "Properties" tab and
have default values (fki-fk-*) on "Foreign Key" dialogs.

Tested pgAdmin3 versions with bug: 1.16.0 beta4, 1.14.3.

pgadmin3 1.12.3 doesn't have this bug and shows covering indexes correctly.

PostgreSQL 9.1.5 x86_64
CentOS 6.3 x86_64

See screenshots:
* 1.12.3: http://s18.postimage.org/h1w5atycn/1_12_3.png
* 1.16.0: http://s17.postimage.org/xud5yf2h9/1_16_0.png


Example DB:

CREATE TABLE pkgs ( id serial NOT NULL, ... CONSTRAINT "pk-pkgs-id" PRIMARY KEY (id ),
)

CREATE TABLE files ( id bigserial NOT NULL, pkg_id integer NOT NULL, dir character varying NOT NULL, files character
varyingNOT NULL, CONSTRAINT "pk-files-id" PRIMARY KEY (id ), CONSTRAINT "fk-files-pkg_id" FOREIGN KEY (pkg_id)
REFERENCESpkgs (id) MATCH SIMPLE     ON UPDATE RESTRICT ON DELETE CASCADE
 
)


CREATE INDEX "ix-files-pkg_id" ON files USING btree (pkg_id);


Please fix it on 1.16.
"Covering Index" is a very important feature.


--
With best regards,
Nikolay



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

Предыдущее
От: Linos
Дата:
Сообщение: pgadmin3 crash
Следующее
От: bimal kanta panda
Дата:
Сообщение: regarding opening of pgAdmin III