Postgres Pro
Downloads
Home   >   mailing lists

Re: Insert into partition table hangs - Mailing list pgsql-general

From Jim C. Nasby
Subject Re: Insert into partition table hangs
Date
Msg-id 20060523215700.GA64371@pervasive.com
Whole thread Raw
In response to Re: Insert into partition table hangs  ("Nik" <XLPizza@gmail.com>)
Responses Re: Insert into partition table hangs
List pgsql-general
Tree view 
On Mon, May 22, 2006 at 01:38:20PM -0700, Nik wrote:
> CREATE TABLE schemaname.partition_table
> (
>   CHECK("start" >= '05-01-2006 00:00:00' AND "start" <= '05-31-2006
> 23:59:59'),

What about 5-31-2006 23:59:59.3?

What you really want is:
   CHECK("start" >= '05-01-2006' AND "start" < '06-01-2006')

PostgreSQL will assume midnight, so you don't actually need the time.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

pgsql-general by date:

Previous
From: "George Pavlov"
Date:
Subject: assymetry updating a boolean (=FALSE faster than =TRUE)
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Why won't it index scan?