]> granicus.if.org Git - postgresql/commit
Improve regression test coverage of table lock modes vs permissions.
authorJoe Conway <mail@joeconway.com>
Tue, 7 Jul 2015 21:36:03 +0000 (14:36 -0700)
committerJoe Conway <mail@joeconway.com>
Tue, 7 Jul 2015 21:36:03 +0000 (14:36 -0700)
commitd5f551abcf78cb4e3f6c5d195bd260893443414b
tree86b39d5960699041e450d2155e09d6175ac887cf
parentde184e57e894b13f51c4f30788d20f385b547048
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.
src/test/regress/expected/privileges.out
src/test/regress/sql/privileges.sql