Re: Indexes generated for primary key are not show

 

> -----Original Message-----
> From: Constantin Stefanov [mailto:cstef@mail.ru] 
> Sent: 09 February 2004 12:54
> To: Dave Page
> Cc: Andreas Pflug; pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] Indexes generated for primary 
> key are not show
> 
> 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.

Yes, psql is a good reference. It lists pkeys as 'Primary Key' but under
the indexes heading.

To be honest that is such a minor variation from what we already do that
I cannot see anyone getting the itch to recode the treeview to display
pkeys safely in both places. I for one do not believe it is worth the
extra complexity in the code to display an object in 2 places anyway.
Sorry :-)

Regards, Dave.

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend