pgsql: Improve regression test coverage of table lock modes vs permissi - Mailing list pgsql-committers

From Joe Conway
Subject pgsql: Improve regression test coverage of table lock modes vs permissi
Date
Msg-id E1ZCaXt-0008AK-5Y@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Improve regression test coverage of table lock modes vs permissions.

Test the interactions with permissions and LOCK TABLE. Specifically
ROW EXCLUSIVE, ACCESS SHARE, and ACCESS EXCLUSIVE modes against
SELECT, INSERT, UPDATE, DELETE, and TRUNCATE permissions. Discussed
by Stephen Frost and Michael Paquier, patch by the latter. Backpatch
to 9.5 where matching behavior was first committed.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/e66a45344ff33d64aa6ff50673ff9fe8577ea6db

Modified Files
--------------
src/test/regress/expected/privileges.out |   83 +++++++++++++++++++++++++++++
src/test/regress/sql/privileges.sql      |   84 ++++++++++++++++++++++++++++++
2 files changed, 167 insertions(+)


pgsql-committers by date:

Previous
From: Fujii Masao
Date:
Subject: pgsql: Fix incorrect path in pg_regress log messages.
Next
From: Joe Conway
Date:
Subject: pgsql: Improve regression test coverage of table lock modes vs permissi