> -----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