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