Re: Bulkloading using COPY - ignore duplicates?

Vadim Mikheev <vmikheev@sectorbase.com>

From: "Mikheev, Vadim" <vmikheev@SECTORBASE.COM>

To: "'Bruce Momjian'" <pgman@candle.pha.pa.us>, Tom Lane <tgl@sss.pgh.pa.us>

Cc: Lee Kindness <lkindness@csl.co.uk>, Peter Eisentraut <peter_e@gmx.net>, Jim Buttafuoco <jim@buttafuoco.net>, PostgreSQL Development <pgsql-hackers@postgresql.org>

Date: 2002-01-03T21:11:34Z

Lists: 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