Re: Copy command-Out of memory error - Mailing list pgsql-novice

From Tom Lane
Subject Re: Copy command-Out of memory error
Date
Msg-id 6191.1349815866@sss.pgh.pa.us
Whole thread Raw
In response to Re: Copy command-Out of memory error  (Nipuna <nipunajoset@gmail.com>)
List pgsql-novice
Nipuna <nipunajoset@gmail.com> writes:
> On Tue, Oct 9, 2012 at 3:08 PM, ktm@rice.edu <ktm@rice.edu> wrote:
>> Did you check for quoting or escaping problems as Tom suggested, as well.

> Yes I did, there seems no problems.

Well, you've clearly got *some* problem, because COPY is evidently
thinking that the logical line continues across many physical lines.

If you're using CSV format then this would be easily explained by a
missing closing quote in some field.  In traditional Postgres COPY
format it's harder to have a runaway line.  But you've not given us any
details about the command or the data, so we really can't do more than
guess.

            regards, tom lane


pgsql-novice by date:

Previous
From: Gezeala M. Bacuño II
Date:
Subject: Re: Copy command-Out of memory error
Next
From: robert wing
Date:
Subject: selecting all tables with references