pg_dump/restore problem - Mailing list pgsql-admin

From renneyt@yahoo.com
Subject pg_dump/restore problem
Date
Msg-id 448DD3C6.8050801@yahoo.com
Whole thread Raw
Responses Re: pg_dump/restore problem  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-admin
I am trying to move some data from an 8.0.7 instance to a 7.4.8
instance. I did a pg_dump and then did a pg_restore.
For the most part the data transferred through to the older instance but
I had problems with the sequence updates.

 SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('nw_foo',
'foo_id'), 678, true);
ERROR:  function pg_catalog.pg_get_serial_sequence("unknown", "unknown")
does not exist
HINT:  No function matches the given name and argument types. You may
need to add explicit type casts.

I am looking for a an alternative to manually issuing alter sequence
commands.

Any help appreciated.

pgsql-admin by date:

Previous
From: rock well
Date:
Subject: Re: Question about postgre sql dll
Next
From: Jeff Frost
Date:
Subject: Re: pg_dumpall 8.1.4 large objects error