Have a look at the postgresql logs to see what ibatis is actually
generating. There is no reason it should not work
Dave
On Tue, Dec 7, 2010 at 1:49 PM, - <grandebuzon@gmail.com> wrote:
> RETURNING id problem with insert.
> Hello everyone.
> Iam trying to do an insert for return generated id INSERT RETURNING id. In
> postgres editor it work without problems, but in code execution - java 1.6
> with iBatis 3 (8.4 postgres driver version 8.4-702) gives the error - Caused
> by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "
> RETURNING. "
> It this means Postgres does not support Returning to insert?
> I found this online -
> http://stackoverflow.com/questions/1769595/concurrency-issues-when-retriveing-ids-of-newly-inserted-rows-with-ibatis
> but not how to do <statement ... Second answer, I get error iBatis xml
> editor. I think it's for iBatis 2 version.
> Thank you very much for responding.
>
> Español.
> Problema con RETURNING id con insert.
> Hola a todos.
> Intento hacer un insert y que me devuelva id generada con INSERT ....
> RETURNING id. En editor de postgres funcciona sin problemas, pero en
> ejecucion java 1.6 con iBatis 3 (version postgres 8.4 driver 8.4-702) da el
> error - Caused by: org.postgresql.util.PSQLException: ERROR: error de
> sintaxis en o cerca de «RETURNING».
> Postgres no soporta returning con insert ?
> He encontrado esto en internet -
> http://stackoverflow.com/questions/1769595/concurrency-issues-when-retriveing-ids-of-newly-inserted-rows-with-ibatis
> pero no se como hacer <statement ... de segunda respuesta, me da error
> editor xml de iBatis. Pienso que es para version iBatis 2
> Muchas gracias por responder.
>
>
>
>