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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
