pgsql: Improve regression test coverage of table lock modes vs permissi

From: Joe Conway <mail(at)joeconway(dot)com>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Improve regression test coverage of table lock modes vs permissi
Date: 2015-07-07 21:36:55
Message-ID: E1ZCaXv-0008Ag-9X@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
------
REL9_5_STABLE

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

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

Browse pgsql-committers by date

  From Date Subject
Next Message Heikki Linnakangas 2015-07-08 17:42:24 pgsql: Replace our hacked version of ax_pthread.m4 with latest upstream
Previous Message Joe Conway 2015-07-07 21:36:53 pgsql: Improve regression test coverage of table lock modes vs permissi