Indexes generated for primary key are not show by PgAdminIII. - Mailing list pgadmin-support

From Constantin Stefanov
Subject Indexes generated for primary key are not show by PgAdminIII.
Date
Msg-id 40178D4D.9000303@mail.ru
Whole thread Raw
Responses Re: Indexes generated for primary key are not show  (Andreas Pflug <pgadmin@pse-consulting.de>)
List pgadmin-support
Hello.

I have PgAdmin III 1.0.2 and PostgreSQL 7.4.1.
When I create a table with primary key constraint on it, PostgreSQL
automatically creates an index on that column (or columns), which is
then shown in psql with \di command.
But PgAdmin does not show that index in
...Tables-> <table name> -> Indexes in the left frame.
Sometimes it is useful to see all indexes on the table (for example,
when trying to understand planner decisions), because planner makes use
of those indexes.

So I suggest PgAdmin to show all indexes (user and system-generated) or
to have an option to show them all.

-- 
Constantin Stefanov


pgadmin-support by date:

Previous
From: Jean-Michel POURE
Date:
Subject: Re: pgadmin 3 on SUSE linux 9.0
Next
From: "Bob Kesselman"
Date:
Subject: pgadminIII possible bug