| 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: | Whole Thread | Raw Message | 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? |