| From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | Constantin Stefanov <cstef(at)mail(dot)ru> |
| 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 01:54:37 |
| Message-ID: | 402ADCDD.50809@familyhealth.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
> 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.
Chris
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Constantin Stefanov | 2004-02-12 08:40:39 | Re: Indexes generated for primary key are not show |
| Previous Message | Dave Page | 2004-02-11 10:03:36 | Re: Indexes generated for primary key are not show |