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 D4CD3D1B1CE for ; Tue, 13 Jul 2004 12:08:46 -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 87155-01 for ; Tue, 13 Jul 2004 15:08:45 +0000 (GMT) Received: from ucsns.ucs.co.za (ucs.co.za [196.23.43.2]) by svr1.postgresql.org (Postfix) with ESMTP id A0AA1D1B373 for ; Tue, 13 Jul 2004 12:08:41 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by ucsns.ucs.co.za (Postfix) with ESMTP id 8982F2BD9E; Tue, 13 Jul 2004 17:08:34 +0200 (SAST) Received: from ucsns.ucs.co.za ([127.0.0.1]) by localhost (ucsns.ucs.co.za [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 27323-09; Tue, 13 Jul 2004 17:08:05 +0200 (SAST) Received: from ucspost.ucs.co.za (mailgw1.ucs.co.za [196.23.43.253]) by ucsns.ucs.co.za (Postfix) with ESMTP id A153E2BD69; Tue, 13 Jul 2004 17:08:05 +0200 (SAST) Received: from jhb.ucs.co.za (jhb.ucs.co.za [172.31.1.3]) by ucspost.ucs.co.za (Postfix) with ESMTP id DD59EDADCD; Tue, 13 Jul 2004 17:08:05 +0200 (SAST) Received: from svb.ucs.co.za (svb.ucs.co.za [172.31.1.148]) by jhb.ucs.co.za (Postfix) with SMTP id AB9AA975A0; Tue, 13 Jul 2004 17:08:05 +0200 (SAST) Date: Tue, 13 Jul 2004 17:07:57 +0200 From: Stef To: Tom Lane Cc: pgsql-admin@postgresql.org Subject: Re: Bad dumps... Message-Id: <20040713170757.41dfc99b@svb.ucs.co.za> In-Reply-To: <15686.1089728676@sss.pgh.pa.us> 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> <15686.1089728676@sss.pgh.pa.us> X-Mailer: Sylpheed-Claws 0.9.12 (GTK+ 1.2.10; i386-pc-linux-gnu) User-Agent: sillypheed-claws (anti-aliased) X-Face: GFoC95e6r)_TTG>n~=uFLojP=O~4W@Ms]>:.DMm/')(z3\Mwj^XP@? Q:3";lD.OM1"^mDu}2NJ@US:)dO:U*iY5EM50&Tx. X-Operating-System: sid X-X-X: _-^-_ Mime-Version: 1.0 Content-Type: multipart/signed; protocol="application/pgp-signature"; micalg="pgp-sha1"; boundary="Signature=_Tue__13_Jul_2004_17_07_57_+0200_cKrWsEOvmu9pLkuD" X-Virus-Scanned: by amavisd-new at ucs.co.za 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/149 X-Sequence-Number: 14217 --Signature=_Tue__13_Jul_2004_17_07_57_+0200_cKrWsEOvmu9pLkuD Content-Type: text/plain; charset=US-ASCII Content-Disposition: inline Content-Transfer-Encoding: 7bit Tom Lane mentioned : => 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. Here's what I did to recreate the problem : =# create table text_test ( id text NOT NULL); CREATE TABLE =# INSERT INTO text_test values ('\\N'); INSERT 37302671 1 =# \q [root@p0 postgres]# pg_dump p0 -U postgres -t text_test > text_test.sql [root@p0 postgres]# psql p0 -U postgres Welcome to psql 7.3.4, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit =# drop table text_test ; DROP TABLE =# \q [root@p0 postgres]# cat text_test.sql | psql p0 -U postgres You are now connected as new user postgres. SET CREATE TABLE ERROR: copy: line 1, CopyFrom: Fail to add null value in not null attribute id lost synchronization with server, resetting connection [root@p0 postgres]# --Signature=_Tue__13_Jul_2004_17_07_57_+0200_cKrWsEOvmu9pLkuD Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (GNU/Linux) iQCVAwUBQPP60boLc+HYd7LFAQJt9QQAkaEnvuu1st38yRsUSUhXYqL7+iBRyuxK McE/SwGNztaYV5Hota/dCrjnVvCsYT5FVgtqtwU4L11+nAxtjeOEIfFX/rQaurBO +wBzRUxQjIkDejrC4ZcQQLzP52Q8Vd6N0PmA3Rf8Qg3XmBCpcSluuoQDXTFPkWTl Xa2XDuvSwVk= =fdiV -----END PGP SIGNATURE----- --Signature=_Tue__13_Jul_2004_17_07_57_+0200_cKrWsEOvmu9pLkuD--