Re: COPY and duplicates - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: COPY and duplicates
Date
Msg-id 20010713110128.A13973@wolff.to
Whole thread Raw
In response to COPY and duplicates  (Ryan Mahoney <ryan@paymentalliance.net>)
Responses Re: COPY and duplicates  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-general
On Fri, Jul 13, 2001 at 09:40:24AM -0400,
  Ryan Mahoney <ryan@paymentalliance.net> wrote:
> Is it possible for the COPY command to warn about duplicate key violations
> (and not insert them...) but still proceed inserting the rows that do not
> cause a violation?  If not, what is the quickest way to deal with this problem?

You could copy the data into a temporary table and then insert just
run record from a set with the same key into the real table.

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [PATCH] To remove EXTEND INDEX
Next
From: Thomas Lockhart
Date:
Subject: Re: Re: Backups WAS: 2 gig file size limit