Do we have temporary indexes?
test=> CREATE TABLE temptest(col INTEGER);CREATEtest=> create index ix on temptest (col);CREATEtest=> CREATE TEMP
TABLEmasktest (col INTEGER);CREATEtest=> create index ix on temptest (col);ERROR: Cannot create index: 'ix' already
exists
Seems we don't. Should I add it to the TODO list?
-- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026