Re: COPY and partitioning - Mailing list pgsql-admin

From Simon Riggs
Subject Re: COPY and partitioning
Date
Msg-id 1132508038.4959.367.camel@localhost.localdomain
Whole thread Raw
In response to COPY and partitioning  (Colton A Smith <smith@cs.utk.edu>)
List pgsql-admin
On Thu, 2005-11-17 at 09:55 -0500, Colton A Smith wrote:

>    My question: does the COPY utility consult check constraints
> before populating tables?

No.

I'd dump it piece by piece using a WHERE clause exactly the same as the
constraints you will use, then reload using COPY into the partitions.

Best Regards, Simon Riggs


pgsql-admin by date:

Previous
From: olive Mckenzie
Date:
Subject: installation of postgresql8.0.1 on Solaris 10
Next
From: Simon Riggs
Date:
Subject: Re: Steeleyes LifeKeeper