diff -U3 /home/postgres/postgres/src/test/regress/expected/session_variables_acl.out /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/session_variables_acl.out --- /home/postgres/postgres/src/test/regress/expected/session_variables_acl.out Wed Oct 1 21:20:38 2025 +++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/session_variables_acl.out Wed Oct 1 21:28:24 2025 @@ -161,8 +161,12 @@ SET ROLE TO DEFAULT; DROP VARIABLE svartest_acl.sesvar20; +ERROR: cache lookup failed for function 47652 DROP VARIABLE svartest_acl.sesvar21; DROP SCHEMA svartest_acl; +ERROR: cannot drop schema svartest_acl because other objects depend on it +DETAIL: session variable svartest_acl.sesvar20 depends on schema svartest_acl +HINT: Use DROP ... CASCADE to drop the dependent objects too. -- -- end of test: GRANT|REVOKE SELECT|UPDATE ON ALL VARIABLES IN SCHEMA -- @@ -333,3 +337,6 @@ DROP ROLE regress_variable_r2_acl; REVOKE ALL ON SCHEMA public FROM regress_variable_owner_acl; DROP ROLE regress_variable_owner_acl; +ERROR: role "regress_variable_owner_acl" cannot be dropped because some objects depend on it +DETAIL: privileges for schema svartest_acl +owner of session variable svartest_acl.sesvar20