Re: [JDBC] Problem: upgrade from 7.1.3 to 7.2.1 ( database encode with ENC_TW)

Gordon-

This looks like a subject for the PSQL-ADMIN list. I'll forward it over
there, & you should also look there for the response. I know that one of the
7.1->7.2 issues is that unicode chars were not checked/rejected by 7.1 if
there was no multibyte support in the compile, but you seem to have
addressed that issue.

The error messages seem pretty clear on this- have you checked the dump file
to see if you do in fact have chars that are no valid EUC_TW ?

Regards,

-Nick
>
> Hi all,
>
> Problem as my letter subject, my upgrade procedure also just follow the
> simple.
>
> 1. compile 7.2.1 with multi-byte...with encode..
> 2. install ...
> 3. createdb -E EUC_TW mydatabase
> 4. psql mydatabase < dump_backup_from_my_old_database.txt
>
> it return following error...
>
> ------------------------>8---------------------------
> .
> .
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> 'student_pk' for table 'student'
> CREATE
> ERROR: copy: line 2, Invalid EUC_TW character sequence found (0xae65)
> lost synchronization with server, resetting connection
> ERROR: copy: line 1, Invalid EUC_TW character sequence found (0xb27a)
> lost synchronization with server, resetting connection
> ERROR: copy: line 1, Invalid EUC_TW character sequence found (0xaa4d)
> lost synchronization with server, resetting connection
> ERROR: copy: line 1, Invalid EUC_TW character sequence found (0xb371)
> lost synchronization with server, resetting connection
> ERROR: copy: line 2, Invalid EUC_TW character sequence found (0xbc42)
> lost synchronization with server, resetting connection
> ERROR: copy: line 1, Invalid EUC_TW character sequence found (0xa470)
> lost synchronization with server, resetting connection
> ERROR: copy: line 1, Invalid EUC_TW character sequence found (0xa656)
> lost synchronization with server, resetting connection
> ERROR: copy: line 3, Invalid EUC_TW character sequence found (0xad50)
> lost synchronization with server, resetting connection
> CREATE
> CREATE
> .
> .
> ------------------------>8---------------------------
>
> Please help.
>
> Gordon
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>