Re: COPY and partitioning

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Colton A Smith <smith(at)cs(dot)utk(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: COPY and partitioning
Date: 2005-11-20 17:33:58
Message-ID: 1132508038.4959.367.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Simon Riggs 2005-11-20 17:37:11 Re: Steeleyes LifeKeeper
Previous Message olive Mckenzie 2005-11-20 10:16:45 installation of postgresql8.0.1 on Solaris 10