insertRow and updateable resultset

All of this pertains to PostgreSQL 7.1.3 and the jdbc3 development driver
that I downloaded today and also the stable driver.

I am using an updateable ResultSet and insertRow() to insert a row, which
works fine.
I then do a refreshRow() and try to retrieve the auto-generated primary key,
which doesn’t work. I just get back a null value. I am currently using the
oid to re-select the row as a workaround, but want a database-independent
way of getting the key.

Sample code:

ResultSet uprs = stmt.executeQuery("SELECT * FROM login WHERE 1=0");
uprs.moveToInsertRow();
uprs.updateObject(“email”, email);
uprs.insertRow();
uprs.next();
uprs.refreshRow();
String loginId = uprs.getString(); // returns null

Note that the same thing happens if I leave out the ‘uprs.next()’. (As an
aside, this is a bug because the refreshRow() should fail if next() is not
called; the java docs state that refreshRow() should fail on the insert
row).

Can anyone confirm that the code I’m using should return the generated
primary key from the database? I’ve looked at the driver code
(AbstractJdbc2ResultSet.java) and couldn’t see why this wasn’t working.

Thanks,
Joel