pgsql: Add a caveat pointing out that constraint exclusion doesn't work

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Add a caveat pointing out that constraint exclusion doesn't work
Date: 2007-06-20 23:11:39
Message-ID: 20070620231139.45E869FBE95@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Add a caveat pointing out that constraint exclusion doesn't work with
constraints the planner is unable to disprove, hence simple btree-compatible
conditions should be used. We've seen people try to get cute with stuff
like date_part(something) = something at least twice now. Even if we
wanted to try to teach predtest.c about the properties of date_part,
most of the useful variants aren't immutable so nothing could be proved.

Modified Files:
--------------
pgsql/doc/src/sgml:
ddl.sgml (r1.75 -> r1.76)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ddl.sgml.diff?r1=1.75&r2=1.76)

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Eisentraut 2007-06-21 10:43:09 pgsql: Update examples of create/drop scripts.
Previous Message Neil Conway 2007-06-20 19:24:05 pgsql: Remove some empty columns from a few system catalog tables in the