]> 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:35:35 +0000 (14:35 -0700)
committerJoe Conway <mail@joeconway.com>
Tue, 7 Jul 2015 21:35:35 +0000 (14:35 -0700)
commite66a45344ff33d64aa6ff50673ff9fe8577ea6db
tree9ab4f590eded92e685c88269d6fcc52f7c3e4a12
parent61fc420b5710036f3124a44c26a3664a9cc7cdcf
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