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

From Lee Kindness
Subject Re: Bulkloading using COPY - ignore duplicates?
Date
Msg-id 15389.59806.534505.201283@elsick.csl.co.uk
Whole thread Raw
In response to Re: Bulkloading using COPY - ignore duplicates?  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Bulkloading using COPY - ignore duplicates?  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Peter Eisentraut writes:> 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
whichone is the duplicate and which one is the good one?> More likely you will have to fix the entire thing.  Anything
elsewould> undermine the general data model except in specific use cases.
 

Consider SELECT DISTINCT - which is the 'duplicate' and which one is
the good one?

Lee.


pgsql-hackers by date:

Previous
From: Lee Kindness
Date:
Subject: Re: Bulkloading using COPY - ignore duplicates?
Next
From: bpalmer
Date:
Subject: Re: 7.2 is slow?