Re: Updateable ResultSet doesn't fetch sequence-generated values

On Sun, 26 Jul 2009, Clemens Eisserer wrote:

> I am using a library which is using the JDBCRowSet API, in order to bind
> a user-interface with a SQL database. The library relies on auto
> generated primary keys (I am using sequences for this task), however
> after inserting, the key-column with the server-side generated value is
> set to 0. I am porting the application from MySQL-5.0 to PostgreSQL-8.3,
> and MySQL sets the key-column to the value generated by auto_increment.
>
> Am I doing something wrong here, or is it a bug? Is that behaviour
> specified at all?

I don't know whether it's unspecified or a bug, but the PG driver doesn't
do this at the moment.

http://pgfoundry.org/tracker/index.php?func=detail&aid=1010520&group_id=1000224&atid=857

Kris Jurka