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

From: Nikolay Ulyanitsky <lystor(at)gmail(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: pgAdmin3 1.16 and 1.14 don't show Covering Index on Foreign Keys
Date: 2012-08-20 06:27:46
Message-ID: CA+MediyAyqQOCjBPPdKA7UZx6H=_dW0VRxGmYtn2hbJAYw_NDg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 varying NOT NULL,
CONSTRAINT "pk-files-id" PRIMARY KEY (id ),
CONSTRAINT "fk-files-pkg_id" FOREIGN KEY (pkg_id)
REFERENCES pkgs (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

Browse pgadmin-support by date

  From Date Subject
Next Message bimal kanta panda 2012-08-22 11:16:46 regarding opening of pgAdmin III
Previous Message Linos 2012-08-19 18:25:11 pgadmin3 crash