Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Downgrade database and problem with sequences
- From: "Sebastian Rychter" <srychter(at)anvet(dot)com(dot)ar>
- To: "'sql pgsql'" <pgsql-sql(at)postgresql(dot)org>
- Subject: Downgrade database and problem with sequences
- Date: Fri, 19 Dec 2008 11:03:42 -0200
- Message-id: <001301c961da$39ea9710$adbfc530$@com.ar> <text/plain>
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
- Follow-Ups:
- Re: Downgrade database and problem with sequences
- From: Tom Lane
- Re: Downgrade database and problem with sequences
- References:
- index compatible date_trunc in postgres?
- From: Bryce Nesbitt
- Re: index compatible date_trunc in postgres?
- From: Scott Marlowe
- index compatible date_trunc in postgres?
- Prev by Date: Re: index compatible date_trunc in postgres?
- Next by Date: Re: Downgrade database and problem with sequences
- Previous by thread: Re: index compatible date_trunc in postgres?
- Next by thread: Re: Downgrade database and problem with sequences
- Indexes: