> 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?
Oh, I see now, I was creating the index on temptest, not masktest.
Sorry. It works fine.
-- 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
