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

From Mikheev, Vadim
Subject Re: Bulkloading using COPY - ignore duplicates?
Date
Msg-id 3705826352029646A3E91C53F7189E32518469@sectorbase2.sectorbase.com
Whole thread Raw
In response to Bulkloading using COPY - ignore duplicates?  (Lee Kindness <lkindness@csl.co.uk>)
Responses Re: Bulkloading using COPY - ignore duplicates?  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
> > Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > > Seems nested transactions are not required if we load
> > > each COPY line in its own transaction, like we do with
> > > INSERT from pg_dump.
> > 
> > I don't think that's an acceptable answer.  Consider
> 
> Oh, very good point.  "Requires nested transactions" added to TODO.

Also add performance issue with per-line-commit...

Also-II - there is more common name for required feature - savepoints.

Vadim


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: More problem with scripts
Next
From: Bruce Momjian
Date:
Subject: Re: Bulkloading using COPY - ignore duplicates?