supabase-postgres.git / summary / log / commit / refs

commit    a43cbe0f27add2be2d5ac1673df8db69b5ddaaea
Author:   Bobbie Soedirgo <bobbie@soedirgo.dev>
Commit:   Bobbie Soedirgo <31685197+soedirgo@users.noreply.github.com>
Date:     Wed Jul 16 08:36:38 2025 +0000

    test: alter API roles timeout


 nix/tests/expected/roles.out | 5 +++++
 nix/tests/sql/roles.sql      | 7 +++++++
 2 files changed, 12 insertions(+)

diff --git a/nix/tests/expected/roles.out b/nix/tests/expected/roles.out
index aef247b3..3832b0f0 100644
--- a/nix/tests/expected/roles.out
+++ b/nix/tests/expected/roles.out
@@ -521,3 +521,8 @@ order by schema_order, schema_name, privilege_type, grantee, default_for;
  vault              | USAGE          | supabase_admin           | supabase_admin
 (389 rows)
 
+-- postgres can alter API roles' timeout
+set role postgres;
+alter role anon set statement_timeout = '10min';
+alter role anon reset statement_timeout;
+reset role;
diff --git a/nix/tests/sql/roles.sql b/nix/tests/sql/roles.sql
index 34fd5db7..5753d34d 100644
--- a/nix/tests/sql/roles.sql
+++ b/nix/tests/sql/roles.sql
@@ -65,3 +65,10 @@ from (
         a.privilege_type in ('CREATE', 'USAGE')
 ) sub
 order by schema_order, schema_name, privilege_type, grantee, default_for;
+
+-- postgres can alter API roles' timeout
+set role postgres;
+alter role anon set statement_timeout = '10min';
+
+alter role anon reset statement_timeout;
+reset role;


[parent: 77bb5434f084]