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 по дате отправления: