Skip site navigation (1) Skip section navigation (2)

Re: Indexes generated for primary key are not show

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Constantin Stefanov" <cstef(at)mail(dot)ru>
Cc: "Andreas Pflug" <pgadmin(at)pse-consulting(dot)de>,<pgadmin-support(at)postgresql(dot)org>
Subject: Re: Indexes generated for primary key are not show
Date: 2004-02-09 14:11:06
Message-ID: 03AF4E498C591348A42FC93DEA9661B889F253@mail.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-support
 

> -----Original Message-----
> From: Constantin Stefanov [mailto:cstef(at)mail(dot)ru] 
> Sent: 09 February 2004 12:54
> To: Dave Page
> Cc: Andreas Pflug; pgadmin-support(at)postgresql(dot)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.

pgadmin-support by date

Next:From: Andreas PflugDate: 2004-02-09 15:12:41
Subject: Re: Indexes generated for primary key are not show
Previous:From: Constantin StefanovDate: 2004-02-09 12:53:30
Subject: Re: Indexes generated for primary key are not show

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group