Configure session variables in ALTER ROLE

[vy-ton]

Postgres supports setting session variables for a specific role

[email protected]:57852/movr> alter role vy statement_timeout=10;
invalid syntax: statement ignored: at or near "set": syntax error
SQLSTATE: 42601
DETAIL: source SQL:
alter role vy set idle_in_transaction_session_timeout=10
              ^
HINT: try \h ALTER ROLE

Desired behavior
Configure statement_timeout, idle_in_session_timeout, or idle_in_transaction_session_timeout for different roles associated with different workloads.

[blathers-crl]

Hi @vy-ton, I've guessed the C-ategory of your issue and suitably labeled it. Please re-label if inaccurate.

While you're here, please consider adding an A- label to help keep our repository tidy.

_{🦉 Hoot! I am a Blathers, a bot for CockroachDB. My owner is otan.}

[vy-ton]

Duplicate of #21151