On Fri, Jul 13, 2001 at 09:40:24AM -0400,
Ryan Mahoney <ryan(at)paymentalliance(dot)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.