Add test for MAINTAIN permission with pg_restore_extended_stats() Like its cousin functions for the restore of relation and attribute stats, pg_restore_extended_stats() needs to be run by a user that is the database owner or has MAINTAIN privileges on the table whose stats are restored. This commit adds a regression test ensuring that MAINTAIN is required when calling the function. This test also checks that a ShareUpdateExclusive lock is taken on the table whose stats are restored.
This has been split from the commit that has introduced pg_restore_extended_stats(), for clarity. Author: Corey Huinker <[email protected]> Reviewed-by: Chao Li <[email protected]> Reviewed-by: Michael Paquier <[email protected]> Discussion: https://postgr.es/m/CADkLM=dpz3KFnqP-dgJ-zvRvtjsa8UZv8wDAQdqho=qn3kx...@mail.gmail.com Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/d9abd9e1050db4c2fcdce6fcd8dc0ede6769db16 Modified Files -------------- src/test/regress/expected/stats_import.out | 42 ++++++++++++++++++++++++++++++ src/test/regress/sql/stats_import.sql | 32 +++++++++++++++++++++++ 2 files changed, 74 insertions(+)
