X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id A3BB8D1CCDA for ; Wed, 24 Mar 2004 23:42:00 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 58406-05 for ; Wed, 24 Mar 2004 19:42:01 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 13566D1C4EC for ; Wed, 24 Mar 2004 19:41:58 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i2ONfi76003824; Wed, 24 Mar 2004 18:41:44 -0500 (EST) To: Bruce Momjian Cc: Tsirkin Evgeny , Naomi Walker , "Mark M. Huber" , "pgsql-admin@postgresql.org" Subject: Re: [Retrieved]RE: backup and recovery In-reply-to: <200403242307.i2ON7bD26576@candle.pha.pa.us> References: <200403242307.i2ON7bD26576@candle.pha.pa.us> Comments: In-reply-to Bruce Momjian message dated "Wed, 24 Mar 2004 18:07:37 -0500" Date: Wed, 24 Mar 2004 18:41:44 -0500 Message-ID: <3823.1080171704@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/323 X-Sequence-Number: 12892 Bruce Momjian writes: > My bigger issue is that COPY will fail on a single row failure, and > nothing will be in the table, while INSERT will not. In theory, there shouldn't be any failures, because the data was known valid when it was dumped. Of course, practice often differs from theory, but I wonder whether we aren't talking about palliating a symptom instead of fixing the real problem. regards, tom lane