Re: Insert into partition table hangs

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