Rod Taylor wrote: > On Sat, 2002-07-13 at 10:29, Bruce Momjian wrote: > > Rod Taylor wrote: > > > > > I prefer ...add constraint. After a while (release or 2) removal of > > > > > create unique index all together. > > > > > > > > Remove CREATE UNIQUE INDEX entirely? Why? > > > > > > I was looking to encourage users to use core SQL as I spend more time > > > than I want converting between systems -- thanks in part to users who > > > create non-portable structures. > > > > > > Temporarily forgot there are index types other than btree :) > > > > Not so much non-btree, but non-unique indexes themselves. UNIQUE index > > is funny because it is a constraint and an performance utility. I see > > your point that a constraint is more ANSI standard, but because we can't > > Yup. Makes sense. I submitted a patch which retains the difference. > If the index is created with CREATE UNIQUE, it's dumped with CREATE > UNIQUE. Constraint UNIQUE is treated likewise.
Yes, very nice. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
