Kevin, thanks a lot for your answer! As my servers are production systems
and as I have an acceptable workaround for my needs, I will wait around with
a postgresql upgrade =)
I just tried to help with discovering of a potential bug =)) Anyway I'm very
glad to know, that in new version it's not an
SELECT VERSION();
produces
"PostgreSQL 8.4.5 on x86_64-pc-linux-gnu, compiled by GCC
x86_64-pc-linux-gnu-gcc (Gentoo 4.4.4-r2 p1.3, pie-0.4.5) 4.4.4, 64-bit"
Best regards,
Alex
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Monday, August 08, 2011 10:02 PM
To: Kevin
Oops.. I just saw, that I send you "correct" (already with "workaround")
sql-code instead of "wrong"...
my mistake =(( don't kill me - I spend too much time with this piece of code
today...
But I'm sure that you got the point from my description of the results...
but just in case here is "wrong"
Kevin and all others, thanks for your work!
-Original Message-
From: Kevin Grittner [mailto:kevin.gritt...@wicourts.gov]
Sent: Tuesday, August 09, 2011 12:32 AM
To: ai; 'Tom Lane'
Cc: pgsql-bugs@postgresql.org
Subject: RE: [BUGS] BUG #6154: wrong result with nested left-
Thank you! =)
Best Regards, Alex
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Tuesday, August 09, 2011 11:53 AM
To: ai
Cc: Kevin Grittner; pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #6154: wrong result with nested left-joins
I wrote:
> "Kevin
Ok, thanks! I found out this issue a three years ago and then there isn't
such explanation... (all this time I've used some workaround) my mistake,
that I didn't look at the new manual before I reported this issue =(
My apologies for wasting your time =(
Best Regards, Alex
-Original Message
The following bug has been logged online:
Bug reference: 5265
Logged by: AI Rumman
Email address: irum...@gmail.com
PostgreSQL version: 8.3.8
Operating system: Linux
Description:incomplete startup packet
Details:
Jan 5 18:19:35 dev04 postgres[14342]: [1419-1
Full Text index is not using during OR operation for multiple table join:
explain
SELECT crmentity.crmid, crmentity.setype, crmentity.modifiedtime,
activity.subject,case when ( users.user_name not like '') then
users.user_name else groups.groupname end as user_name, activity.date_start
FROM crmenti
