Re: constraint checking on partitions
От | Chris Spotts |
---|---|
Тема | Re: constraint checking on partitions |
Дата | |
Msg-id | 00ba01ca00c7$649a0db0$2dce2910$@com обсуждение исходный текст |
Ответ на | Re: constraint checking on partitions (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: constraint checking on partitions
|
Список | pgsql-general |
> -----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" <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 [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.
В списке pgsql-general по дате отправления: