Re: Regression in PL/PGSQL code using RETURN QUERY with Postgres 14

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