Re: RETURN_GENERATED_KEYS does not work when insert statement is using a "with" query.

From: Vladimir Sitnikov <sitnikov(dot)vladimir(at)gmail(dot)com>
To: Frédéric Trégon <frederic(dot)tregon(at)codingame(dot)com>
Cc: developers <developers(at)codingame(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: RETURN_GENERATED_KEYS does not work when insert statement is using a "with" query.
Date: 2017-09-01 13:02:39
Message-ID: CAB=Je-G3OLPrd76c5f0edg=1zOpzCbSjGt0yeB0H5NaV-7WYbA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,

Frédéric>What do you think?

This is known as https://github.com/pgjdbc/pgjdbc/issues/845

Feel free to chime in an update the parser.
I think the idea there is to keep looking for "insert/update/delete/select"
keywords on a top level (outside of the braces) in case the first keyword
was "with".

Vladimir

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Yury Petukhou 2017-09-06 09:31:57 IllegalState Exception
Previous Message Simon Riggs 2017-09-01 11:44:30 Re: Statement-level rollback