Setting statement_timeout on a role correctly in postgres

Question

Assigning a statement_timeout to a role in postgres does not appear to persist the setting.

Example:

-- Set the statement_timeout on a role
alter role api_user set statement_timeout = '500ms';

-- Start a transaction
begin;
    -- Assume the role
    set role api_user;

    -- Display statement_timeout setting
    show statement_timeout;
    -- |--------------------------|
    -- | statement_timeout (text) |
    -- |--------------------------|
    -- | 0                        |
    -- |--------------------------|

Since the statement_timeout for api_user was set to 500ms I expected 500ms as the output. Instead, it shows the default statement_timeout of 0, or unlimited.

What am I missing here?

Laurenz Albe · Accepted Answer · 2021-02-16 13:28:21Z

2

The session is persisted, but assuming the role with SET ROLE or SET SESSION AUTHORIZATION doesn't set the parameter. You have to log into the database as role api_user for that.

answered Feb 16, 2021 at 13:28

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Setting statement_timeout on a role correctly in postgres

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related