pgsql: Add a caveat pointing out that constraint exclusion doesn't work - Mailing list pgsql-committers

From tgl@postgresql.org (Tom Lane)
Subject pgsql: Add a caveat pointing out that constraint exclusion doesn't work
Date
Msg-id 20070620231139.45E869FBE95@postgresql.org
Whole thread Raw
List 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)

pgsql-committers by date:

Previous
From: neilc@postgresql.org (Neil Conway)
Date:
Subject: pgsql: Remove some empty columns from a few system catalog tables in the
Next
From: petere@postgresql.org (Peter Eisentraut)
Date:
Subject: pgsql: Update examples of create/drop scripts.