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

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

From: Francisco Leovey <fleovey(at)yahoo(dot)com>
To: Piyush Lenka <lenka(dot)piyush(at)gmail(dot)com>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Can not restore when there is a primary key violation
Date: 2012-03-01 17:48:49
Message-ID: 1330624129.24711.YahooMailNeo@web39304.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
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

In response to

pgsql-novice by date

Next:From: Mikko Kurki-SuonioDate: 2012-03-01 20:49:14
Subject: Newbie question
Previous:From: Piyush LenkaDate: 2012-03-01 14:02:40
Subject: Can not restore when there is a primary key violation

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