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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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