X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 848E5D1B374 for ; Tue, 13 Jul 2004 11:24:38 -0300 (ADT) 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 59297-07 for ; Tue, 13 Jul 2004 14:24:39 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 59BA8D1B1CB for ; Tue, 13 Jul 2004 11:24:28 -0300 (ADT) 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 i6DEOaVu015687; Tue, 13 Jul 2004 10:24:37 -0400 (EDT) To: Stef Cc: pgsql-admin@postgresql.org Subject: Re: Bad dumps... In-reply-to: <20040713124000.49a556a0@svb.ucs.co.za> References: <5.1.0.14.0.20040709093611.05621ea0@mailserver.dmr.co.uk> <20040709095738.5738334f@svb.ucs.co.za> <5.1.0.14.0.20040709093611.05621ea0@mailserver.dmr.co.uk> <5.1.0.14.0.20040709122158.055ac630@mailserver.dmr.co.uk> <20040709161641.3e164d8f@svb.ucs.co.za> <1089429340.10763.10.camel@localhost.localdomain> <20040712095203.333c8aa2@svb.ucs.co.za> <20040713124000.49a556a0@svb.ucs.co.za> Comments: In-reply-to Stef message dated "Tue, 13 Jul 2004 12:40:00 +0200" Date: Tue, 13 Jul 2004 10:24:36 -0400 Message-ID: <15686.1089728676@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/148 X-Sequence-Number: 14216 Stef writes: > I found that it was actually a '\\N' value only that causes > dumps to dump successfully, but fail on import (When using COPY), > because both '\N' and '\\N' are seen as null by the COPY statement. This is demonstrably not so. You might have trouble with data coming from somewhere else, if the source doesn't understand the quoting rules for COPY data. But I can dump and restore a table containing '\N' and variants of that without any trouble. regards, tom lane