To answer my own mail, I shut down the 8.1 database, and started up the
8.0 PostgreSQL install that is still on my computer, and the backups
work fine. I do get the message about how 8.1 handles sorting of unicode
characters more correctly, but looking at my backups, I can see that the
full 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 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? Looking around online, I see
that this supposedly codes for a lowercase a with a circumflex (which
I don't have in tha table thet triggeres the error), but that this may
be the first part of a three-byte sequence that codes for something else.
Does anyone know of a way to pinpoint the character in the database? I
am not sure how to search for a raw unicode character through psql or
pgadmin...
Thanks for any help!
JP
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
--
____________________________________________________
Oficina de Qualitat Tel: 973 703 103
Universitat de Lleida Fax: 973 702 036
Pl. Víctor Siurana, 1
25003 Lleida
____________________________________________________
