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

From Tom Lane
Subject Re: Error at end of pg_dump output (setting sequence number?)
Date
Msg-id 17089.1043214966@sss.pgh.pa.us
Whole thread Raw
In response to Error at end of pg_dump output (setting sequence number?)  (Dan Delaney <Dionysos@mail.Dionysia.org>)
Responses Re: Error at end of pg_dump output (setting sequence number?)
List pgsql-general
Dan Delaney <Dionysos@mail.Dionysia.org> writes:
> 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 command is fine ... to a 7.3 server.  I'm betting you tried to
restore a 7.3 dump into a pre-7.3 server.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: ERROR: Unable to transform targetlist (internal error)
Next
From: Antti Haapala
Date:
Subject: Re: loading delimited files