Re: error-tolerant COPY FROM

Поиск
Список
Период
Сортировка
От Joolz
Тема Re: error-tolerant COPY FROM
Дата
Msg-id 42814.10.0.4.254.1107523671.squirrel@webmail.arbodienst-limburg.nl
обсуждение исходный текст
Ответ на Re: error-tolerant COPY FROM  (Csaba Nagy <nagy@ecircle-ag.com>)
Ответы Re: error-tolerant COPY FROM  (Sean Davis <sdavis2@mail.nih.gov>)
Список pgsql-general
Csaba Nagy zei:
> [snip]
>> I'm afraid this is a bit too indirect IMHO. As I want to know the
>> line number in which an error occurs, I would have to traverse the
>> error-tolerant table with limit 1 offset N, and report N when an
>> error occurs, hoping that the row order is identical to the line
>> order in the csv file.
>
> So why don't you insert the line number too in the error tolerant
> table
> when you do the import ? Then you will have the line number all the
> time. Not that I would understand what will you do with that line
> number, once you already have all the data in the table...

I need the line number to let the customer know which data were
refused, and the corresponding errormessage to let him know why.


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

Предыдущее
От: Csaba Nagy
Дата:
Сообщение: Re: error-tolerant COPY FROM
Следующее
От: "Joolz"
Дата:
Сообщение: Re: error-tolerant COPY FROM