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