| From: | "Joolz" <joolz(at)arbodienst-limburg(dot)nl> |
|---|---|
| To: | "Csaba Nagy" <nagy(at)ecircle-ag(dot)com> |
| Cc: | "Michael Glaesemann" <grzm(at)myrealbox(dot)com>, "Postgres general mailing list" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: error-tolerant COPY FROM |
| Date: | 2005-02-04 13:27:51 |
| Message-ID: | 42814.10.0.4.254.1107523671.squirrel@webmail.arbodienst-limburg.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joolz | 2005-02-04 13:30:20 | Re: error-tolerant COPY FROM |
| Previous Message | Csaba Nagy | 2005-02-04 13:23:52 | Re: error-tolerant COPY FROM |