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@minnesota.com | 612.220.6220
Visit http://www.minnesota.com/