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