Skip site navigation (1) Skip section navigation (2)

Copy error?

From: "lt" <lt(at)basecity(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Copy error?
Date: 2001-09-29 07:59:25
Message-ID: 9p3un1$12en$ (view raw, whole thread or download thread mbox)
Lists: pgsql-general
Hi all,

         Database: 7.1.3 (RPM)

     OS: Redhat 7.1

         Table: Create table jquserdata (

                                     Username varchar(20) not null, primary


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

pgsql-general by date

Next:From: Tod McQuillinDate: 2001-09-29 08:07:49
Subject: Re: Recreating unique index for primary key
Previous:From: Thomas LockhartDate: 2001-09-29 07:52:11
Subject: Re: converting to german date format

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group