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+MedixkY532xG7PP2v-hKF7xhAMtLDRXhNzvCuMdx+t0i7J3w@mail.gmail.com
обсуждение исходный текст
Ответы Re: pgAdmin3 1.16 and 1.14 don't show Covering Index on Foreign Keys
Список 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 beta3, 1.14.3.

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

PostgreSQL 9.1.4 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.
"Covering Index" is a very important feature.


--
With best regards,
Nikolay


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

Предыдущее
От: Guillaume Lelarge
Дата:
Сообщение: Re: Installing pgadmin3 using rpms
Следующее
От: Shefali Sharma
Дата:
Сообщение: SQL Query Pane issue