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

On Thu, 2012-03-15 at 10:30 -0400, BillR wrote:
> Apologies to Guillaume for the duplicate reply, but I didn't hit
> "reply to all" the first time so didn't actually reply to the list. So
> here it is again (the first time).
>

No problem :)

> >pgAdmin only shows the constraint. The fact that it's done with an
> >index
> >is an implementation detail
>
> So creating another index on the column with the 'unique' constraint
> is redundant I take it.

Yes.

> It would seem to me that this "implementation detail" is
> unnecessarily obscure/confusing. But that is with postgresql, not
> pgamin.

Exactly.

> To add to my first reply, I have noticed confusion WRT this from
> others on the web when trying to gain insight searching the web. So I
> know it's not just me. If creating another index is redundant, then I
> suspect there are a lot more redundant indexes out there because of
> the way this is implemented. But again, that is with Postgresql.

Exactly.

--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com