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 B9F46D1B1B3 for ; Fri, 9 Jul 2004 04:58:31 -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 42093-03 for ; Fri, 9 Jul 2004 07:58:30 +0000 (GMT) Received: from ucsns.ucs.co.za (ucs.co.za [196.23.43.2]) by svr1.postgresql.org (Postfix) with ESMTP id 4430CD1B1D1 for ; Fri, 9 Jul 2004 04:58:20 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by ucsns.ucs.co.za (Postfix) with ESMTP id 377802BD7A for ; Fri, 9 Jul 2004 09:58:11 +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 21478-10 for ; Fri, 9 Jul 2004 09:57:45 +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 4CC722BD7B for ; Fri, 9 Jul 2004 09:57:43 +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 59786DA729 for ; Fri, 9 Jul 2004 09:57:44 +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 4B338975A0 for ; Fri, 9 Jul 2004 09:57:43 +0200 (SAST) Date: Fri, 9 Jul 2004 09:57:38 +0200 From: Stef To: pgsql-admin@postgresql.org Subject: Bad dumps... Message-Id: <20040709095738.5738334f@svb.ucs.co.za> 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=_Fri__9_Jul_2004_09_57_38_+0200_5FhwZFO2WtY9OhFH" 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/113 X-Sequence-Number: 14181 --Signature=_Fri__9_Jul_2004_09_57_38_+0200_5FhwZFO2WtY9OhFH Content-Type: text/plain; charset=US-ASCII Content-Disposition: inline Content-Transfer-Encoding: 7bit Hi all, I'm stuck with a problem,about which I couldn't find much info. I'm sure somebody must have encountered this before. I've got a "NOT NULL" column of type text. It happens that freehand data gets inserted into this table, and it typically contains over 1000 rows with the value '\N' , and about another 3400 rows that has an occurrence of '\N' The database dumps fine, but when I import it again, I get "cannot insert null value into not null column"-type errors, and if I don't pay close attention, I end up with an empty table on the database. There is no way for me to tell how many columns could be affected in future, but I need to stabilize the backups. I'm using postgres version 7.3.4 Any idea how to get around this problem? Kind Regards Stefan --Signature=_Fri__9_Jul_2004_09_57_38_+0200_5FhwZFO2WtY9OhFH Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (GNU/Linux) iQCVAwUBQO5P9roLc+HYd7LFAQJXtgQAg/KNAX0eDJc/7cFB30OID+gXotsw0nsm 6YYZXp8wFvuJUCMaQ311+c0pF92QohhfI5+cR8+mYTnQqMmJ3tPx7eBxBJ9FJ0Ml 0zOUWktMrsZB1um4jROWKXg2T23rq7X193JwgH6zYCQH5LYqdwfa9Z4zhQEk2BhW BTxsbQZ7MVs= =xiQ6 -----END PGP SIGNATURE----- --Signature=_Fri__9_Jul_2004_09_57_38_+0200_5FhwZFO2WtY9OhFH--