Thread: copy error?

copy error?

From
"lt"
Date:
Hi all,

         Database: 7.1.3 (RPM)

     OS: Redhat 7.1

         Table: Create table jquserdata (

                                     Username varchar(20) not null, primary
key,

                                     ��)

Copy some corrupted data from a 7.1.3 (Encoding ASCII) with pg_dump, then
copy them (psql �Ce gamedb <data) to a new database(Encoding EUC_CN), some
error reported (duplicate primary key), I erased these rows and re-execute,
finally all data copied, next ,vaccum �Cz gamedb, this error still reported:

Cannot insert a duplicate key into unique index jquserdata_pkey !

Why? Everything is Ok when I use 7.0.2, but after I upgraded my database to
7.1.2 (next 7.1.3), things goes wrong. If no one can answer this question,
the only thing I can do is go back to 7.0.2. But how to downgrade a database



Re: copy error?

From
Tom Lane
Date:
"lt" <lt@basecity.com> writes:
>      OS: Redhat 7.1

What glibc version are you using?  There's a serious bug in strcoll()
in glibc versions before 2.2.3 --- see
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=36539
In a multibyte-enabled Postgres this can lead to core dumps and
corrupted indexes; you seem to be suffering the latter.

            regards, tom lane