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

From: Dan Delaney <Dionysos(at)mail(dot)Dionysia(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Error at end of pg_dump output (setting sequence number?)
Date: 2003-01-22 03:45:34
Message-ID: F68DE3E5-2DBB-11D7-A8B2-000A278A2C6A@mail.Dionysia.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message samira 2003-01-22 03:59:54 Calling pgsql function from delphi
Previous Message kanchana 2003-01-22 03:39:49 Re: Fw: configure error with krb5