Re: [SQL] (possible) bug with constraint exclusion

2008-01-21 Thread Christian Schröder
Tom Lane wrote: Better look again. Sounds like a sensible advice ... I somehow managed to find http://archives.postgresql.org/pgsql-committers/2008-01/msg00183.php instead of http://archives.postgresql.org/pgsql-committers/2008-01/msg00184.php ... Sorry for that! Regards, Christian -

Re: [SQL] (possible) bug with constraint exclusion

2008-01-21 Thread Tom Lane
=?ISO-8859-1?Q?Christian_Schr=F6der?= <[EMAIL PROTECTED]> writes: >> It's a bug, it's patched: >> http://archives.postgresql.org/pgsql-committers/2008-01/msg00184.php >> > I have just stumbled on the same bug today and was very happy to find a > patch; however, I have a 8.2.6 server running which

Re: [SQL] (possible) bug with constraint exclusion

2008-01-21 Thread Christian Schröder
Hi list, It's a bug, it's patched: http://archives.postgresql.org/pgsql-committers/2008-01/msg00184.php I have just stumbled on the same bug today and was very happy to find a patch; however, I have a 8.2.6 server running which of course cannot be patched. (According to the CVS tags the revi

Re: [SQL] (possible) bug with constraint exclusion

2008-01-12 Thread Rajesh Kumar Mallah
On Jan 12, 2008 10:54 AM, Tom Lane <[EMAIL PROTECTED]> wrote: > "Rajesh Kumar Mallah" <[EMAIL PROTECTED]> writes: > > Am I correct in understanding that the current behavior is inappropriate > > and shall be corrected at some point of time in future versions ? > > It's a bug, it's patched: > http:/

Re: [SQL] (possible) bug with constraint exclusion

2008-01-11 Thread Tom Lane
"Rajesh Kumar Mallah" <[EMAIL PROTECTED]> writes: > Am I correct in understanding that the current behavior is inappropriate > and shall be corrected at some point of time in future versions ? It's a bug, it's patched: http://archives.postgresql.org/pgsql-committers/2008-01/msg00184.php

Re: [SQL] (possible) bug with constraint exclusion

2008-01-11 Thread Rajesh Kumar Mallah
On Jan 12, 2008 1:26 AM, Tom Lane <[EMAIL PROTECTED]> wrote: > "Rajesh Kumar Mallah" <[EMAIL PROTECTED]> writes: > > looks like constraint exclusion is being too aggressive in excluding null > > values > > Hmm, you're right. Looks like I broke it here: > http://archives.postgresql.org/pgsql-commi

Re: [SQL] (possible) bug with constraint exclusion

2008-01-11 Thread Tom Lane
"Rajesh Kumar Mallah" <[EMAIL PROTECTED]> writes: > looks like constraint exclusion is being too aggressive in excluding null > values Hmm, you're right. Looks like I broke it here: http://archives.postgresql.org/pgsql-committers/2007-05/msg00187.php > although its well known that check constra

Re: [SQL] (possible) bug with constraint exclusion

2008-01-10 Thread Rajesh Kumar Mallah
Update the phenomenon does not exists in 8.2.0 but exists in 8.2.5. On Jan 11, 2008 12:28 PM, Rajesh Kumar Mallah <[EMAIL PROTECTED]> wrote: > Hi , > > looks like constraint exclusion is being too aggressive in excluding null > values > although its well known that check constraints apply on no