| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike Clements | 2005-10-23 21:55:43 | Re: BUG #1988: keygen not implemented |
| Previous Message | Guillaume Smet | 2005-10-23 21:21:43 | BUG #1991: UPPER problem on special characters |