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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Pflug | 2004-02-09 15:12:41 | Re: Indexes generated for primary key are not show |
Previous Message | Constantin Stefanov | 2004-02-09 12:53:30 | Re: Indexes generated for primary key are not show |