On Tue, Jan 25, 2005 at 12:43:16PM -0500, Matthew T. O'Connor wrote: > foo=# ALTER TABLE foo ADD unique (id1,id3); > NOTICE: ALTER TABLE / ADD UNIQUE will create implicit index > "foo_id1_key" for table "foo" > ERROR: relation "foo_id1_key" already exists
8.0.0 handles this situation better: test=> create table foo (id1 int, id2 int, id3 int); CREATE TABLE test=> ALTER TABLE foo ADD unique (id1,id2); NOTICE: ALTER TABLE / ADD UNIQUE will create implicit index "foo_id1_key" for table "foo" ALTER TABLE test=> ALTER TABLE foo ADD unique (id1,id3); NOTICE: ALTER TABLE / ADD UNIQUE will create implicit index "foo_id1_key1" for table "foo" ALTER TABLE -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
