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
Re: Conflict handling for COPY FROM
Список 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 по дате отправления: