From: Bruce Momjian <pgman@candle.pha.pa.us>
Message-Id: <200512091738.jB9HcLI18465@candle.pha.pa.us>
Subject: Re: Upcoming PG re-releases
In-Reply-To: <20051209164409.GG20352@svana.org>
To: Martijn van Oosterhout <kleptog@svana.org>
Date: Fri, 9 Dec 2005 12:38:21 -0500 (EST)
CC: Gregory Maxwell <gmaxwell@gmail.com>,
 Gavin Sherry <swm@linuxworld.com.au>,
	Peter Eisentraut <peter_e@gmx.net>, pgsql-hackers@postgresql.org
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=US-ASCII

Martijn van Oosterhout wrote:
-- Start of PGP signed section.
> 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.

Oh, so you back-load it into the old database.  Interesting.  I assume
to be useful you would have to write something that checked every column
values in every table and database.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073