From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Thomas T(dot) Thai" <tom(at)minnesota(dot)com> |
Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: restore problem from pg_dump & serial |
Date: | 2002-02-23 00:16:49 |
Message-ID: | 21731.1014423409@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
"Thomas T. Thai" <tom(at)minnesota(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2002-02-23 00:20:56 | Re: Speed comparison to Oracle. Why was this query slower |
Previous Message | Tom Lane | 2002-02-22 23:55:44 | Re: Speed comparison to Oracle. Why was this query slower on pgsql? |