Home > mailing lists

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

From	Piyush Lenka
Subject	Can not restore when there is a primary key violation
Date	March 1, 2012 13:10:39
Msg-id	CAFOD=KBoFSJVYrFb9FoV7c9r4No7sJDRcOnUAjq6Z0wMB9e=PQ@mail.gmail.com Whole thread Raw
Responses	Re: Can not restore when there is a primary key violation (Francisco Leovey <fleovey@yahoo.com>)
List	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

From: Philip Couling
Date: 29 February 2012, 13:38:49
Subject: Re: a role without login priviledge

From: Francisco Leovey
Date: 01 March 2012, 16:49:05
Subject: Re: Can not restore when there is a primary key violation