Apparently there is work going on to support sql2003 generated keys.
On the upside you are guaranteed that they truly work now as opposed to some other db's.
Dave
Kris Jurka wrote:
On Sat, 19 Feb 2005, [ISO-8859-15] Sven Köhler wrote:
i know about the nextval and currval functions, but i don't like them,
since they don't apply to tables. To get the generated key, you have to
know the name of the sequence, not just the name of the table.
8.0 now offers the pg_get_serial_sequence function which may help you out.
Does the JDBC-Driver implement the getGeneratedKeys() method?
No, see the many discussions of this in the archives, for example:
http://gborg.postgresql.org/project/pgjdbc/bugs/bugupdate.php?984
http://archives.postgresql.org/pgsql-jdbc/2004-09/msg00190.php
Kris Jurka
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
--
Dave Cramer
http://www.postgresintl.com
519 939 0336
ICQ#14675561