I would like to clarify the pgsql JDBC's current and intended future
handling of returning auto-generated keys. As far as I can tell,
currently all inserted columns are returned, not just any that were
auto-generated and are keys:
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)"
Is there a time line for fully implementing this functionality? Also,
wouldn't the query parsing resolve to either the third token (query
split on non-word characters limit four matches: "insert into <table>
<rest of query>") or determining for each trigger fired by the query if
it resulted in data being inserted and applying the same logic to those
queries?
Thanks!
Adam