Error at end of pg_dump output (setting sequence number?)

Поиск
Список
Период
Сортировка
От Dan Delaney
Тема Error at end of pg_dump output (setting sequence number?)
Дата
Msg-id F68DE3E5-2DBB-11D7-A8B2-000A278A2C6A@mail.Dionysia.org
обсуждение исходный текст
Ответы Re: Error at end of pg_dump output (setting sequence number?)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi all.

I just did a pg_dump (with the -d param) of one of my databases in
order to move it to a new server. When I put it into the new server,
all the tables were created just fine, and all of the data was inserted
just fine, then I got an error at the very end which read:

    ERROR:  parser: parse error at or near "("

The line that seems to have given that error was at the very end of the
pg_dump output, and it was:

    SELECT pg_catalog.setval ('order_number_seq', 10039784, true);

That does seem to me to be a strange select statement. Anyone know what
the problem is? Is this a bug in pg_dump? (Was that supposed to have
been an INSERT statement?)

Thanks
--Dan


В списке pgsql-general по дате отправления:

Предыдущее
От: "kanchana"
Дата:
Сообщение: Re: Fw: configure error with krb5
Следующее
От: "Qiao Jian ( Net2Room)"
Дата:
Сообщение: FW: ERROR: Relation "pg_user" does not exist