Re: Query crashes/hangs server - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: Query crashes/hangs server
Date
Msg-id 20050318.165542.15266653.t-ishii@sra.co.jp
Whole thread Raw
In response to Re: Query crashes/hangs server  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Query crashes/hangs server  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> 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


pgsql-hackers by date:

Previous
From: Neil Conway
Date:
Subject: Re: read-only planner input
Next
From: Michael Fuhr
Date:
Subject: "they only drink coffee at dec"