Re: Bulkloading using COPY - ignore duplicates?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Bulkloading using COPY - ignore duplicates?
Дата
Msg-id 23205.1001945353@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Bulkloading using COPY - ignore duplicates?  (Lee Kindness <lkindness@csl.co.uk>)
Ответы Re: Bulkloading using COPY - ignore duplicates?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
"Zeugswetter Andreas SB SD" <ZeugswetterA@spardat.at> writes:
> I thought that the problem was, that you cannot simply skip the 
> insert, because at that time the tuple (pointer) might have already 
> been successfully inserted into an other index/heap, and thus this was 
> only sanely possible with savepoints/undo.

Hmm, good point.  If we don't error out the transaction then that tuple
would become good when we commit.  This is nastier than it appears.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Bulkloading using COPY - ignore duplicates?
Следующее
От: "Marc G. Fournier"
Дата:
Сообщение: Re: Moving CVS files around?