Re: constraint checking on partitions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Chris Spotts" <rfusca(at)gmail(dot)com>
Cc: "'postgres list'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: constraint checking on partitions
Date: 2009-07-09 18:51:38
Message-ID: 4711.1247165498@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Chris Spotts" <rfusca(at)gmail(dot)com> writes:
> Then this is also run

> alter table O add constraint notjuly check (NOT(date1 >= '2009-07-01' and
> date1 < '2009-07-01'))

> The planner excludes correctly except that it always checks O.

What are the actual queries you're hoping it will exclude for?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Spotts 2009-07-09 18:59:30 Re: constraint checking on partitions
Previous Message Vick Khera 2009-07-09 18:45:29 Re: Asking for assistance in determining storage requirements