On Sun, Jul 19, 2009 at 10:16:17AM +0800, Phoenix Kiula wrote: > If so, how can I check for them in my old database, which is 8.2.9? > I'm now moving first to 8.3 (then to the 84). > > Really, PG absolutely needs a way to upgrade the database without so > much data related downtime and all these silly woes. Several competing > database systems are a cinch to upgrade.
Look through the archives, there are scripts that will scan all your text fields for UTF-8 problems. If you run them once you can clear out all the problems prior to upgrading. Have a nice day, -- Martijn van Oosterhout <klep...@svana.org> http://svana.org/kleptog/ > Please line up in a tree and maintain the heap invariant while > boarding. Thank you for flying nlogn airlines.
signature.asc
Description: Digital signature
