autogenerated keys is not supported in 8.4dev-700 as specified in the changelog

From: "Scott Murphy" <sdmurphy(at)pictage(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: autogenerated keys is not supported in 8.4dev-700 as specified in the changelog
Date: 2009-04-03 18:59:40
Message-ID: 8A40010480284A7F9F26B653131E8FF5@pictageinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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?

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2009-04-03 21:16:49 Re: autogenerated keys is not supported in 8.4dev-700 as specified in the changelog
Previous Message Oliver Jowett 2009-03-31 12:13:03 Re: Bug with duplicate column names via JDBC MetaData (ORDINAL_POSITION)