On Wed, 2012-03-14 at 22:46 -0400, BillR wrote:
> This may be a little late, but according to the postgres documentation,
> isn't an index supposed to be created automatically by postgres when you
> create a unique or primary key constraint?
Yes, it is.
> So isn't this redundant.
The support for using an already existing index to add this kind of
constraint? not at all, it's actually great. It allows a user to add
this kind of constraints quicker.
> Note
> that I am not sure because I created a unique constraint in an 8.4 db
> using pgadmin *and* via DDL in the sql editor, and an index did not
> appear to be created; counter to what the docs say is supposed to
> happen. I'd be interested to hear someone's take on this.
>
pgAdmin only shows the constraint. The fact that it's done with an index
is an implementation detail.
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com