Hello! I hope this is the right list for extension dev questions? I am finding odd behavior running make installcheck for a postgres extension. The user running the suite is a superuser ("jfinzel"). Once I create any object as a test role, reset role does not work, although it does work to do set role jfinzel. See:
SELECT CURRENT_ROLE; current_user -------------- jfinzel (1 row) SET ROLE test_pgl_ddl_deploy; SELECT CURRENT_ROLE; current_user --------------------- test_pgl_ddl_deploy (1 row) RESET ROLE; SELECT CURRENT_ROLE; current_user -------------- jfinzel (1 row) SET ROLE test_pgl_ddl_deploy; CREATE SCHEMA special; CREATE TABLE special.foo (id serial primary key, foo text, bar text); CREATE TABLE special.bar (id serial primary key, super text, man text); SELECT CURRENT_ROLE; current_user --------------------- test_pgl_ddl_deploy (1 row) RESET ROLE; SELECT CURRENT_ROLE; current_user --------------------- test_pgl_ddl_deploy (1 row) SET SESSION AUTHORIZATION DEFAULT; RESET ROLE; SELECT CURRENT_ROLE; current_user --------------------- test_pgl_ddl_deploy (1 row) What am I missing here? Any comments much appreciated. Thanks, Jeremy Finzel