restore problem from pg_dump & serial
От | Thomas T. Thai |
---|---|
Тема | restore problem from pg_dump & serial |
Дата | |
Msg-id | Pine.NEB.4.43.0202221356490.18178-100000@ns01.minnesota.com обсуждение исходный текст |
Ответы |
Re: restore problem from pg_dump & serial
|
Список | 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@minnesota.com | 612.220.6220 Visit http://www.minnesota.com/
В списке pgsql-general по дате отправления: