From: | Constantin Stefanov <cstef(at)mail(dot)ru> |
---|---|
To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
Cc: | Andreas Pflug <pgadmin(at)pse-consulting(dot)de>, Dave Page <dpage(at)vale-housing(dot)co(dot)uk>, pgadmin-support(at)postgresql(dot)org |
Subject: | Re: Indexes generated for primary key are not show |
Date: | 2004-02-12 08:40:39 |
Message-ID: | 402B3C07.5060102@mail.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Christopher Kings-Lynne wrote:
>> I can't completely agree with you. I use only PostgreSQL, but I used to
>> help my colleague working with Oracle (he was a novice), and I looked at
>> his result of EXPLAIN (it was different from what PostgreSQL gives, but
>> quite clear). I am not sure that in every database engine PRIMARY KEY
>> constraint is implemented using index. So you give some astonishment to
>> people not familiar with PostgreSQL but familiar with some other DBMS
>> and able to understand result of EXPLAIN.
>
> In phpPgAdmin, we list them separately as well, however it did require
> some thinking. In the end I decided to display things in the way the
> SQL spec lays them out. All constraints together, etc.
And do you display indexes which are automatically generated by PRIMARY
KEY constraint? I would not say those indexes should be in generated SQL
- they certainly should not. But I say those indexes should be displayed
where user-created indexes are. Dave says they shouldn't - well, he is a
developer of PgAdmin, and I will use PgAdmin whether this feature will
be implemented or not, it is useful and convenient tool. But I asked for
it because in my opinion it will make PgAdmin more convenient. The final
desicion is, of course, made by developers, I only try to convince them
that my suggestion makes sense.
Thanks for your attention.
--
Constantin Stefanov
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Kings-Lynne | 2004-02-12 09:10:52 | Re: Indexes generated for primary key are not show |
Previous Message | Christopher Kings-Lynne | 2004-02-12 01:54:37 | Re: Indexes generated for primary key are not show |