pg_dump/restore problem

Поиск
Список
Период
Сортировка
От renneyt@yahoo.com
Тема pg_dump/restore problem
Дата
Msg-id 448DD3C6.8050801@yahoo.com
обсуждение исходный текст
Ответы Re: pg_dump/restore problem  ("Jim C. Nasby" <jnasby@pervasive.com>)
Список 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 по дате отправления:

Предыдущее
От: rock well
Дата:
Сообщение: Re: Question about postgre sql dll
Следующее
От: Jeff Frost
Дата:
Сообщение: Re: pg_dumpall 8.1.4 large objects error