Re: Indexes generated for primary key are not show

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

In response to

Responses

Browse pgadmin-support by date

  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