Re: restore problem from pg_dump & serial

"Thomas T. Thai" <tom@minnesota.com> writes:
> i tried to restore a dump and encountered this error:
> $ psql yellowpages -f yellowpages.data
> You are now connected as new user pgsql.
> psql:yellowpages.data:13: ERROR:  copy: line 619, Syntax error
> psql:yellowpages.data:13: lost synchronization with server, resetting
> connection
> psql:yellowpages.data:392318: ERROR:  copy: line 100, Syntax error
> psql:yellowpages.data:392318: lost synchronization with server, resetting
> connection

> line 13:
> COPY "phone_cat" FROM stdin;

But what's the 619'th line of data in this COPY?  And the 100'th line
in the other one?  And what are the schemas of the two tables?

            regards, tom lane