Re: Indexes generated for primary key are not show

> -----Original Message-----
> From: Constantin Stefanov [mailto:cstef@mail.ru]
> Sent: 11 February 2004 09:52
> To: Andreas Pflug
> Cc: Dave Page; pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] Indexes generated for primary
> key are not show
>
> Andreas Pflug wrote:
>
> > Well it's not really hard, just some things to think of. And the
> > longer I think about it, and looking at your example, I'd
> say people
> > analyzing a query should know a little what pgsql is doing,
> e.g. that
> > unique and primary constraints include an index. Thus I tend to say
> > we'll stay with what we got now.
> 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.

Well I can't say with abolute certainty that *all* do, but I would be
surprised if they didn't - after all, a pkey is only a unique index
which is flagged as primary and not null. Oracle certainly does
implement pkeys as indexes.

Regards, Dave.