|
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 –e 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 –z 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? |
