Re: Conflict handling for COPY FROM

Поиск
Список
Период
Сортировка
От Surafel Temesgen
Тема Re: Conflict handling for COPY FROM
Дата
Msg-id CALAY4q-hWwbg-P1=oJcVT1jTHj_g+JxJ_0JNe4MdYKz8RvUF=g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Conflict handling for COPY FROM  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Conflict handling for COPY FROM  (Dmitry Dolgov <9erthalion6@gmail.com>)
Re: Conflict handling for COPY FROM  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers

Hello,

The attached patch add error handling for
Extra data

missing data

invalid oid

null oid and 

row count mismatch

And the record that field on the above case write to the file with appended error message in it and in case of unique violation or exclusion constraint violation error the failed record write as it is because the case of the error can not be identified specifically

The new syntax became :

COPY ... WITH ON CONFLICT LOG maximum_error, LOG FILE NAME '…';


Regards

Surafel

Вложения

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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Memory leak with CALL to Procedure with COMMIT.
Следующее
От: Amit Langote
Дата:
Сообщение: Re: Make executor's Range Table an array instead of a List