RETURNING id problem with insert.
| От | - |
|---|---|
| Тема | RETURNING id problem with insert. |
| Дата | |
| Msg-id | AANLkTin5WvhHbi0rN4BZDhuc1i9_8yNnoKMObfkzXDrK@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: RETURNING id problem with insert.
|
| Список | pgsql-jdbc |
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.
В списке pgsql-jdbc по дате отправления: