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,
Pennsylvania19073