Re: [PATCH] Support for ALTER TABLE ADD UNIQUE/PKEY USING INDEX

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