Re: error-tolerant COPY FROM - Mailing list pgsql-general

From Csaba Nagy
Subject Re: error-tolerant COPY FROM
Date
Msg-id 1107523432.19443.339.camel@localhost.localdomain
Whole thread Raw
In response to Re: error-tolerant COPY FROM  ("Joolz" <joolz@arbodienst-limburg.nl>)
Responses Re: error-tolerant COPY FROM  ("Joolz" <joolz@arbodienst-limburg.nl>)
List 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 by date:

Previous
From: Sean Davis
Date:
Subject: Re: error-tolerant COPY FROM
Next
From: "Joolz"
Date:
Subject: Re: error-tolerant COPY FROM