> I have a problem with 6.5.3 and TEMP table inside transaction.
>
> test=> vacuum;
> NOTICE: AbortTransaction and not in in-progress state
> ERROR: cannot write block 0 of pg_temp.8928.0 [test] blind
> test=>
>
Yes, there were some problems with temp tables and transaction scoping
that we could not fix in 6.5.*. Those are all addressed in 7.0.
>
> I checked 7.0 from cvs and it looks better.
>
> Also, I see a lot of opened files when doing
> select/inserts into temp table inside transaction
> (temp table was created before transaction). So,
> if I do a lot of selects/inserts I easily reach file description limit.
>
> Do I miss here ?
File descriptors are kept open as a cache. They will be closed as not
needed.
-- 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