SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-16-2008, 12:59 AM
| ||||
| ||||
 Re: Retrieving last InsertedID : INSERT... RETURNING safe ? Thanks Heikki ! That makes things clear to me now, i ll go on with the RETURNING method as i have no restrictions in term of portability at all (lucky me  )Thanks again Cheers Seb. Le mer , "Heikki Linnakangas" a écrit: >spa >stor@motionsponsor.com wrote: >> Only one exception is regarding the best method to >retrieve the last inserted id (serial). There are many posts on this topic >but i couldn t find a definitive response. >> I am using postgresql version 8.2.6 and jdbc 8.2_p505, >i ve been experiencing INSERT statement with RETURNING myID, using an >executeQuery it works great, i retrieve the proper value everytime at least > from the few tests i have been doin locally. >> Is it THAT easy or could this method break somehow in a >live environement ? > > >It is that easy, and that is a good way to do it. > > > >Alternatively, if you need to support older PostgreSQL version for > >example, you could use a "SELECT currval('sequence')" query after the > >INSERT. > > > >Much of the of discussion you saw were probably about implementing the > >JDBC getGeneratedKeys() function that some applications need for > >portability reasons, or because of middleware that doesn't know how to > >do INSERT RETURNING. PostgreSQL driver doesn't support that at the > >moment, but as long as you don't need it, you'll be fine. > > > >-- > >Heikki Linnakangas > >EnterpriseDB http://www.enterprisedb.com > > > ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly      |
Linear Mode
