Skip site navigation (1) Skip section navigation (2)

Re: copy problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: garrett(at)dangerimp(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: copy problem
Date: 2004-02-15 18:41:50
Message-ID: 9515.1076870510@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Garrett Dangerfield <dangerimp(at)cox(dot)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 on the 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

In response to

  • copy problem at 2004-02-12 22:04:05 from Garrett Dangerfield

pgsql-bugs by date

Next:From: Bruno Wolff IIIDate: 2004-02-15 19:55:54
Subject: Re: Problem with datatype REAL using the = (EQUAL) operator
Previous:From: Tom LaneDate: 2004-02-15 18:31:32
Subject: Re: Default Timestamp 'Now' bug with 7.4 on Panther.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group