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? So isn't this redundant. 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.
http://www.postgresql.org/docs/9.1/interactive/ddl-constraints.html#AEN2470
Regards,
BillR