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

From Patrick Welche
Subject Re: Bulkloading using COPY - ignore duplicates?
Date
Msg-id 20011213123114.B12426@quartz.newn.cam.ac.uk
Whole thread Raw
In response to Re: Bulkloading using COPY - ignore duplicates?  (Lee Kindness <lkindness@csl.co.uk>)
Responses Re: Bulkloading using COPY - ignore duplicates?  (Lee Kindness <lkindness@csl.co.uk>)
List pgsql-hackers
On Mon, Oct 01, 2001 at 03:17:43PM +0100, Lee Kindness wrote:
> Tom Lane writes:
>  > I'm especially not pleased at the notion of removing an error check
>  > that's always been there because someone else thinks that would make it
>  > more convenient for his application.
> 
> Please, don't get me wrong - I don't want to come across arrogant. I'm
> simply trying to improve the 'COPY FROM' command in a situation where
> speed is a critical issue and the data is dirty... And that must be a
> relatively common scenario in industry.

Isn't that when you do your bulk copy into into a holding table, then
clean it up, and then insert into your live system?

Patrick


pgsql-hackers by date:

Previous
From: Vince Vielhaber
Date:
Subject: Re: Regression test database is not working
Next
From: "Permaine Cheung"
Date:
Subject: Re: Third call for platform testing