Re: BUG #1988: keygen not implemented - Mailing list pgsql-bugs

From Oliver Jowett
Subject Re: BUG #1988: keygen not implemented
Date
Msg-id 435BFF57.9030609@opencloud.com
Whole thread Raw
In response to BUG #1988: keygen not implemented  ("Mike Clements" <mikec@actional.com>)
List pgsql-bugs
Mike Clements wrote:

> Insert a row into the table using:
> Connection.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
> The driver throws an exception saying this method is not yet implemented.

This is an optional part of the JDBC spec, and the driver doesn't claim
to support it in the metadata it provides
(DatabaseMetaData.supportsGetGeneratedKeys() returns false).

> What it should do is create the prepared statement so when you execute it,
> the returned ResultSet has the generated primary key.

Unfortunately this requires functionality in the backend that does not
yet exist (support for "INSERT .. RETURNING ...", or similar).

-O

pgsql-bugs by date:

Previous
From: "John Hansen"
Date:
Subject: Re: BUG #1987: UTF8 encoding differences hamper upgrades
Next
From: "Qingqing Zhou"
Date:
Subject: Re: BUG #1985: cannot insert Chinese character into a table encoded with UTF8