when COPY violates Primary Keys

From: Joao Ferreira gmail <joao(dot)miguel(dot)c(dot)ferreira(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: when COPY violates Primary Keys
Date: 2008-10-09 18:42:41
Message-ID: 1223577761.6634.39.camel@jmf-ubuntu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Josh Williams 2008-10-09 19:22:28 Re: Question About UNION
Previous Message David Wilson 2008-10-09 17:54:44 Re: Question About UNION