Re: (possible) bug with constraint exclusion - Mailing list pgsql-sql

From Christian Schröder
Subject Re: (possible) bug with constraint exclusion
Date
Msg-id 4794A2CA.1000401@deriva.de
Whole thread Raw
In response to Re: (possible) bug with constraint exclusion  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: (possible) bug with constraint exclusion  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
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 revisions of plancat.c and 
predtest.c in the 8.2.6 release are 1.127 and 1.10.2.2, respectively, 
whereas the patch is against the head revisions.)
Would it be possible to provide a patch against the 8.2.6 stable release 
(the one that can be downloaded from the download section of the 
homepage)? It seems as if partitioning is unusable without this patch 
because when constraint exclusion is enabled, records cannot be found by 
select or update even in tables where partitioning is not realized at 
all. On the other hand, without constraint exclusion, partitioning at 
all doesn't make sense (as far as I understand).
Thanks a lot for your help!

Regards,   Christian

-- 
Deriva GmbH                         Tel.: +49 551 489500-42
Financial IT and Consulting         Fax:  +49 551 489500-91
Hans-Böckler-Straße 2                  http://www.deriva.de
D-37079 Göttingen

Deriva CA Certificate: http://www.deriva.de/deriva-ca.cer




pgsql-sql by date:

Previous
From: Gerardo Herzig
Date:
Subject: Re: transaction and triggers
Next
From: Tom Lane
Date:
Subject: Re: (possible) bug with constraint exclusion