From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | Gregory Maxwell <gmaxwell(at)gmail(dot)com>, Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>, Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Upcoming PG re-releases |
Date: | 2005-12-09 16:44:10 |
Message-ID: | 20051209164409.GG20352@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-www |
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,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Kenneth Marshall | 2005-12-09 17:04:40 | Re: Warm-cache prefetching |
Previous Message | Andrew Dunstan | 2005-12-09 16:42:25 | Re: psql & UTF8 |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2005-12-09 17:38:21 | Re: Upcoming PG re-releases |
Previous Message | Bruce Momjian | 2005-12-09 16:34:22 | Re: Upcoming PG re-releases |