Re: error-tolerant COPY FROM

Поиск
Список
Период
Сортировка
От Csaba Nagy
Тема Re: error-tolerant COPY FROM
Дата
Msg-id 1107523432.19443.339.camel@localhost.localdomain
обсуждение исходный текст
Ответ на Re: error-tolerant COPY FROM  ("Joolz" <joolz@arbodienst-limburg.nl>)
Ответы Re: error-tolerant COPY FROM  ("Joolz" <joolz@arbodienst-limburg.nl>)
Список pgsql-general
[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...

Cheers,
Csaba.



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

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