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