Re: error-tolerant COPY FROM

From: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
To: Joolz <joolz(at)arbodienst-limburg(dot)nl>
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:23:52
Message-ID: 1107523432.19443.339.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joolz 2005-02-04 13:27:51 Re: error-tolerant COPY FROM
Previous Message Sean Davis 2005-02-04 13:15:56 Re: error-tolerant COPY FROM