Thread

1. Re: Bulkloading using COPY - ignore duplicates?

   Vadim Mikheev <vmikheev@sectorbase.com> — 2002-01-03T21:11:34Z

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

2. Re: Bulkloading using COPY - ignore duplicates?

   Bruce Momjian <pgman@candle.pha.pa.us> — 2002-01-03T21:15:04Z

   Mikheev, Vadim wrote:
   > > > 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.
   
   OK, updated TODO to prefer savepoints term.
   
   -- 
     Bruce Momjian                        |  http://candle.pha.pa.us
     pgman@candle.pha.pa.us               |  (610) 853-3000
     +  If your life is a hard drive,     |  830 Blythe Avenue
     +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026