On Fri, 5 Mar 2004, Rudolpho Gian-Franco Gugliotta wrote:
> Hi, > > i'm using the jdbc postgresql driver. I need to fetch the oid of a just > insertet row > (getGeneratedKeys() feature). That' why i ask you to provide me the > source code > to implement this feature.It would be glad if you tell me how and where > to get > these sources. > The driver source is included in the main source tree for the 7.4 series, but for the upcoming 7.5 release the driver is being developed independently here: http://gborg.postgresql.org/project/pgjdbc/projdisplay.php Some discussion of the problems with implementing getGeneratedKeys is here: http://archives.postgresql.org/pgsql-jdbc/2003-12/threads.php#00193 Finally you don't necessarily need to implement getGeneratedKeys if you don't mind using some pg specific code along the lines of the following: Statement stmt = conn.createStatement(); stmt.executeUpdate("INSERT INTO t VALUES (1)"); long oid = ((org.postgresql.PGStatement)stmt).getLastOID(); Kris Jurka ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match