Do we have temporary indexes?
test=> CREATE TABLE temptest(col INTEGER);
CREATE
test=> create index ix on temptest (col);
CREATE
test=> CREATE TEMP TABLE masktest (col INTEGER);
CREATE
test=> 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026