Re: Indexes generated for primary key are not show - Mailing list pgadmin-support

From Constantin Stefanov
Subject Re: Indexes generated for primary key are not show
Date
Msg-id 402782CA.1000708@mail.ru
Whole thread Raw
In response to Re: Indexes generated for primary key are not show  ("Dave Page" <dpage@vale-housing.co.uk>)
Responses Re: Indexes generated for primary key are not show
Re: Indexes generated for primary key are not show
List pgadmin-support
Dave Page wrote:

> The primary question remains though, why should we expose implementation
> details of something like a primary key when we already show the primary
> key itself? It's not like you cannot see the columns in it or anything.
> Should we by the same argument show the triggers that implement foreign
> keys, or rules that implement views?
I think at least to have an option (maybe not permanent, but something
like menu item 'show all details') would be useful. As for indexes - as
I said, they are needed for understanding planner desicions. As for
other parts (rules, auto-generated triggers etc.) - I don't know.
As for quick solution I would suggest checking with psql - if it can
shows something, then PgAdmin should have an option to show it. I think
many people use psql and it has almost all features needed for working
with PostgreSQL (but it is less convenient than PgAdmin). As for me,
when working with and something seems strange, it is psql where I look
for final answer.

-- 
Constantin Stefanov

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
              http://archives.postgresql.org



pgadmin-support by date:

Previous
From: Constantin Stefanov
Date:
Subject: Re: Indexes generated for primary key are not show
Next
From: "Dave Page"
Date:
Subject: Re: Indexes generated for primary key are not show