Re: Indexes generated for primary key are not show - Mailing list pgadmin-support

From Christopher Kings-Lynne
Subject Re: Indexes generated for primary key are not show
Date
Msg-id 402ADCDD.50809@familyhealth.com.au
Whole thread Raw
In response to Re: Indexes generated for primary key are not show  (Constantin Stefanov <cstef@mail.ru>)
Responses Re: Indexes generated for primary key are not show
List 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



pgadmin-support by date:

Previous
From: "Dave Page"
Date:
Subject: Re: Indexes generated for primary key are not show
Next
From: Constantin Stefanov
Date:
Subject: Re: Indexes generated for primary key are not show