On 10/7/21 11:38 AM, Gavin Roy wrote:
Hi All,
My team was testing against Postgres 14 to ensure we could cleanly
upgrade and we ran across a regression in our PL/PGSQL code related to
the updates to RETURN QUERY.
Our code which works in previous versions of Postgres uses UPDATE
RETURNING and INSERT RETURNING in combination with RETURN QUERY. It
appears that in the parallelism updates, RETURN QUERY now only accepts
SELECT queries.
I'm pretty sure folks are going to want to see an example of the code
and the errors thrown in version 14.
Was this an intentional change in behavior? We can easily refactor our
PL/PGSQL functions to deal with the change, but if it was intentional,
perhaps it should be documented.
Regards,
Gavin
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
