Skip site navigation (1) Skip section navigation (2)

Re: Indexes generated for primary key are not show

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 (view raw or flat)
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


In response to

Responses

pgadmin-support by date

Next:From: Constantin StefanovDate: 2004-02-12 08:40:39
Subject: Re: Indexes generated for primary key are not show
Previous:From: Dave PageDate: 2004-02-11 10:03:36
Subject: Re: Indexes generated for primary key are not show

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group