Postgres Pro
Downloads
Home   >   mailing lists

Re: restore problem from pg_dump & serial - Mailing list pgsql-general

From Tom Lane
Subject Re: restore problem from pg_dump & serial
Date
Msg-id 21731.1014423409@sss.pgh.pa.us
Whole thread Raw
In response to restore problem from pg_dump & serial  ("Thomas T. Thai" <tom@minnesota.com>)
List pgsql-general
Tree view 
"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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Speed comparison to Oracle. Why was this query slower on pgsql?
Next
From: Bruce Momjian
Date:
Subject: Re: Speed comparison to Oracle. Why was this query slower