Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Regression in PL/PGSQL code using RETURN QUERY with Postgres 14
Date
Msg-id 162604.1633633500@sss.pgh.pa.us
Whole thread Raw
In response to Regression in PL/PGSQL code using RETURN QUERY with Postgres 14  (Gavin Roy <gavinr@aweber.com>)
Responses Re: Regression in PL/PGSQL code using RETURN QUERY with Postgres 14
List pgsql-general
Tree view 
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: Adrian Klaver
Date:
Subject: Re: Regression in PL/PGSQL code using RETURN QUERY with Postgres 14
Next
From: Gavin Roy
Date:
Subject: Re: Regression in PL/PGSQL code using RETURN QUERY with Postgres 14