Horton

Add regression test for DROP OWNED BY with default ACLs

Michael Paquier <michael@paquier.xyz>

View on postgr.es
Commit: a36dc04d424a6bfa03ee2cf75c85a6b7f9697e70
Author: Michael Paquier <michael@paquier.xyz>
Date: 2021-01-20T04:28:10Z
Releases: 14.0 
Add regression test for DROP OWNED BY with default ACLs

DROP OWNED BY has a specific code path to remove ACLs stored in
pg_default_acl when cleaning up shared dependencies that had no
coverage with the existing tests.  This issue has been found while
digging into the bug fixed by 21378e1.

As ALTER DEFAULT PRIVILEGES impacts the ACLs of all objects created
while the default permissions are visible, the test uses a transaction
rollback to isolate the test and avoid any impact with other sessions
running in parallel.

Reviewed-by: Álvaro Herrera
Discussion: https://postgr.es/m/YAbQ1OD+3ip4lRv8@paquier.xyz

Files

PathChange+/−
src/test/regress/expected/privileges.out modified +29 −0
src/test/regress/sql/privileges.sql modified +20 −0

Discussion