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>
Sent: Thursday, March 1, 2012 11:02 AM
Subject: [NOVICE] Can not restore when there is a primary key violation
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.
Thanks & Regards
In response to
pgsql-novice by date
|Next:||From: Mikko Kurki-Suonio||Date: 2012-03-01 20:49:14|
|Subject: Newbie question|
|Previous:||From: Piyush Lenka||Date: 2012-03-01 14:02:40|
|Subject: Can not restore when there is a primary key violation|