when COPY violates Primary Keys - Mailing list pgsql-general

From Joao Ferreira gmail
Subject when COPY violates Primary Keys
Date
Msg-id 1223577761.6634.39.camel@jmf-ubuntu
Whole thread Raw
Responses Re: when COPY violates Primary Keys  (Chris <dmagick@gmail.com>)
List pgsql-general
Hello all,

I have a ascii dump file based on the COPY operation.

lets say I restore this dump into a live database with applications
doing INSERTs and UPDATEs onto it.

in case the COPY of a register causes a primary key (or UNIQUE, or FK)
violation does the psql restore command try to continue the operation
until it has parsed the whole dump, or does it abort on the first
violation ?

thx
Joao



pgsql-general by date:

Previous
From: "David Wilson"
Date:
Subject: Re: Question About UNION
Next
From: Josh Williams
Date:
Subject: Re: Question About UNION