pgsql: In AlterRole, make bypassrls an int - Mailing list pgsql-committers

From Stephen Frost
Subject pgsql: In AlterRole, make bypassrls an int
Date
Msg-id E1ZSlMB-0005ti-0F@gemulon.postgresql.org
Whole thread Raw
Responses Re: pgsql: In AlterRole, make bypassrls an int
List pgsql-committers
In AlterRole, make bypassrls an int

When reworking bypassrls in AlterRole to operate the same way the other
attribute handling is done, I missed that the variable was incorrectly a
bool rather than an int.  This meant that on platforms with an unsigned
char, we could end up with incorrect behavior during ALTER ROLE.

Pointed out by Andres thanks to tests he did changing our bool to be the
one from stdbool.h which showed this and a number of other issues.

Add regression tests to test CREATE/ALTER role for the various role
attributes.  Arrange to leave roles behind for testing pg_dumpall, but
none which have the LOGIN attribute.

Back-patch to 9.5 where the AlterRole bug exists.

Branch
------
REL9_5_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/0070fd8d3c1c8a733c041bfcedd41e38cee0a963

Modified Files
--------------
src/backend/commands/user.c                  |    2 +-
src/test/regress/expected/roleattributes.out |  236 ++++++++++++++++++++++++++
src/test/regress/parallel_schedule           |    2 +-
src/test/regress/serial_schedule             |    1 +
src/test/regress/sql/roleattributes.sql      |   85 ++++++++++
5 files changed, 324 insertions(+), 2 deletions(-)


pgsql-committers by date:

Previous
From: Stephen Frost
Date:
Subject: pgsql: In AlterRole, make bypassrls an int
Next
From: Tom Lane
Date:
Subject: pgsql: Allow record_in() and record_recv() to work for transient record