"Sebastian Rychter" <srych...@anvet.com.ar> 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 function I found that > pg_get_serial_sequence returns nothing. Probably because the column wasn't actually declared SERIAL to 8.1. I imagine you ignored the failure of the ALTER SEQUENCE OWNED BY command in the 8.3 dump, but that is exactly what the missing piece is here. 8.1 did not have an explicit OWNED BY command, and the only way to make the right dependency magic happen was to use the SERIAL keyword while creating the table. regards, tom lane -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql