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 -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers
