Re: reading row in backend
От | Patrick Welche |
---|---|
Тема | Re: reading row in backend |
Дата | |
Msg-id | 20000516104205.A22959@quartz.newn.cam.ac.uk обсуждение исходный текст |
Ответ на | Re: reading row in backend (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-hackers |
On Mon, May 15, 2000 at 08:44:03PM -0400, Tom Lane wrote: > 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... Ah! Thank you! So it's 57552 rows down from "COPY" ! OK Cheers, Patrick
В списке pgsql-hackers по дате отправления: