X-Original-To: pgsql-admin-postgresql.org@postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id EE5FD9FA5E6
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Thu, 15 Jun 2006 23:38:13 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 84788-08 for <pgsql-admin-postgresql.org@postgresql.org>;
	Thu, 15 Jun 2006 23:37:58 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from web31114.mail.mud.yahoo.com (web31114.mail.mud.yahoo.com
	[68.142.201.76]) by postgresql.org (Postfix) with SMTP id EDB589FA160
	for <pgsql-admin@postgresql.org>; Thu, 15 Jun 2006 23:37:58 -0300 (ADT)
Received: (qmail 97226 invoked by uid 60001); 16 Jun 2006 02:37:57 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=wqphMxO4icigC1dpsv1q5KgDE9Tnx7LoywZiWFGceWg2XHkBsE12/DQOIYHdsVIz1o/0ewPNlDxqiGLHm4Az+MWNMaXO/Wf4iNEy827jTo1MoaXmJv7l1QcPdJs3qhcRtfUm6W/FfximDk2ICffwZ6OHZtRHXoC6eOgTRVhx7zk=
	;
Message-ID: <20060616023757.97224.qmail@web31114.mail.mud.yahoo.com>
Received: from [218.111.205.197] by web31114.mail.mud.yahoo.com via HTTP;
	Thu, 15 Jun 2006 19:37:57 PDT
Date: Thu, 15 Jun 2006 19:37:57 -0700 (PDT)
From: Infor Gates <info_gates@yahoo.com>
Subject: pg_restore
To: pgsql-admin@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-679386934-1150425477=:96806"
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200606/138
X-Sequence-Number: 22100

--0-679386934-1150425477=:96806
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Dear list

I hope you could help me understand the error message below:
While it looks straight forward, I could NOT find the duplicate key violation,
even though check through the said table (transaction by transaction). So,
I am wondering if the message would means something else.

I had tried re-indexing (force) and even modifying the primary key (manually) but
have not found any new clues.

I am using Postgresql 8.0.7 (Win32 binary version) and pgAdmin III for backup and restore.

Thank you.

CY

Error message:
--------------------
pg_restore: restoring data for table "bf_receipt"
pg_restore: ERROR:  duplicate key violates unique constraint "bf_receipt_pkey"
CONTEXT:  COPY bf_receipt, line 1: "2006/03/14 15:32:46.239           7    SUBANGJAYA              2005-10-15    evonne                                ..."
pg_restore: [archiver (db)] error returned by PQendcopy: ERROR:  duplicate key violates unique constraint "bf_receipt_pkey"
CONTEXT:  COPY bf_receipt, line 1: "2006/03/14 15:32:46.239           7    SUBANGJAYA              2005-10-15    evonne                                ..."
pg_restore: *** aborted because of error

 __________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
--0-679386934-1150425477=:96806
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Dear list<br><br>I hope you could help me understand the error message below:<br>While it looks straight forward, I could NOT find the duplicate key violation,<br>even though check through the said table (transaction by transaction). So,<br>I am wondering if the message would means something else.<br><br>I had tried re-indexing (force) and even modifying the primary key (manually) but<br>have not found any new clues.<br><br>I am using Postgresql 8.0.7 (Win32 binary version) and pgAdmin III for backup and restore.<br><br>Thank you.<br><br>CY<br><br>Error message:<br>--------------------<br>pg_restore: restoring data for table "bf_receipt"<br>pg_restore: ERROR:&nbsp; duplicate key violates unique constraint "bf_receipt_pkey"<br>CONTEXT:&nbsp; COPY bf_receipt, line 1: "2006/03/14 15:32:46.239&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp;&nbsp; SUBANGJAYA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; 2005-10-15&nbsp;&nbsp;&nbsp;
 evonne&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ..."<br>pg_restore: [archiver (db)] error returned by PQendcopy: ERROR:&nbsp; duplicate key violates unique constraint "bf_receipt_pkey"<br>CONTEXT:&nbsp; COPY bf_receipt, line 1: "2006/03/14 15:32:46.239&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp;&nbsp; SUBANGJAYA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; 2005-10-15&nbsp;&nbsp;&nbsp; evonne&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ..."<br>pg_restore: *** aborted because of error<br><p>&#32;__________________________________________________<br>Do You Yahoo!?<br>Tired of spam?  Yahoo! Mail has the best spam protection around <br>http://mail.yahoo.com 
--0-679386934-1150425477=:96806--