Andres Freund wrote: > On Tuesday 14 July 2009 11:36:57 Jasen Betts wrote: > > if you do an ascii dump and the dump starts out "SET CLIENT ENCODING > > 'UTF8'" or similar but you still get errors. > Do you mean that a dump from SQL_ASCII can yield non-utf8 data? right. But > According to the OP his 8.3 database is UTF8... > So there should not be invalid data in there. I haven't followed this thread, but older PG versions had less strict checks on UTF8 data, which meant that some invalid data could creep in. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
