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@aklaver.com