Re: Bulkloading using COPY - ignore duplicates? - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Bulkloading using COPY - ignore duplicates?
Date
Msg-id Pine.LNX.4.30.0112161731350.641-100000@peter.localdomain
Whole thread Raw
In response to Re: Bulkloading using COPY - ignore duplicates?  ("Jim Buttafuoco" <jim@buttafuoco.net>)
Responses Re: Bulkloading using COPY - ignore duplicates?  (Lee Kindness <lkindness@csl.co.uk>)
Re: Bulkloading using COPY - ignore duplicates?  (Lee Kindness <lkindness@csl.co.uk>)
List pgsql-hackers
Jim Buttafuoco writes:

> I agree with Lee,  I also like Oracle's options for a discard file, so
> you can look at what was rejected, fix your problem and reload if
> necessary just the rejects.

How do you know which one is the duplicate and which one is the good one?
More likely you will have to fix the entire thing.  Anything else would
undermine the general data model except in specific use cases.

-- 
Peter Eisentraut   peter_e@gmx.net



pgsql-hackers by date:

Previous
From: "Hiroshi Inoue"
Date:
Subject: unexpected SIGALRM
Next
From: Peter Eisentraut
Date:
Subject: Re: Explicit config patch 7.2B4