Thread

Re: Query crashes/hangs server

Tatsuo Ishii <t-ishii@sra.co.jp> — 2005-03-18T07:55:42Z

> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > I recieved this report of a failing set of queries:
> 
> Fixed.  ShutdownPostgres needs to be sure we've released buffer pins
> before it tries to drop newly-created files.  This has actually been
> wrong all along, but it is masked pre-8.0 because DropRelFileNodeBuffers
> was willing to arbitrarily throw away a pin on a victim buffer.
> I thought that was a bad idea and took it out, expecting that we'd find
> any bad consequences a bit quicker than this ...

It seems your patches do not fix the case when the table is a
temporary table...
--
Tatsuo Ishii