pgsql: Revert "Allow parallel workers to cope with a newly-created sess - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Revert "Allow parallel workers to cope with a newly-created sess
Date
Msg-id E1sZK82-0026zH-SH@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Revert "Allow parallel workers to cope with a newly-created session user ID."

This reverts commit 97380d4803d1f9188a1436c6fe7ecd7db285c55c.

Some buildfarm animals are failing with "cannot change
"client_encoding" during a parallel operation".  It looks like
assign_client_encoding is unhappy at being asked to roll back a
client_encoding setting after a parallel worker encounters a
failure.  There must be more to it though: why didn't I see this
during local testing?  In any case, it's clear that moving the
RestoreGUCState() call is not as side-effect-free as I thought.
Given that the bug f5f30c22e intended to fix has gone unreported
for years, it's not something that's urgent to fix; I'm not
willing to risk messing with it further with only days to our
next release wrap.

Branch
------
REL_14_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/5f851b8bd070c599e537cc8a09a237b2a42f2fbc

Modified Files
--------------
src/backend/access/transam/parallel.c         | 12 ++++--------
src/backend/commands/variable.c               | 10 ++--------
src/test/regress/expected/select_parallel.out | 18 ------------------
src/test/regress/sql/select_parallel.sql      |  9 ---------
4 files changed, 6 insertions(+), 43 deletions(-)


pgsql-committers by date:

Previous
From: Jeff Davis
Date:
Subject: pgsql: Add is_create parameter to RefreshMatviewByOid().
Next
From: Andres Freund
Date:
Subject: pgsql: Evaluate arguments of correlated SubPlans in the referencing Exp