| From: | Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com> |
|---|---|
| To: | Willem Buitendyk <willem(at)pcfish(dot)ca> |
| Cc: | pgsql-general(at)postgresql(dot)org, Reg Me Please <regmeplease(at)gmail(dot)com> |
| Subject: | Re: Bulk Load Ignore/Skip Feature |
| Date: | 2007-11-14 08:20:46 |
| Message-ID: | 1195028446.20896.15.camel@neuromancer.home.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 2007-11-14 at 00:02 -0800, Willem Buitendyk wrote:
> Perfect - that appears to be exactly what I was looking for.
> Reg Me Please wrote:
> > Il Wednesday 14 November 2007 05:50:36 Willem Buitendyk ha scritto:
> >
> >> Will Postgresql ever implement an ignore on error feature when bulk
> >> loading data? Currently it is my understanding that any record that
> >> violates a unique constraint will cause the "copy from" command to halt
> >> execution instead of skipping over the violation and logging it - as is
> >> done in Oracle and DB2.
> >
> > pgloader
> >
> > http://pgfoundry.org/projects/pgloader/
> >
> >
I believe the last time I tried this, there was still some issues with
it. See attached email. (if it makes it to the list)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | hubert depesz lubaczewski | 2007-11-14 09:59:27 | Re: Using generate_series to create a unique ID in a query? |
| Previous Message | Willem Buitendyk | 2007-11-14 08:02:29 | Re: Bulk Load Ignore/Skip Feature |