Re: constraint checking on partitions

> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: Thursday, July 09, 2009 1:52 PM
> To: Chris Spotts
> Cc: 'postgres list'
> Subject: Re: [GENERAL] constraint checking on partitions
> 
> "Chris Spotts"  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
[Spotts, Christopher] 

I mistyped, that should be 

alter table D add constraint onlyjuly check (date1 >= '2009-07-01' and date1
< '2009-08-01')
Then this is also run
alter table O add constraint notjuly check (NOT(date1 >= '2009-07-01' and
date1 < '2009-08-01'))

If I ran a select * from A where date1 >= '2009-07-02' and date1 <
'2009-07-15' then I would think it wouldn't check O.