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

From Joolz
Subject Re: error-tolerant COPY FROM
Date
Msg-id 42814.10.0.4.254.1107523671.squirrel@webmail.arbodienst-limburg.nl
Whole thread Raw
In response to Re: error-tolerant COPY FROM  (Csaba Nagy <nagy@ecircle-ag.com>)
Responses Re: error-tolerant COPY FROM  (Sean Davis <sdavis2@mail.nih.gov>)
List 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 by date:

Previous
From: Csaba Nagy
Date:
Subject: Re: error-tolerant COPY FROM
Next
From: "Joolz"
Date:
Subject: Re: error-tolerant COPY FROM