pgsql: Improve regression test coverage of table lock modes vs permissi
pgsql: Improve regression test coverage of table lock modes vs permissi
От:
Joe Conway <mail@joeconway.com>
Дата:
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(+)