Обсуждение: How to get generated primary key?
Hi, 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. Does the JDBC-Driver implement the getGeneratedKeys() method? If not, does PostgreSQL provide any way to get the just generated key, without knowing the sequencename? Thx Sven
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
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 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