Re: [HACKERS] Query crashes/hangs server

2005-03-18 Thread Tom Lane
Tatsuo Ishii <[EMAIL PROTECTED]> writes: > It seems your patches do not fix the case when the table is a > temporary table... Ah, should've thought to try that case too. Thanks, Tatsuo. regards, tom lane ---(end of broadcast)--

Re: [HACKERS] Query crashes/hangs server

2005-03-17 Thread Tatsuo Ishii
> Bruce Momjian 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 DropRelFileNodeBuffer

Re: [HACKERS] Query crashes/hangs server

2005-03-17 Thread Tom Lane
Bruce Momjian 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 willin

Re: [HACKERS] Query crashes/hangs server

2005-03-17 Thread Qingqing Zhou
"Bruce Momjian" > I recieved this report of a failing set of queries: > > BEGIN; > CREATE TABLE a (i INT); > INSERT INTO a VALUES(1); > DECLARE acur CURSOR FOR SELECT * FROM a; > FETCH acur; > \q > > It certainly looks like a simple set of queries. > > If this is done in 8.0.X the server shows: >

[HACKERS] Query crashes/hangs server

2005-03-17 Thread Bruce Momjian
I recieved this report of a failing set of queries: BEGIN; CREATE TABLE a (i INT); INSERT INTO a VALUES(1); DECLARE acur CURSOR FOR SELECT * FROM a; FETCH acur; \q It certainly looks like a simple set of queries. If this is done in 8.0.X the server