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

From: Gavin Roy <gavinr(at)aweber(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Regression in PL/PGSQL code using RETURN QUERY with Postgres 14
Date: 2021-10-07 18:38:02
Message-ID: CAFVAjJEN65VJY21DgWZXSKu6Q-hHJ67Frz3Opz3ACmP1yxAePQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2021-10-07 18:47:19 Re: Currently running queries with actual arguments?
Previous Message Bruce Momjian 2021-10-07 18:23:07 Re: Timestamp with vs without time zone.