Postgres Pro
Downloads
Home   >   mailing lists

Re: constraint checking on partitions - Mailing list pgsql-general

From Tom Lane
Subject Re: constraint checking on partitions
Date
Msg-id 4711.1247165498@sss.pgh.pa.us
Whole thread Raw
In response to constraint checking on partitions  ("Chris Spotts" <rfusca@gmail.com>)
Responses Re: constraint checking on partitions
List pgsql-general
Tree view 
"Chris Spotts" <rfusca@gmail.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

pgsql-general by date:

Previous
From: Vick Khera
Date:
Subject: Re: Asking for assistance in determining storage requirements
Next
From: "Chris Spotts"
Date:
Subject: Re: constraint checking on partitions