]> granicus.if.org Git - postgresql/commit
Add a caveat pointing out that constraint exclusion doesn't work with
authorTom Lane <tgl@sss.pgh.pa.us>
Wed, 20 Jun 2007 23:11:38 +0000 (23:11 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Wed, 20 Jun 2007 23:11:38 +0000 (23:11 +0000)
commit4c2d3ccf8afee7180978a3d7ef318ee7de0c0a91
tree766113118e8d79ba279183f78d3bbf44a57501cd
parent8f3d07764f3987f3317e29aaea76e97660972b5d
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.
doc/src/sgml/ddl.sgml