Re: Bug? was: Re: [GENERAL] ERROR: could not convert UTF8 character

2006-03-28 Thread JP Glutting
works now (not sure whay it was not working a month or so ago). Cheers, JP Tom Lane wrote: JP Glutting <[EMAIL PROTECTED]> writes: This is reproducible, and I think it is a bug, because I have the problem not only with data backed up from Postgres 8.0 and restored to Postgres 8.1, bu

[GENERAL] Error backing up database (Unicode)

2006-03-27 Thread JP Glutting
I get this error when trying to back up a database in Postgres 8.1 that I was able to back up from Postgres 8.0 and restore into Postgres 8.1: C:\Archivos de programa\PostgreSQL\8.1\bin\pg_dump.exe -i -h localhost -p 5432 -U z2233935 -F c -b -v -f "C:\Documents and Settings\z2233935\db_test_io

Bug? was: Re: [GENERAL] ERROR: could not convert UTF8 character to ISO8859-1

2006-03-27 Thread JP Glutting
? Is this a known bug? JP JP Glutting wrote: More information. I backed up a database (one that failed to backup in 8.1) from the old 8.0 system, and re-imported it into the 8.0 system without any problem. Then I imported it into the 8.1 system without errors, and tried to do a backup again. It

Re: [GENERAL] ERROR: could not convert UTF8 character to ISO8859-1

2006-03-23 Thread JP Glutting
think I am going to try to go back to 8.0. Is it a very bad idea to shut down Postgres and try to replace the data directory for 8.0 withe the data directory for 8.1? Any help or suggestions appreciated. JP JP Glutting wrote: To answer my own mail, I shut down the 8.1 database, and started u

Re: [GENERAL] ERROR: could not convert UTF8 character to ISO8859-1

2006-03-23 Thread JP Glutting
back up failed about the time that I switched to the newer version. Is there a fix for this? Is this a bug? Is there a workaround? Thanks for any help. JP JP Glutting wrote: I have seen several people with this same error. I get mine when trying to backup using pg_dump, causing my backups to

[GENERAL] ERROR: could not convert UTF8 character to ISO8859-1

2006-03-23 Thread JP Glutting
I have seen several people with this same error. I get mine when trying to backup using pg_dump, causing my backups to fail. I am using PostgreSQL 8.1 on Windows XP.The databases are in UTF8. I get the same error from the command line and using pgadmin3. Has anyone found a solution for this?