Postgres Pro
Downloads
Home   >   mailing lists

Re: Can not restore when there is a primary key violation - Mailing list pgsql-novice

From Francisco Leovey
Subject Re: Can not restore when there is a primary key violation
Date
Msg-id 1330624129.24711.YahooMailNeo@web39304.mail.mud.yahoo.com
Whole thread Raw
In response to Can not restore when there is a primary key violation  (Piyush Lenka <lenka.piyush@gmail.com>)
List pgsql-novice
Tree view
Delete all records
Restore from backup
Update record with key=5
(BTW you are talking about rows, not columns, right?)

From: Piyush Lenka <lenka.piyush@gmail.com>
To: pgsql-novice@postgresql.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


pgsql-novice by date:

Previous
From: Piyush Lenka
Date:
Subject: Can not restore when there is a primary key violation
Next
From: Mikko Kurki-Suonio
Date:
Subject: Newbie question