Re: reading row in backend

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: reading row in backend
Дата
Msg-id 2837.958437843@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: reading row in backend  (Patrick Welche <prlw1@newn.cam.ac.uk>)
Ответы Re: reading row in backend
Список pgsql-hackers
Patrick Welche <prlw1@newn.cam.ac.uk> writes:
>> Hmm, are you claiming that COPY is reporting a bogus line number?
>> If so, that needs to be looked into.

> Yup:

> ERROR:  copy: line 57552, Tuple is too big: size 8152, max size 8140
> PQendcopy: resetting connection
> ERROR:  copy: line 26714, Tuple is too big: size 8164, max size 8140
> PQendcopy: resetting connection

> % wc /home/prlw1/db.out
>  3631449 19833180 186847533 /home/prlw1/db.out

> and the second line is in a table that is over half way through the file.

Looks reasonable enough to me.  The line numbers are within the data
being fed to that copy command --- copy has no way to know that it's
part of some larger script...
        regards, tom lane


В списке pgsql-hackers по дате отправления: