[HACKERS] Postgresql crash (signal 11). keywords: distinct, subselect, union

2006-02-13 Thread Magnus Naeslund(f)
I just wanted to check if this has been fixed in any recent v8.1.x release, since I'm using v8.1.0 now. Backtrace: Program received signal SIGSEGV, Segmentation fault. 0x08152448 in qual_is_pushdown_safe () (gdb) bt #0 0x08152448 in qual_is_pushdown_safe () #1 0x08151e47 in

Re: [HACKERS] Postgresql crash (signal 11). keywords: distinct, subselect, union

2006-02-13 Thread Tom Lane
Magnus Naeslund(f) [EMAIL PROTECTED] writes: SELECT DISTINCT * FROM ( SELECT vtgm.snicker_id FROM snicker_group_mapping vtgm WHERE exists ( SELECT * FROM snicker_group vtg WHERE vtgm.snicker_group_id = vtg.id

Re: [HACKERS] Postgresql crash (signal 11). keywords: distinct, subselect, union

2006-02-13 Thread Tom Lane
Magnus Naeslund(f) [EMAIL PROTECTED] writes: I just wanted to check if this has been fixed in any recent v8.1.x release, since I'm using v8.1.0 now. Here's the fix if you need it. regards, tom lane Index: allpaths.c