Re: Can not restore when there is a primary key violation

Delete all records

Restore from backup
Update record with key=5
(BTW you are talking about rows, not columns, right?)

________________________________
From: Piyush Lenka <lenka(dot)piyush(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Sent: Thursday, March 1, 2012 11:02 AM
Subject: [NOVICE] Can not restore when there is a primary key violation

Hi,

 My table "Tbl1" contains primary keys (1,2,3,4,5,6,7,8,9 and 10),
I took a backup of "Tbl1" to backup file "Backup1.sql",
then deleted all records,
and added a column with primary key 5.
and tried to restore Backup file "Backup1.sql"
But it did not restore any columns....Is there any Option to restore all other columns except 5.
Please Help.

Thanks & Regards
Piyush Lenka