[cvsnt-dev] Re: postgres doesn't do INSERT ... RETURNS

Tony Hoyle tony.hoyle at march-hare.com
Mon Jul 24 15:05:16 UTC 2006


Community technical support mailing list was retired 2010 and replaced with a professional technical support team. For assistance please contact: Pre-sales Technical support via email to sales@march-hare.com.


David Somers wrote:
> Tony,
> 
> cvsapi/db/postgres/PostgresConnection is broken.
> ::ExecuteAndReturnIdentity makes use of "RETURNING" which is an ORACLE (and
> SQLITE?)-specific option.

According to the to a site I read that's the recommended way of getting the id 
back on postgres....  maybe only works on the latest one.

Can't see any other way of doing it that's safe (using two statements is not
safe as you may have many clients inserting).

Tony


More information about the cvsnt-dev mailing list