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

[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

Re: [HACKERS] Query crashes/hangs server

2005-03-17 Thread Qingqing Zhou
Bruce Momjian pgman@candle.pha.pa.us 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

Re: [HACKERS] Query crashes/hangs server

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

Re: [HACKERS] Query crashes/hangs server

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