Postgres Pro
Downloads
Home   >   mailing lists

Downgrade database and problem with sequences - Mailing list pgsql-sql

From Sebastian Rychter
Subject Downgrade database and problem with sequences
Date
Msg-id 001301c961da$39ea9710$adbfc530$@com.ar
Whole thread Raw
In response to Re: index compatible date_trunc in postgres?  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Responses Re: Downgrade database and problem with sequences  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: index compatible date_trunc in postgres?
Next
From: Tom Lane
Date:
Subject: Re: Downgrade database and problem with sequences