Re: Temporary indexes

> 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