From: Jyoti Seth <jyotiseth2001@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Pg_Restore with --clean option
Date: Wed, 30 Sep 2009 22:14:41 -0700 (PDT)
Message-ID: <25693180.post@talk.nabble.com> (raw)
I want to restore data of a single table. Before restoring the data I
disabled all the triggers and constraints on that table. I used the restore
command with --clean option so that data gets deleted from that table and
then fresh data get inserted.
But this is throwing error: duplicate key value violates unique constraint.
How can I restore the data to a table that already has data?
Thanks,
--
View this message in context: http://www.nabble.com/Pg_Restore-with---clean-option-tp25693180p25693180.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jyotiseth2001@gmail.com
Subject: Re: Pg_Restore with --clean option
In-Reply-To: <25693180.post@talk.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox