Re: Support of getting generated keys in driver version 8.4devel

[Cromax <hataraku(at)wp(dot)pl>]

AFAIK it is still not implemented however, you may try to use RETURNS 
clause in INSERT statement.
This works perfectly good.
Tomisław Kityński

Miłosz Tylenda pisze:
> Hello!
>
> This is my environment:
> Driver version: PostgreSQL 8.4devel JDBC3 (build 700)
> PostgreSQL version: 8.3.4
>
> I am looking for getting generated keys support in the driver. The
> changelog says it has basic generated keys support. However,
> DatabaseMetaData.supportsGetGeneratedKeys() returns false and when I
> execute:
>
> con.prepareStatement("insert into tab0 values(default, 444)", new
> String[] {"id"});
>
> I am receiving:
>
> Caused by: org.postgresql.util.PSQLException: Returning autogenerated
> keys is not supported.
> 	at org.postgresql.jdbc3.AbstractJdbc3Connection.prepareStatement
> (AbstractJdbc3Connection.java:448)
>
> Am I missing something? If not, is the generated keys support going to
> be implemented in a future build of 8.4devel?
>
> Happy New Year,
> Milosz
>
>