Re: [SQL] Downgrade database and problem with sequences

2008-12-19 Thread Tom Lane
"Sebastian Rychter" writes: > 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 functio

[SQL] Downgrade database and problem with sequences

2008-12-19 Thread Sebastian Rychter
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