Re: [BUGS] inner query bug

2003-11-25 Thread Tom Lane
Andrew Holm-Hansen [EMAIL PROTECTED] writes: SC2test7=# select * from txstatus,tx txx where txstatus.txid = txx.txid AND txstatus.statuschangetime = (select max(txstatus.statuschangetime) from txstatus where txstatus.txid = txx.txid); FATAL: terminating connection due to administrator command

Re: [BUGS] inner query bug

2003-11-25 Thread Andrew Holm-Hansen
I tried copying the text of the patch into a file and running patch on it, but apparently I'm somehow impaired. Manually patched the relevant files, and it appears to be working just fine. Thanks for all your help, it was really much more than I expected. Andrew Holm-Hansen [EMAIL PROTECTED]

Re: [BUGS] inner query bug

2003-11-24 Thread Tom Lane
Neil Conway [EMAIL PROTECTED] writes: When we were discussing this on IRC, I made sure to check it was a recent version of PG -- I believe it is 7.4.0. The last reported instance I could see of a bug with this symptom was for 7.4 beta 1 (at which point we thought we'd fixed it). Yeah, I don't

[BUGS] inner query bug

2003-11-22 Thread Andrew Holm-Hansen
I was advised to send an e-mail after a discussion with neilc on #postgresql. The failure occurs randomly, never on the first time (at least that I've seen) and usually only after doing a bunch of other stuff first (big joins, views, etc). In one case, the backend terminated and restarted, this