Re: [HACKERS] 7.0.2 dies when connection dropped mid-transaction

2000-11-11 Thread Alfred Perlstein
* The Hermit Hacker [EMAIL PROTECTED] [001109 20:19] wrote: On Thu, 9 Nov 2000, Tom Lane wrote: The Hermit Hacker [EMAIL PROTECTED] writes: Tom, if you can plug this one in the next, say, 48hrs (Saturday night), Done. Want to generate some new 7.0.3 release-candidate tarballs?

Re: [HACKERS] 7.0.2 dies when connection dropped mid-transaction

2000-11-09 Thread Tom Lane
Alfred Perlstein [EMAIL PROTECTED] writes: I have a program that does a: DECLARE getsitescursor CURSOR FOR select... I ^C'd it and it didn't properly shut down the channel to postgresql and I got this crash: ... These sources are the current CVS sources with the exception of some removed

Re: [HACKERS] 7.0.2 dies when connection dropped mid-transaction

2000-11-09 Thread Tom Lane
I said: So there's more to this than just killing a client that has a cursor. OK, after digging some more, it seems that the critical requirement is that the cursor's query contain a hash join. I've been able to reproduce a crash here... regards, tom lane

Re: [HACKERS] 7.0.2 dies when connection dropped mid-transaction

2000-11-09 Thread Tom Lane
I said: OK, after digging some more, it seems that the critical requirement is that the cursor's query contain a hash join. Here's the deal: test7=# set enable_mergejoin to off; SET VARIABLE test7=# begin; BEGIN -- I've previously checked that this produces a hash join plan: test7=# declare c

Re: [HACKERS] 7.0.2 dies when connection dropped mid-transaction

2000-11-09 Thread Bruce Momjian
I guess the immediate question is do we want to hold up 7.0.3 release for a fix? This bug is clearly ancient, so I'm not sure it's appropriate to go through a fire drill to fix it for 7.0.3. Comments? We have delayed 7.0.3 already. Tom is fixing so many bugs, we may find at some point that

Re: [HACKERS] 7.0.2 dies when connection dropped mid-transaction

2000-11-09 Thread Alfred Perlstein
* Bruce Momjian [EMAIL PROTECTED] [001109 18:55] wrote: I guess the immediate question is do we want to hold up 7.0.3 release for a fix? This bug is clearly ancient, so I'm not sure it's appropriate to go through a fire drill to fix it for 7.0.3. Comments? We have delayed 7.0.3

Re: [HACKERS] 7.0.2 dies when connection dropped mid-transaction

2000-11-09 Thread The Hermit Hacker
On Thu, 9 Nov 2000, Alfred Perlstein wrote: * Bruce Momjian [EMAIL PROTECTED] [001109 18:55] wrote: I guess the immediate question is do we want to hold up 7.0.3 release for a fix? This bug is clearly ancient, so I'm not sure it's appropriate to go through a fire drill to fix it for

Re: [HACKERS] 7.0.2 dies when connection dropped mid-transaction

2000-11-09 Thread Tom Lane
The Hermit Hacker [EMAIL PROTECTED] writes: Tom, if you can plug this one in the next, say, 48hrs (Saturday night), please do ... else, I'll announce 7.0.3 on Saturday night and we'll leave it with such a large showstopper :( I do have an idea for a simple stopgap answer --- testing now ...

Re: [HACKERS] 7.0.2 dies when connection dropped mid-transaction

2000-11-09 Thread Tom Lane
The Hermit Hacker [EMAIL PROTECTED] writes: Tom, if you can plug this one in the next, say, 48hrs (Saturday night), Done. Want to generate some new 7.0.3 release-candidate tarballs? regards, tom lane

Re: [HACKERS] 7.0.2 dies when connection dropped mid-transaction

2000-11-09 Thread The Hermit Hacker
On Thu, 9 Nov 2000, Tom Lane wrote: The Hermit Hacker [EMAIL PROTECTED] writes: Tom, if you can plug this one in the next, say, 48hrs (Saturday night), Done. Want to generate some new 7.0.3 release-candidate tarballs? Done, and just forced a sync to ftp.postgresql.org of the new tarballs

Re: [HACKERS] 7.0.2 dies when connection dropped mid-transaction

2000-11-09 Thread Alfred Perlstein
* The Hermit Hacker [EMAIL PROTECTED] [001109 20:19] wrote: On Thu, 9 Nov 2000, Tom Lane wrote: The Hermit Hacker [EMAIL PROTECTED] writes: Tom, if you can plug this one in the next, say, 48hrs (Saturday night), Done. Want to generate some new 7.0.3 release-candidate tarballs?