Re: "RETURNING PRIMARY KEY" syntax extension
| От | Jochem van Dieten |
|---|---|
| Тема | Re: "RETURNING PRIMARY KEY" syntax extension |
| Дата | |
| Msg-id | CABPCP-3N3UU_QwFQJ1Zvv4ULas75TMihJvK5N864QJkUC2KiQA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: "RETURNING PRIMARY KEY" syntax extension (Ian Barwick <ian@2ndquadrant.com>) |
| Ответы |
Re: "RETURNING PRIMARY KEY" syntax extension
Re: "RETURNING PRIMARY KEY" syntax extension |
| Список | pgsql-hackers |
On Thu, Jun 12, 2014 at 12:25 PM, Ian Barwick wrote:
Unfortunately that seems to be a JDBC-specific issue, which is outsideOn 14/06/12 18:46, Jochem van Dieten wrote:
> I haven't checked the code, but I am hoping it will help with the problem
> where a RETURNING * is added to a statement that is not an insert or update
> by the JDBC driver. That has been reported on the JDBC list at least twice,
> and the proposed workaround is neither very elegant nor very robust:
> https://groups.google.com/forum/#!msg/pgsql.interfaces.jdbc/7WY60JX3qyo/-v1fqDqLQKwJ
of the scope of this particular patch (which proposes additional server-side
syntax intended to make RETURNING * operations more efficient for
certain use cases, but which is in itself not a JDBC change).
But the obvious way to fix the JDBC issue is not to fix it by adding a 'mini parser' on the JDBC side, but to make SELECT ... RETURNING PRIMARY KEY a regular select that silently ignores the returning clause and doesn't throw an error on the server-side.
That might still be outside the scope of this particular patch, but it would provide (additional) justification if it were supported.
Jochem
Jochem van Dieten
http://jochem.vandieten.net/
В списке pgsql-hackers по дате отправления: