pg_dump/restore problem

From: "renneyt(at)yahoo(dot)com" <renneyt(at)yahoo(dot)com>
To: postgres <pgsql-admin(at)postgresql(dot)org>
Subject: pg_dump/restore problem
Date: 2006-06-12 20:51:18
Message-ID: 448DD3C6.8050801@yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jeff Frost 2006-06-12 20:54:43 Re: pg_dumpall 8.1.4 large objects error
Previous Message rock well 2006-06-12 18:48:20 Re: Question about postgre sql dll