Re: copy losing information - Mailing list pgsql-general

From Tom Lane
Subject Re: copy losing information
Date
Msg-id 18116.1153947913@sss.pgh.pa.us
Whole thread Raw
In response to Re: copy losing information  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Silvela, Jaime (Exchange) wrote:
>> No lines contain quotes. And the same file will sometimes be fully
>> imported, and sometimes lose data. I'm thinking that under heavy loads,
>> the database is discarding INSERTS.

> I don't think that's very likely.

Especially not since he says he's using COPY --- any sort of error would
be all-or-nothing.

Personally I'm wondering about individual rows getting dropped on the
client side.

            regards, tom lane

pgsql-general by date:

Previous
From: Reece Hart
Date:
Subject: Re: copy losing information
Next
From: "Redefined Horizons"
Date:
Subject: Table Inheritence...Just Columns?