Re: copy problem

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: copy problem
Дата
Msg-id 9515.1076870510@sss.pgh.pa.us
обсуждение исходный текст
Ответ на copy problem  (Garrett Dangerfield <dangerimp@cox.net>)
Список 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 по дате отправления:

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: Problem with datatype REAL using the = (EQUAL) operator
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Default Timestamp 'Now' bug with 7.4 on Panther.