Horton

Fix problems with the "role" GUC and parallel query.

Robert Haas <rhaas@postgresql.org>

View on postgr.es
Commit: 69125c883df30e6232412d35bf7c89b8c3ad1305
Author: Robert Haas <rhaas@postgresql.org>
Date: 2017-10-29T07:34:37Z
Releases: 10.1 
Fix problems with the "role" GUC and parallel query.

Without this fix, dropping a role can sometimes result in parallel
query failures in sessions that have used "SET ROLE" to assume the
dropped role, even if that setting isn't active any more.

Report by Pavan Deolasee.  Patch by Amit Kapila, reviewed by me.

Discussion: http://postgr.es/m/CABOikdOomRcZsLsLK+Z+qENM1zxyaWnAvFh3MJZzZnnKiF+REg@mail.gmail.com

Files

PathChange+/−
src/backend/access/transam/parallel.c modified +11 −0
src/backend/utils/misc/guc.c modified +9 −16
src/include/utils/guc.h modified +1 −0
src/test/regress/expected/select_parallel.out modified +16 −0
src/test/regress/sql/select_parallel.sql modified +11 −0

Discussion