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

Reply via email to