Skip site navigation (1) Skip section navigation (2)

Re: BUG #1988: keygen not implemented

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Mike Clements <mikec(at)actional(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1988: keygen not implemented
Date: 2005-10-23 21:23:35
Message-ID: 435BFF57.9030609@opencloud.com (view raw or flat)
Thread:
Lists: 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

In response to

pgsql-bugs by date

Next:From: Mike ClementsDate: 2005-10-23 21:55:43
Subject: Re: BUG #1988: keygen not implemented
Previous:From: Guillaume SmetDate: 2005-10-23 21:21:43
Subject: BUG #1991: UPPER problem on special characters

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group