Re: [HACKERS] problems with TEMP table (6.5.3)

> 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(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