Postgres Pro
Downloads
Home   >   mailing lists

Pg_Restore with --clean option - Mailing list pgsql-sql

From Jyoti Seth
Subject Pg_Restore with --clean option
Date
Msg-id 25693180.post@talk.nabble.com
Whole thread Raw
Responses Re: Pg_Restore with --clean option  (Peter Eisentraut <peter_e@gmx.net>)
Re: Pg_Restore with --clean option  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-sql
Tree view 
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.

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Disable Constraints in Postgresql 8.4
Next
From: Peter Eisentraut
Date:
Subject: Re: Pg_Restore with --clean option