restore problem from pg_dump & serial

From: "Thomas T(dot) Thai" <tom(at)minnesota(dot)com>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: restore problem from pg_dump & serial
Date: 2002-02-22 19:59:23
Message-ID: Pine.NEB.4.43.0202221356490.18178-100000@ns01.minnesota.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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;

line 392318:
COPY "phone_address" FROM stdin;

the other tables were restored ok, and all the data are there. however the
two tables above had NO data. the only difference between these two tables
and the rest is that these have 'auto incrementing' or serial column. i'm
on 7.2.

---
Thomas T. Thai | Minnesota.com | tom(at)minnesota(dot)com | 612.220.6220
Visit http://www.minnesota.com/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-02-22 20:20:39 Re: Regular Expression for 'and' instead of 'or'
Previous Message Tom Lane 2002-02-22 19:18:09 Re: Dump Problem