Re: Bulkloading using COPY - ignore duplicates?

Поиск
Список
Период
Сортировка
От Mikheev, Vadim
Тема Re: Bulkloading using COPY - ignore duplicates?
Дата
Msg-id 3705826352029646A3E91C53F7189E32518469@sectorbase2.sectorbase.com
обсуждение исходный текст
Ответ на Bulkloading using COPY - ignore duplicates?  (Lee Kindness <lkindness@csl.co.uk>)
Ответы Re: Bulkloading using COPY - ignore duplicates?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: More problem with scripts
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Bulkloading using COPY - ignore duplicates?