http://jdbc.postgresql.org/changes.html#version_8.4dev-700
The changelog for 8.4dev-700 says:
"Implement basic generated keys support. It does not support returning
columns by index because that requires complicated parsing of the query to
determine the table being used. Right now it supports returning all columns
and columns by name. (jurka)"
I still get "org.postgresql.util.PSQLException: Returning autogenerated keys
is not supported."
If I get the latest source and build it myself, it works.
Are autogenerated keys not supported in dev-700?
Also, I noticed that the way it is written, all statements return generated
keys. "RETURNING" is added to all insert statements. Wouldn't it be better
to let the developer add RETURNING to their SQL statement rather than
forcing all columns back? That way if the developer expects generated keys,
they just need to modify their SQL.
When do you guys plan on the next dev70x release?
