Re: ignore duplicate key while using COPY?

Copy to a staging table without the constraint and then write a query to consolidate/remove the duplicate data and insert the clean data into the final table.

It doesn't just give a warning because not importing a record from the source data should be a fatal error since it means you have a design mis-match surrounding your import procedure.

David J.

On Dec 19, 2011, at 1:54, Yan Chunlu  wrote:

> I am using COPY public.table_name FROM STDIN  to import data.  it is
> very efficient, but if there's any duplicate key exists, the whole
> procedure has been stopped.  is there anyway to around this?
> 
> why does not postgresql just give a warning and continue the copy?
> 
> -- 
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general