From: Christian Schröder <cs@deriva.de>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org
Subject: Re: (possible) bug with constraint exclusion
Date: Mon, 21 Jan 2008 14:48:58 +0100
Message-ID: <4794A2CA.1000401@deriva.de> (raw)
In-Reply-To: <1442.1200115443@sss.pgh.pa.us>
References: <a97c77030801102258y3d501045u6b31afe0541997db@mail.gmail.com>
<23924.1200081368@sss.pgh.pa.us>
<a97c77030801112100w1c4c4fadwb5eaeab52ad4fe7e@mail.gmail.com>
<1442.1200115443@sss.pgh.pa.us>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: cs@deriva.de, tgl@sss.pgh.pa.us
Subject: Re: (possible) bug with constraint exclusion
In-Reply-To: <4794A2CA.1000401@deriva.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox