Re: copy problem - Mailing list pgsql-bugs

From Tom Lane
Subject Re: copy problem
Date
Msg-id 9515.1076870510@sss.pgh.pa.us
Whole thread Raw
In response to copy problem  (Garrett Dangerfield <dangerimp@cox.net>)
List pgsql-bugs
Garrett Dangerfield <dangerimp@cox.net> writes:
> I am trying to load a data file into a table using the copy command.

> When I do it on a small subset of the data (gotten using the Linux head command) it all works fine, but when I run it
onthe full dataset, I get the following error: 
> ERROR:  repalloc: invalid request size 1073741824
> WARNING:  AbortTransaction and not in in-progress state

This looks like a corrupt-data sort of problem.  You could probably
identify a particular line of the COPY data as causing the failure,
if you were to break the source file down into smaller and smaller
segments.  Please do that and show us the offending line (as well
as your table definition and PG version...)

            regards, tom lane

pgsql-bugs by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Problem with datatype REAL using the = (EQUAL) operator
Next
From: Tom Lane
Date:
Subject: Re: Default Timestamp 'Now' bug with 7.4 on Panther.