Re: Regression in PL/PGSQL code using RETURN QUERY with Postgres 14 - Mailing list pgsql-general

From Gavin Roy
Subject Re: Regression in PL/PGSQL code using RETURN QUERY with Postgres 14
Date
Msg-id CAFVAjJEd_SDPWAFECi7SoParkoWAPBP15+2iXv_KjZXNDHd3Ug@mail.gmail.com
Whole thread Raw
In response to Re: Regression in PL/PGSQL code using RETURN QUERY with Postgres 14  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Thanks so much Tom!

Regards,

Gavin

On Thu, Oct 7, 2021 at 3:05 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Gavin Roy <gavinr@aweber.com> writes:
> 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.

Yeah, that's a mistake, previously reported and fixed at

https://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=e0eba586b

                        regards, tom lane

pgsql-general by date:

Previous
From: Gavin Roy
Date:
Subject: Re: Regression in PL/PGSQL code using RETURN QUERY with Postgres 14
Next
From: "Peter J. Holzer"
Date:
Subject: Re: Misplaced double quotes in error message