Re: Foreing Key / Unique Contraint indexes

> -----Original Message-----
> From: pgadmin-support-owner(at)postgresql(dot)org
> [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of Jona
> Sent: 09 June 2005 11:00
> To: pgadmin-support(at)postgresql(dot)org
> Subject: [pgadmin-support] Foreing Key / Unique Contraint indexes
>
> Hey
> I'm unable to see the indexes for foreign keys and unique
> constraints on
> my tables, all other indexes are showing up fine in the table tree.

Do you mean Primary keys?

> Am running pgAdmin 3, 1.3.0 from May 20th 2005 up against either a
> PostGre 7.3.9 on Linux or a PostGre 8.0.3 on a Windows 2000 server.

I'm guessing you mean PostgreSQL ? :-)

> Is the issue in pgAdmin (that it doesn't show the indexes for some
> reason) or in PostGreSQL (that it doesn't create the indexes
> eventhough
> it says it does) ??

pgAdmin hides indexes that implement other types of object. The fact
that a unique constraint or a pkey is actually an index is an
implementation detail and is unimportant to the user, in the same way
that it is unimportant to show foreign keys as sets of triggers and
views as rules as they really are.

Regards, Dave.