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

Can not restore when there is a primary key violation

From: Piyush Lenka <lenka(dot)piyush(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Can not restore when there is a primary key violation
Date: 2012-03-01 14:02:40
Message-ID: CAFOD=KBoFSJVYrFb9FoV7c9r4No7sJDRcOnUAjq6Z0wMB9e=PQ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
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

Responses

pgsql-novice by date

Next:From: Francisco LeoveyDate: 2012-03-01 17:48:49
Subject: Re: Can not restore when there is a primary key violation
Previous:From: Philip CoulingDate: 2012-02-29 14:38:25
Subject: Re: a role without login priviledge

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