Downgrade database and problem with sequences

Поиск
Список
Период
Сортировка
От Sebastian Rychter
Тема Downgrade database and problem with sequences
Дата
Msg-id 001301c961da$39ea9710$adbfc530$@com.ar
обсуждение исходный текст
Ответ на Re: index compatible date_trunc in postgres?  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Ответы Re: Downgrade database and problem with sequences  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
I am currently using postgresql 8.3 and whenever I want to get the last
inserted ID use :
Select currval(pg_get_serial_sequence(table, field))

Then, I had to downgrade a database for certain customer to use postgresql
8.1, and when I execute that same function I found that
pg_get_serial_sequence returns nothing.

Is there any way to dump my database and then restore it on a previous
version and keep using that pg_get_serial_sequence()  function ? 

Thanks,

Sebastian



В списке pgsql-sql по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: index compatible date_trunc in postgres?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Downgrade database and problem with sequences