X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 10259D6E8F for ; Sun, 20 Nov 2005 13:34:02 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 11462-09 for ; Sun, 20 Nov 2005 17:34:00 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp.nildram.co.uk (smtp.nildram.co.uk [195.112.4.54]) by svr1.postgresql.org (Postfix) with ESMTP id 73367D7A41 for ; Sun, 20 Nov 2005 13:33:59 -0400 (AST) Received: from [192.168.0.4] (unknown [84.12.200.148]) by smtp.nildram.co.uk (Postfix) with ESMTP id B724B257555; Sun, 20 Nov 2005 17:33:55 +0000 (GMT) Subject: Re: COPY and partitioning From: Simon Riggs To: Colton A Smith Cc: pgsql-admin@postgresql.org In-Reply-To: References: Content-Type: text/plain Date: Sun, 20 Nov 2005 17:33:58 +0000 Message-Id: <1132508038.4959.367.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.2.2 (2.2.2-5) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[AWL=0.000] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/263 X-Sequence-Number: 19636 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