X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 4EB049DCC95 for ; Fri, 9 Dec 2005 12:44:28 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 22267-10-2 for ; Fri, 9 Dec 2005 12:44:27 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svana.org (svana.org [203.20.62.76]) by postgresql.org (Postfix) with ESMTP id 0F11D9DCC05 for ; Fri, 9 Dec 2005 12:44:25 -0400 (AST) Received: from kleptog by svana.org with local (Exim 3.35 #1 (Debian)) id 1EklLu-0006KJ-00; Sat, 10 Dec 2005 03:44:10 +1100 Date: Fri, 9 Dec 2005 17:44:10 +0100 From: Martijn van Oosterhout To: Bruce Momjian Cc: Gregory Maxwell , Gavin Sherry , Peter Eisentraut , pgsql-hackers@postgresql.org Subject: Re: Upcoming PG re-releases Message-ID: <20051209164409.GG20352@svana.org> Reply-To: Martijn van Oosterhout References: <20051209161733.GC20352@svana.org> <200512091634.jB9GYMb04814@candle.pha.pa.us> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="Uu2n37VG4rOBDVuR" Content-Disposition: inline In-Reply-To: <200512091634.jB9GYMb04814@candle.pha.pa.us> User-Agent: Mutt/1.3.28i X-PGP-Key-ID: Length=1024; ID=0x0DC67BE6 X-PGP-Key-Fingerprint: 295F A899 A81A 156D B522 48A7 6394 F08A 0DC6 7BE6 X-PGP-Key-URL: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.083 required=5 tests=[AWL=0.083] X-Spam-Score: 0.083 X-Spam-Level: X-Archive-Number: 200512/498 X-Sequence-Number: 77346 --Uu2n37VG4rOBDVuR Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Fri, Dec 09, 2005 at 11:34:22AM -0500, Bruce Momjian wrote: > I think the problem with any kind of function-call detection is that the > data has to get into the database first, and it isn't clear how someone > loading a failed dump would do that aside from modifying the column to > bytea in the dump, loading it in, then fixing it. The iconv idea has > the advantage that it can be fixed before loading into the database. The point of this function is to test the data *before* you even create the dump, while it is still running on 7.4 or 8.0. This means someone who is planning on upgrading to 8.1 in two months can use this function now to weed out the bad data before the upgrade even starts. Have a nice day, --=20 Martijn van Oosterhout http://svana.org/kleptog/ > Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a > tool for doing 5% of the work and then sitting around waiting for someone > else to do the other 95% so you can sue them. --Uu2n37VG4rOBDVuR Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQFDmbRZIB7bNG8LQkwRAklrAJ9N198Fi2uZQc2f1hxNftN7S7Jc2QCeIwrR 2KoYhyXdAcJ4d+1y1E3u9bc= =Wg5l -----END PGP SIGNATURE----- --Uu2n37VG4rOBDVuR--