Error at end of pg_dump output (setting sequence number?) - Mailing list pgsql-general

From Dan Delaney
Subject Error at end of pg_dump output (setting sequence number?)
Date
Msg-id F68DE3E5-2DBB-11D7-A8B2-000A278A2C6A@mail.Dionysia.org
Whole thread Raw
Responses Re: Error at end of pg_dump output (setting sequence number?)
List 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 by date:

Previous
From: "kanchana"
Date:
Subject: Re: Fw: configure error with krb5
Next
From: "Qiao Jian ( Net2Room)"
Date:
Subject: FW: ERROR: Relation "pg_user" does not exist