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

commit    948b5feb51b9605babc6820475b5ccff44f29552
Author:   steve-chavez <stevechavezast@gmail.com>
Date:     Tue Mar 25 23:15:43 2025 +0000

    test: regress default privileges


 nix/tests/expected/default_privs.out | 12 ++++++++++++
 nix/tests/sql/default_privs.sql      |  2 ++
 2 files changed, 14 insertions(+)

diff --git a/nix/tests/expected/default_privs.out b/nix/tests/expected/default_privs.out
new file mode 100644
index 00000000..862d1008
--- /dev/null
+++ b/nix/tests/expected/default_privs.out
@@ -0,0 +1,12 @@
+-- this tests the outcome of doing ALTER DEFAULT PRIVILEGES..
+select defaclrole::regrole, defaclnamespace::regnamespace, defaclobjtype from pg_default_acl where defaclnamespace = 'public'::regnamespace::oid order by defaclrole::regrole, defaclobjtype;
+   defaclrole   | defaclnamespace | defaclobjtype 
+----------------+-----------------+---------------
+ supabase_admin | public          | S
+ supabase_admin | public          | f
+ supabase_admin | public          | r
+ postgres       | public          | S
+ postgres       | public          | f
+ postgres       | public          | r
+(6 rows)
+
diff --git a/nix/tests/sql/default_privs.sql b/nix/tests/sql/default_privs.sql
new file mode 100644
index 00000000..5df2629b
--- /dev/null
+++ b/nix/tests/sql/default_privs.sql
@@ -0,0 +1,2 @@
+-- this tests the outcome of doing ALTER DEFAULT PRIVILEGES..
+select defaclrole::regrole, defaclnamespace::regnamespace, defaclobjtype from pg_default_acl where defaclnamespace = 'public'::regnamespace::oid order by defaclrole::regrole, defaclobjtype;


[parent: ff0574294c85]