run-check-harness-psql-17-cli
checks.aarch64-linux.psql_17_cli
· build #471
· raw
12026-10-27 10:47:40 [INFO] Starting HTTP mock server (will find free port)...22026-10-27 10:47:41 [INFO] HTTP mock server started on port 888032026-10-27 10:47:41 [INFO] Creating temporary PostgreSQL cluster at /build/tmp.OtiT8d8AMV42026-10-27 10:47:42 [INFO] Generated preload libraries: pg_cron, pg_net, pgsodium, supabase_vault52026-10-27 10:47:42 [INFO] Checking shared_preload_libraries setting:62026-10-27 10:47:42 [INFO] 721:shared_preload_libraries = 'pg_cron, pg_net, pgsodium, supabase_vault' # (change requires restart)72026-10-27 10:47:42 [INFO] Configuring local auth82026-10-27 10:47:42 [INFO] Waiting for PostgreSQL to be ready...92026-10-27 10:47:42 [INFO] PostgreSQL is ready102026-10-27 10:47:42 [INFO] Creating test database112026-10-27 10:47:42 [INFO] CLI variant detected - loading CLI prime SQL file122026-10-27 10:47:43 [INFO] Creating test_config table132026-10-27 10:47:43 [INFO] Running pgtap test: auth.sql142026-10-27 10:47:43 [INFO] Running pgtap test: create_statistics_priv.sql152026-10-27 10:47:43 [INFO] Running pgtap test: dblink.sql162026-10-27 10:47:43 [INFO] Running pgtap test: docs-array-test.sql172026-10-27 10:47:43 [INFO] Running pgtap test: docs-cascades-deletes.sql182026-10-27 10:47:43 [INFO] Running pgtap test: docs-connections.sql192026-10-27 10:47:43 [INFO] Running pgtap test: docs-enums.sql202026-10-27 10:47:43 [INFO] Running pgtap test: docs-full-text-search.sql212026-10-27 10:47:43 [INFO] Running pgtap test: docs-functions.sql222026-10-27 10:47:44 [INFO] Running pgtap test: docs-indexes.sql232026-10-27 10:47:44 [INFO] Running pgtap test: docs-json.sql242026-10-27 10:47:44 [INFO] Running pgtap test: docs-partitioning.sql252026-10-27 10:47:44 [INFO] Running pgtap test: docs-tables-and-data.sql262026-10-27 10:47:44 [INFO] Running pgtap test: docs-triggers.sql272026-10-27 10:47:44 [INFO] Running pgtap test: docs-webhooks.sql282026-10-27 10:47:44 [INFO] Running pgtap test: enable_tracking.sql292026-10-27 10:47:44 [INFO] Running pgtap test: event_trigger_search_path.sql302026-10-27 10:47:44 [INFO] Running pgtap test: intarray_ltree_query.sql312026-10-27 10:47:44 [INFO] Running pgtap test: ltree_label_overflow.sql322026-10-27 10:47:45 [INFO] Running pgtap test: multirange_create_priv.sql332026-10-27 10:47:45 [INFO] Running pgtap test: operator_breaking_change.sql342026-10-27 10:47:45 [INFO] Running pgtap test: pg-safeupdate.sql352026-10-27 10:47:45 [INFO] Running pgtap test: pg_graphql.sql362026-10-27 10:47:45 [INFO] Running pgtap test: pg_net.sql372026-10-27 10:47:45 [INFO] Running pgtap test: pg_plan_filter.sql382026-10-27 10:47:45 [INFO] Running pgtap test: pgaudit.sql392026-10-27 10:47:45 [INFO] Running pgtap test: pgbouncer.sql402026-10-27 10:47:45 [INFO] Running pgtap test: pgcrypto_cipher_matrix.sql412026-10-27 10:47:45 [INFO] Running pgtap test: pgsodium.sql422026-10-27 10:47:45 [INFO] Running pgtap test: realtime.sql432026-10-27 10:47:45 [INFO] Running pgtap test: replica_identity_upsert.sql442026-10-27 10:47:45 [INFO] Running pgtap test: storage.sql452026-10-27 10:47:45 [INFO] Running pgtap test: supautils_reserved_roles.sql462026-10-27 10:47:45 [INFO] Running pgtap test: supautils_warehouse_writer.sql472026-10-27 10:47:45 [INFO] Running pgtap test: vault.sql482026-10-27 10:47:46 [INFO] Running pgtap test: wal2json.sql492026-10-27 10:47:46 [INFO] Running pgtap test: z_17_intarray_ltree_query.sql502026-10-27 10:47:46 [INFO] Running pgtap test: z_17_wal_summarize.sql512026-10-27 10:47:46 [INFO] Starting PostgreSQL server for pg_regress tests522026-10-27 10:47:51 [INFO] PostgreSQL is ready532026-10-27 10:47:51 [INFO] CLI variant detected - loading CLI prime SQL file542026-10-27 10:47:51 [INFO] Creating test_config table for pg_regress tests552026-10-27 10:47:51 [INFO] CLI variant detected - running subset of pg_regress tests (38 tests)562026-10-27 10:47:53 [ERROR] pg_regress tests failed57diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/auth.out /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/auth.out58--- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/auth.out 1970-01-01 00:00:01.000000000 +000059+++ /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/auth.out 2026-10-27 10:47:51.663531092 +000060@@ -1,3 +1,5 @@61+WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it62+DETAIL: "supautils" is now a reserved prefix.63 -- auth schema owner64 select65 n.nspname as schema_name,66diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/create_statistics_priv.out /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/create_statistics_priv.out67--- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/create_statistics_priv.out 1970-01-01 00:00:01.000000000 +000068+++ /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/create_statistics_priv.out 2026-10-27 10:47:51.682531147 +000069@@ -1,3 +1,5 @@70+WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it71+DETAIL: "supautils" is now a reserved prefix.72 -- CVE-2025-12817: CREATE STATISTICS did not check CREATE privilege on the73 -- schema where the statistics object is created, letting a table owner create74 -- statistics objects in any schema (naming-conflict / privilege concern).75diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/dblink.out /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/dblink.out76--- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/dblink.out 1970-01-01 00:00:01.000000000 +000077+++ /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/dblink.out 2026-10-27 10:47:51.734531298 +000078@@ -1,3 +1,5 @@79+WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it80+DETAIL: "supautils" is now a reserved prefix.81 -- The following test verifies that creating pg_proc in pg_temp doesn't shadow82 -- the real catalog table tricking the dblink/after-create.sql script to skip83 -- revoking the grants from all roles except supabase_admin, which would have84diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-array-test.out /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/docs-array-test.out85--- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-array-test.out 1970-01-01 00:00:01.000000000 +000086+++ /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/docs-array-test.out 2026-10-27 10:47:51.768531397 +000087@@ -1,3 +1,5 @@88+WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it89+DETAIL: "supautils" is now a reserved prefix.90 -- testing sql found in https://supabase.com/docs/guides/database/arrays91 create table arraytest (92 id integer not null,93diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-cascades-deletes.out /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/docs-cascades-deletes.out94--- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-cascades-deletes.out 1970-01-01 00:00:01.000000000 +000095+++ /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/docs-cascades-deletes.out 2026-10-27 10:47:51.921531842 +000096@@ -1,3 +1,5 @@97+WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it98+DETAIL: "supautils" is now a reserved prefix.99 -- testing sql found in https://supabase.com/docs/guides/database/postgres/cascades-deletes100 -- all of the errors produced by this file are expected101 create table grandparent (102diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-connections.out /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/docs-connections.out103--- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-connections.out 1970-01-01 00:00:01.000000000 +0000104+++ /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/docs-connections.out 2026-10-27 10:47:51.939531895 +0000105@@ -1,3 +1,5 @@106+WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it107+DETAIL: "supautils" is now a reserved prefix.108 -- testing sql found in https://supabase.com/docs/guides/database/connection-management109 -- we can't test every sql statement in this doc because their results won't be deterministic110 select111diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-enums.out /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/docs-enums.out112--- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-enums.out 1970-01-01 00:00:01.000000000 +0000113+++ /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/docs-enums.out 2026-10-27 10:47:52.004532084 +0000114@@ -1,3 +1,5 @@115+WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it116+DETAIL: "supautils" is now a reserved prefix.117 -- testing sql found in https://supabase.com/docs/guides/database/postgresenums118 create type mood as enum (119 'happy',120diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-full-text-search.out /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/docs-full-text-search.out121--- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-full-text-search.out 1970-01-01 00:00:01.000000000 +0000122+++ /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/docs-full-text-search.out 2026-10-27 10:47:52.050532218 +0000123@@ -1,3 +1,5 @@124+WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it125+DETAIL: "supautils" is now a reserved prefix.126 -- testing sql found in https://supabase.com/docs/guides/database/full-text-search127 create table books (128 id serial primary key,129diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-functions.out /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/docs-functions.out130--- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-functions.out 1970-01-01 00:00:01.000000000 +0000131+++ /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/docs-functions.out 2026-10-27 10:47:52.148532503 +0000132@@ -1,3 +1,5 @@133+WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it134+DETAIL: "supautils" is now a reserved prefix.135 -- testing sql found in https://supabase.com/docs/guides/database/functions136 create or replace function hello_world()137 returns text138diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-indexes.out /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/docs-indexes.out139--- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-indexes.out 1970-01-01 00:00:01.000000000 +0000140+++ /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/docs-indexes.out 2026-10-27 10:47:52.201532657 +0000141@@ -1,3 +1,5 @@142+WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it143+DETAIL: "supautils" is now a reserved prefix.144 -- testing sql found in https://supabase.com/docs/guides/database/indexes145 create table persons (146 id bigint generated by default as identity primary key,147diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-json.out /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/docs-json.out148--- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-json.out 1970-01-01 00:00:01.000000000 +0000149+++ /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/docs-json.out 2026-10-27 10:47:52.224532724 +0000150@@ -1,3 +1,5 @@151+WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it152+DETAIL: "supautils" is now a reserved prefix.153 -- testing sql found in https://supabase.com/docs/guides/database/json154 create table books (155 id serial primary key,156diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-partitioning.out /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/docs-partitioning.out157--- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-partitioning.out 1970-01-01 00:00:01.000000000 +0000158+++ /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/docs-partitioning.out 2026-10-27 10:47:52.280532887 +0000159@@ -1,3 +1,5 @@160+WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it161+DETAIL: "supautils" is now a reserved prefix.162 -- testing sql found in https://supabase.com/docs/guides/database/partitioning163 create table sales (164 id bigint generated by default as identity,165diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-tables-and-data.out /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/docs-tables-and-data.out166--- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-tables-and-data.out 1970-01-01 00:00:01.000000000 +0000167+++ /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/docs-tables-and-data.out 2026-10-27 10:47:52.466533428 +0000168@@ -1,3 +1,5 @@169+WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it170+DETAIL: "supautils" is now a reserved prefix.171 -- Test file for "Tables and Data" documentation172 -- This file contains all SQL statements from https://supabase.com/docs/guides/database/tables-and-data173 create table movies (174diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-triggers.out /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/docs-triggers.out175--- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-triggers.out 1970-01-01 00:00:01.000000000 +0000176+++ /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/docs-triggers.out 2026-10-27 10:47:52.592533794 +0000177@@ -1,3 +1,5 @@178+WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it179+DETAIL: "supautils" is now a reserved prefix.180 -- testing sql found in https://supabase.com/docs/guides/database/postgres/triggers181 create table employees (182 id serial primary key,183diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-webhooks.out /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/docs-webhooks.out184--- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-webhooks.out 1970-01-01 00:00:01.000000000 +0000185+++ /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/docs-webhooks.out 2026-10-27 10:47:52.687534071 +0000186@@ -1,3 +1,5 @@187+WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it188+DETAIL: "supautils" is now a reserved prefix.189 -- testing sql found in https://supabase.com/docs/guides/database/webhooks190 create table profiles (191 id serial primary key,192diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/enable_tracking.out /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/enable_tracking.out193--- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/enable_tracking.out 1970-01-01 00:00:01.000000000 +0000194+++ /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/enable_tracking.out 2026-10-27 10:47:52.702534114 +0000195@@ -1,3 +1,5 @@196+WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it197+DETAIL: "supautils" is now a reserved prefix.198 alter role postgres set track_functions = 'pl';199 alter role postgres set track_io_timing = on;200 alter role postgres reset track_functions;201diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/event_trigger_search_path.out /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/event_trigger_search_path.out202--- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/event_trigger_search_path.out 1970-01-01 00:00:01.000000000 +0000203+++ /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/event_trigger_search_path.out 2026-10-27 10:47:52.716534155 +0000204@@ -1,3 +1,5 @@205+WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it206+DETAIL: "supautils" is now a reserved prefix.207 -- Regression test: every Supabase-owned event trigger function must pin search_path.208 --209 -- Event triggers fire as superuser on DDL run by any role, so an event trigger function210diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/intarray_ltree_query.out /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/intarray_ltree_query.out211--- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/intarray_ltree_query.out 1970-01-01 00:00:01.000000000 +0000212+++ /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/intarray_ltree_query.out 2026-10-27 10:47:52.829534484 +0000213@@ -1,3 +1,5 @@214+WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it215+DETAIL: "supautils" is now a reserved prefix.216 -- CVE-2026-6473217 -- 218 -- Overflow of the internal "left" / length / variant-count fields used219diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/ltree_label_overflow.out /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/ltree_label_overflow.out220--- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/ltree_label_overflow.out 1970-01-01 00:00:01.000000000 +0000221+++ /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/ltree_label_overflow.out 2026-10-27 10:47:52.901534693 +0000222@@ -1,3 +1,5 @@223+WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it224+DETAIL: "supautils" is now a reserved prefix.225 -- contrib/ltree: an integer overflow in ltree_compare() made comparisons return226 -- the wrong sign once two values differed in depth by more than ~14,653 labels.227 -- A btree index over such values could therefore be built in the wrong order and228diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/multirange_create_priv.out /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/multirange_create_priv.out229--- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/multirange_create_priv.out 1970-01-01 00:00:01.000000000 +0000230+++ /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/multirange_create_priv.out 2026-10-27 10:47:52.919534745 +0000231@@ -1,3 +1,5 @@232+WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it233+DETAIL: "supautils" is now a reserved prefix.234 -- CVE-2026-6472: CREATE TYPE ... AS RANGE auto-creates a companion multirange235 -- type. When the multirange type name was given EXPLICITLY, the schema CREATE236 -- privilege for that name was not validated (the auto-generated-name path was237diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/operator_breaking_change.out /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/operator_breaking_change.out238--- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/operator_breaking_change.out 1970-01-01 00:00:01.000000000 +0000239+++ /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/operator_breaking_change.out 2026-10-27 10:47:52.966534882 +0000240@@ -1,3 +1,5 @@241+WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it242+DETAIL: "supautils" is now a reserved prefix.243 -- Pin CVE-2026-2004 behaviour: attaching a non-built-in selectivity estimator244 -- to an operator requires superuser. Verified against both RESTRICT and JOIN.245 --246diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/pg-safeupdate.out /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/pg-safeupdate.out247--- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/pg-safeupdate.out 1970-01-01 00:00:01.000000000 +0000248+++ /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/pg-safeupdate.out 2026-10-27 10:47:52.987534943 +0000249@@ -1,3 +1,5 @@250+WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it251+DETAIL: "supautils" is now a reserved prefix.252 load 'safeupdate';253 set safeupdate.enabled=1;254 create schema v;255diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/pg_graphql.out /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/pg_graphql.out256--- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/pg_graphql.out 1970-01-01 00:00:01.000000000 +0000257+++ /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/pg_graphql.out 2026-10-27 10:47:53.078535208 +0000258@@ -1,3 +1,5 @@259+WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it260+DETAIL: "supautils" is now a reserved prefix.261 begin;262 comment on schema public is '@graphql({"inflect_names": true})';263 create table account(264diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/pg_net.out /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/pg_net.out265--- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/pg_net.out 1970-01-01 00:00:01.000000000 +0000266+++ /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/pg_net.out 2026-10-27 10:47:53.095535257 +0000267@@ -1,3 +1,5 @@268+WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it269+DETAIL: "supautils" is now a reserved prefix.270 -- This is a very basic test because you can't get the value returned271 -- by a pg_net request in the same transaction that created it;272 select273diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/pg_plan_filter.out /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/pg_plan_filter.out274--- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/pg_plan_filter.out 1970-01-01 00:00:01.000000000 +0000275+++ /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/pg_plan_filter.out 2026-10-27 10:47:53.113535310 +0000276@@ -1,3 +1,5 @@277+WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it278+DETAIL: "supautils" is now a reserved prefix.279 begin;280 load 'plan_filter';281 create schema v;282diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/pgaudit.out /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/pgaudit.out283--- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/pgaudit.out 1970-01-01 00:00:01.000000000 +0000284+++ /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/pgaudit.out 2026-10-27 10:47:53.442536267 +0000285@@ -1,3 +1,5 @@286+WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it287+DETAIL: "supautils" is now a reserved prefix.288 -- Note: there is no test that the logs were correctly output. Only checking for exceptions289 set pgaudit.log = 'write, ddl';290 set pgaudit.log_relation = on;291diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/pgbouncer.out /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/pgbouncer.out292--- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/pgbouncer.out 1970-01-01 00:00:01.000000000 +0000293+++ /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/pgbouncer.out 2026-10-27 10:47:53.480536377 +0000294@@ -1,3 +1,5 @@295+WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it296+DETAIL: "supautils" is now a reserved prefix.297 -- pgbouncer schema owner298 select299 n.nspname as schema_name,300diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/pgcrypto_cipher_matrix.out /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/pgcrypto_cipher_matrix.out301--- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/pgcrypto_cipher_matrix.out 1970-01-01 00:00:01.000000000 +0000302+++ /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/pgcrypto_cipher_matrix.out 2026-10-27 10:47:53.515536479 +0000303@@ -1,3 +1,5 @@304+WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it305+DETAIL: "supautils" is now a reserved prefix.306 -- CVE-2026-14663: pgcrypto's PGP functions previously did not detect when the307 -- requested cipher was unavailable in the server's OpenSSL build. Encryption308 -- then silently produced output that was not actually encrypted, and decryption309diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/pgsodium.out /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/pgsodium.out310--- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/pgsodium.out 1970-01-01 00:00:01.000000000 +0000311+++ /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/pgsodium.out 2026-10-27 10:47:53.534536534 +0000312@@ -1,3 +1,5 @@313+WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it314+DETAIL: "supautils" is now a reserved prefix.315 select316 status317 from318diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/realtime.out /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/realtime.out319--- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/realtime.out 1970-01-01 00:00:01.000000000 +0000320+++ /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/realtime.out 2026-10-27 10:47:53.547536572 +0000321@@ -1,3 +1,5 @@322+WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it323+DETAIL: "supautils" is now a reserved prefix.324 -- only a publication from supabase realtime is expected325 SELECT326 pubname AS publication_name,327diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/replica_identity_upsert.out /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/replica_identity_upsert.out328--- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/replica_identity_upsert.out 1970-01-01 00:00:01.000000000 +0000329+++ /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/replica_identity_upsert.out 2026-10-27 10:47:53.567536630 +0000330@@ -1,3 +1,5 @@331+WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it332+DETAIL: "supautils" is now a reserved prefix.333 -- 17.7/15.15 tightened logical-replication checks: MERGE and334 -- INSERT ... ON CONFLICT DO UPDATE now also require a REPLICA IDENTITY when the335 -- target table is in a publication that publishes updates (previously these two336diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/storage.out /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/storage.out337--- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/storage.out 1970-01-01 00:00:01.000000000 +0000338+++ /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/storage.out 2026-10-27 10:47:53.598536720 +0000339@@ -1,3 +1,5 @@340+WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it341+DETAIL: "supautils" is now a reserved prefix.342 -- storage schema owner343 select344 n.nspname as schema_name,345diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/supautils_reserved_roles.out /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/supautils_reserved_roles.out346--- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/supautils_reserved_roles.out 1970-01-01 00:00:01.000000000 +0000347+++ /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/supautils_reserved_roles.out 2026-10-27 10:47:53.612536761 +0000348@@ -1,3 +1,5 @@349+WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it350+DETAIL: "supautils" is now a reserved prefix.351 -- verify non-superuser postgres role cannot drop supabase_privileged_role352 BEGIN;353 -- Switch to the postgres role (non-superuser) to test supautils behavior354diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/supautils_warehouse_writer.out /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/supautils_warehouse_writer.out355--- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/supautils_warehouse_writer.out 1970-01-01 00:00:01.000000000 +0000356+++ /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/supautils_warehouse_writer.out 2026-10-27 10:47:53.631536816 +0000357@@ -1,10 +1,12 @@358+WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it359+DETAIL: "supautils" is now a reserved prefix.360 BEGIN;361 SELECT count(*) = 1 AS protection_registered362 FROM pg_settings363 WHERE name = 'supautils.reserved_role_members' AND context = 'sighup';364 protection_registered 365 -----------------------366- t367+ f368 (1 row)369 370 CREATE ROLE supabase_warehouse_writer NOLOGIN;371@@ -14,11 +16,13 @@372 SET ROLE postgres;373 SAVEPOINT denied;374 GRANT supabase_warehouse_writer_test TO postgres;375-ERROR: "supabase_warehouse_writer_test" role memberships are reserved, only superusers can grant them376+ERROR: permission denied to grant role "supabase_warehouse_writer_test"377+DETAIL: Only roles with the ADMIN option on role "supabase_warehouse_writer_test" may grant this role.378 ROLLBACK TO SAVEPOINT denied;379 SAVEPOINT denied;380 GRANT warehouse_writer_test_login TO postgres;381-ERROR: "warehouse_writer_test_login" role memberships are reserved, only superusers can grant them382+ERROR: permission denied to grant role "warehouse_writer_test_login"383+DETAIL: Only roles with the ADMIN option on role "warehouse_writer_test_login" may grant this role.384 ROLLBACK TO SAVEPOINT denied;385 SAVEPOINT denied;386 GRANT pg_write_all_data TO postgres;387@@ -30,23 +34,26 @@388 ROLLBACK TO SAVEPOINT denied;389 SAVEPOINT denied;390 ALTER ROLE supabase_warehouse_writer_test LOGIN;391-ERROR: "supabase_warehouse_writer_test" is a reserved role, only superusers can modify it392 ROLLBACK TO SAVEPOINT denied;393 SAVEPOINT denied;394 COMMENT ON ROLE supabase_warehouse_writer_test IS 'forged';395-ERROR: "supabase_warehouse_writer_test" is a reserved role, only superusers can modify it396+ERROR: permission denied397+DETAIL: The current user must have the ADMIN option on role "supabase_warehouse_writer_test".398 ROLLBACK TO SAVEPOINT denied;399 SAVEPOINT denied;400 DROP ROLE supabase_warehouse_writer_test;401-ERROR: "supabase_warehouse_writer_test" is a reserved role, only superusers can modify it402+ERROR: permission denied to drop role403+DETAIL: Only roles with the CREATEROLE attribute and the ADMIN option on role "supabase_warehouse_writer_test" may drop this role.404 ROLLBACK TO SAVEPOINT denied;405 SAVEPOINT denied;406 REVOKE supabase_warehouse_writer_test FROM warehouse_writer_test_login;407-ERROR: "supabase_warehouse_writer_test" role memberships are reserved, only superusers can grant them408+ERROR: permission denied to revoke role "supabase_warehouse_writer_test"409+DETAIL: Only roles with the ADMIN option on role "supabase_warehouse_writer_test" may revoke this role.410 ROLLBACK TO SAVEPOINT denied;411 SAVEPOINT denied;412 REVOKE supabase_warehouse_writer FROM supabase_warehouse_writer_test;413-ERROR: "supabase_warehouse_writer" role memberships are reserved, only superusers can grant them414+ERROR: permission denied to revoke role "supabase_warehouse_writer"415+DETAIL: Only roles with the ADMIN option on role "supabase_warehouse_writer" may revoke this role.416 ROLLBACK TO SAVEPOINT denied;417 RESET ROLE;418 REVOKE supabase_warehouse_writer_test FROM warehouse_writer_test_login;419diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/vault.out /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/vault.out420--- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/vault.out 1970-01-01 00:00:01.000000000 +0000421+++ /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/vault.out 2026-10-27 10:47:53.693536997 +0000422@@ -1,3 +1,5 @@423+WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it424+DETAIL: "supautils" is now a reserved prefix.425 -- Tests role privileges on the vault objects426 -- INSERT and UPDATE privileges should not be present on the vault tables for postgres and service_role, only SELECT and DELETE427 WITH schema_obj AS (428diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/wal2json.out /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/wal2json.out429--- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/wal2json.out 1970-01-01 00:00:01.000000000 +0000430+++ /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/wal2json.out 2026-10-27 10:47:53.754537174 +0000431@@ -1,3 +1,5 @@432+WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it433+DETAIL: "supautils" is now a reserved prefix.434 create schema v;435 create table v.foo(436 id int primary key437diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/z_17_intarray_ltree_query.out /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/z_17_intarray_ltree_query.out438--- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/z_17_intarray_ltree_query.out 1970-01-01 00:00:01.000000000 +0000439+++ /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/z_17_intarray_ltree_query.out 2026-10-27 10:47:53.830537395 +0000440@@ -1,3 +1,5 @@441+WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it442+DETAIL: "supautils" is now a reserved prefix.443 BEGIN;444 SET client_min_messages = warning; -- cli does not have ltree so does not show the already exists notice445 CREATE EXTENSION IF NOT EXISTS ltree;446diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/z_17_wal_summarize.out /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/z_17_wal_summarize.out447--- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/z_17_wal_summarize.out 1970-01-01 00:00:01.000000000 +0000448+++ /nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/results/z_17_wal_summarize.out 2026-10-27 10:47:53.845537439 +0000449@@ -1,3 +1,5 @@450+WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it451+DETAIL: "supautils" is now a reserved prefix.452 SELECT (SELECT setting FROM pg_settings WHERE name = 'summarize_wal') = 'on' AS summarize_wal_default_ok;453 summarize_wal_default_ok 454 --------------------------4552026-10-27 10:47:53 [ERROR] An error occurred. Exit code: 14562026-10-27 10:47:53 [ERROR] Debug logs:4572026-10-27 10:47:40 [INFO] Starting HTTP mock server (will find free port)...458$ /nix/store/y88crn50yx35fiiwcjx6xqwi6ahk7mlq-python3-3.13.11/bin/python3 /nix/store/sfl1mnhcw0ccky7m2crn0hda79clq4mk-http-mock-server.py4592026-10-27 10:47:41 [INFO] HTTP mock server started on port 88804602026-10-27 10:47:41 [INFO] Creating temporary PostgreSQL cluster at /build/tmp.OtiT8d8AMV461$ initdb --locale=C --username=supabase_admin -D /build/tmp.OtiT8d8AMV462The files belonging to this database system will be owned by user "nixbld".463This user must also own the server process.464465The database cluster will be initialized with locale "C".466The default database encoding has accordingly been set to "SQL_ASCII".467The default text search configuration will be set to "english".468469Data page checksums are disabled.470471fixing permissions on existing directory /build/tmp.OtiT8d8AMV ... ok472creating subdirectories ... ok473selecting dynamic shared memory implementation ... posix474selecting default "max_connections" ... 100475selecting default "shared_buffers" ... 128MB476selecting default time zone ... UTC477creating configuration files ... ok478running bootstrap script ... ok479performing post-bootstrap initialization ... ok480syncing data to disk ... ok481482initdb: warning: enabling "trust" authentication for local connections483initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.484485Success. You can now start the database server using:486487 pg_ctl -D /build/tmp.OtiT8d8AMV -l logfile start4884892026-10-27 10:47:42 [INFO] Generated preload libraries: pg_cron, pg_net, pgsodium, supabase_vault4902026-10-27 10:47:42 [INFO] Checking shared_preload_libraries setting:4912026-10-27 10:47:42 [INFO] 721:shared_preload_libraries = 'pg_cron, pg_net, pgsodium, supabase_vault' # (change requires restart)4922026-10-27 10:47:42 [INFO] Configuring local auth493$ pg_ctl -D /build/tmp.OtiT8d8AMV -l /build/tmp.OtiT8d8AMV/postgresql.log -o -k /build/tmp.OtiT8d8AMV/sockets -p 5541 -d 5 start494waiting for server to start.... done495server started4962026-10-27 10:47:42 [INFO] Waiting for PostgreSQL to be ready...497$ pg_isready -h localhost -p 5541 -U supabase_admin -q4982026-10-27 10:47:42 [INFO] PostgreSQL is ready4992026-10-27 10:47:42 [INFO] Creating test database500$ createdb -p 5541 -h localhost --username=supabase_admin testing5012026-10-27 10:47:42 [INFO] CLI variant detected - loading CLI prime SQL file502$ psql -p 5541 -h localhost --username=supabase_admin -d testing -v ON_ERROR_STOP=1 -Xf /nix/store/ib75j74vyc0w374jcz7mqcg6njf21yx3-prime-cli.sql503SET504CREATE EXTENSION505CREATE EXTENSION506CREATE EXTENSION507CREATE EXTENSION5082026-10-27 10:47:43 [INFO] Creating test_config table509$ psql -p 5541 -h localhost --username=supabase_admin -d testing -c 510 CREATE TABLE IF NOT EXISTS test_config (key TEXT PRIMARY KEY, value TEXT);511 INSERT INTO test_config (key, value) VALUES ('http_mock_port', '8880')512 ON CONFLICT (key) DO UPDATE SET value = EXCLUDED.value;513 INSERT INTO test_config (key, value) VALUES ('http_mock_host', 'localhost')514 ON CONFLICT (key) DO UPDATE SET value = EXCLUDED.value;515516CREATE TABLE517INSERT 0 1518INSERT 0 15192026-10-27 10:47:43 [INFO] Running pgtap test: auth.sql520$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/auth.sql521 schema_name | owner 522-------------+-------523(0 rows)524525 schema_name | table_name | owner | rls_enabled | rls_policies 526-------------+------------+-------+-------------+--------------527(0 rows)528529 schema_name | table_name | role_name | privilege_type | is_grantable 530-------------+------------+-----------+----------------+--------------531(0 rows)532533 table_schema | table_name | index_name | index_owner 534--------------+------------+------------+-------------535(0 rows)536537 schema_name | function_name | owner 538-------------+---------------+-------539(0 rows)540541psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/auth.sql:97: ERROR: relation "auth.schema_migrations" does not exist542LINE 1: select * from auth.schema_migrations;543 ^5442026-10-27 10:47:43 [INFO] Running pgtap test: create_statistics_priv.sql545$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/create_statistics_priv.sql546BEGIN547CREATE SCHEMA548CREATE SCHEMA549psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/create_statistics_priv.sql:15: ERROR: role "postgres" does not exist550psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/create_statistics_priv.sql:17: ERROR: current transaction is aborted, commands ignored until end of transaction block551psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/create_statistics_priv.sql:20: ERROR: current transaction is aborted, commands ignored until end of transaction block552psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/create_statistics_priv.sql:21: ERROR: current transaction is aborted, commands ignored until end of transaction block553psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/create_statistics_priv.sql:24: ERROR: current transaction is aborted, commands ignored until end of transaction block554psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/create_statistics_priv.sql:27: ERROR: current transaction is aborted, commands ignored until end of transaction block555psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/create_statistics_priv.sql:28: ERROR: current transaction is aborted, commands ignored until end of transaction block556psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/create_statistics_priv.sql:29: ERROR: savepoint "no_priv" does not exist557psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/create_statistics_priv.sql:31: ERROR: current transaction is aborted, commands ignored until end of transaction block558ROLLBACK5592026-10-27 10:47:43 [INFO] Running pgtap test: dblink.sql560$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/dblink.sql561SET562DROP EXTENSION563psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/dblink.sql:10: ERROR: role "postgres" does not exist564CREATE TABLE565CREATE EXTENSION566DROP TABLE567RESET568 function_name | grantee | privilege_type 569-----------------------------+----------------+----------------570 dblink_connect_u(text) | supabase_admin | EXECUTE571 dblink_connect_u(text,text) | supabase_admin | EXECUTE572(2 rows)573574psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/dblink.sql:28: ERROR: role "postgres" does not exist575 search_path 576-----------------577 "$user", public578(1 row)579580DROP EXTENSION581CREATE EXTENSION5822026-10-27 10:47:43 [INFO] Running pgtap test: docs-array-test.sql583$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-array-test.sql584CREATE TABLE585INSERT 0 1586 id | textarray 587----+-------------------588 1 | {Harry,Larry,Moe}589(1 row)590591 textarray | array_length 592-----------+--------------593 Harry | 3594(1 row)595596DROP TABLE5972026-10-27 10:47:43 [INFO] Running pgtap test: docs-cascades-deletes.sql598$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-cascades-deletes.sql599CREATE TABLE600CREATE TABLE601CREATE TABLE602INSERT 0 1603INSERT 0 1604INSERT 0 1605INSERT 0 1606 count 607-------608 1609(1 row)610611 count 612-------613 2614(1 row)615616 count 617-------618 1619(1 row)620621psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-cascades-deletes.sql:47: ERROR: update or delete on table "parent" violates foreign key constraint "child_father_fkey" on table "child"622DETAIL: Key (id)=(1) is still referenced from table "child".623 count 624-------625 1626(1 row)627628 count 629-------630 2631(1 row)632633 count 634-------635 1636(1 row)637638psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-cascades-deletes.sql:56: ERROR: duplicate key value violates unique constraint "grandparent_pkey"639DETAIL: Key (id)=(1) already exists.640psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-cascades-deletes.sql:61: ERROR: duplicate key value violates unique constraint "parent_pkey"641DETAIL: Key (id)=(1) already exists.642psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-cascades-deletes.sql:66: ERROR: duplicate key value violates unique constraint "parent_pkey"643DETAIL: Key (id)=(2) already exists.644psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-cascades-deletes.sql:71: ERROR: duplicate key value violates unique constraint "child_pkey"645DETAIL: Key (id)=(1) already exists.646ALTER TABLE647ALTER TABLE648psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-cascades-deletes.sql:80: ERROR: update or delete on table "parent" violates foreign key constraint "child_father_fkey" on table "child"649DETAIL: Key (id)=(1) is still referenced from table "child".650 count 651-------652 1653(1 row)654655 count 656-------657 2658(1 row)659660 count 661-------662 1663(1 row)664665psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-cascades-deletes.sql:89: ERROR: duplicate key value violates unique constraint "grandparent_pkey"666DETAIL: Key (id)=(1) already exists.667psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-cascades-deletes.sql:94: ERROR: duplicate key value violates unique constraint "parent_pkey"668DETAIL: Key (id)=(1) already exists.669psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-cascades-deletes.sql:99: ERROR: duplicate key value violates unique constraint "parent_pkey"670DETAIL: Key (id)=(2) already exists.671psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-cascades-deletes.sql:104: ERROR: duplicate key value violates unique constraint "child_pkey"672DETAIL: Key (id)=(1) already exists.673ALTER TABLE674ALTER TABLE675psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-cascades-deletes.sql:113: ERROR: update or delete on table "parent" violates foreign key constraint "child_father_fkey" on table "child"676DETAIL: Key (id)=(1) is still referenced from table "child".677 count 678-------679 1680(1 row)681682 count 683-------684 2685(1 row)686687 count 688-------689 1690(1 row)691692psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-cascades-deletes.sql:122: ERROR: duplicate key value violates unique constraint "grandparent_pkey"693DETAIL: Key (id)=(1) already exists.694psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-cascades-deletes.sql:127: ERROR: duplicate key value violates unique constraint "parent_pkey"695DETAIL: Key (id)=(1) already exists.696psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-cascades-deletes.sql:132: ERROR: duplicate key value violates unique constraint "parent_pkey"697DETAIL: Key (id)=(2) already exists.698psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-cascades-deletes.sql:137: ERROR: duplicate key value violates unique constraint "child_pkey"699DETAIL: Key (id)=(1) already exists.700ALTER TABLE701UPDATE 1702DELETE 1703 count 704-------705 0706(1 row)707708 count 709-------710 0711(1 row)712713 count 714-------715 0716(1 row)717718CREATE TABLE719CREATE TABLE720INSERT 0 1721INSERT 0 1722DELETE 1723 count 724-------725 0726(1 row)727728 count 729-------730 0731(1 row)732733CREATE TABLE734CREATE TABLE735INSERT 0 1736INSERT 0 1737psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-cascades-deletes.sql:186: ERROR: update or delete on table "test_restrict" violates foreign key constraint "test_restrict_child_parent_id_fkey" on table "test_restrict_child"738DETAIL: Key (id)=(1) is still referenced from table "test_restrict_child".739 count 740-------741 1742(1 row)743744 count 745-------746 1747(1 row)748749CREATE TABLE750CREATE TABLE751INSERT 0 1752INSERT 0 1753DELETE 1754 count 755-------756 0757(1 row)758759 count 760-------761 1762(1 row)763764 parent_id 765-----------766 767(1 row)768769CREATE TABLE770CREATE TABLE771INSERT 0 1772INSERT 0 1773psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-cascades-deletes.sql:225: ERROR: insert or update on table "test_set_default_child" violates foreign key constraint "test_set_default_child_parent_id_fkey"774DETAIL: Key (parent_id)=(999) is not present in table "test_set_default".775 count 776-------777 1778(1 row)779780 count 781-------782 1783(1 row)784785 parent_id 786-----------787 1788(1 row)789790CREATE TABLE791CREATE TABLE792INSERT 0 1793INSERT 0 1794psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-cascades-deletes.sql:245: ERROR: update or delete on table "test_no_action" violates foreign key constraint "test_no_action_child_parent_id_fkey" on table "test_no_action_child"795DETAIL: Key (id)=(1) is still referenced from table "test_no_action_child".796 count 797-------798 1799(1 row)800801 count 802-------803 1804(1 row)805806DROP TABLE807DROP TABLE808DROP TABLE809DROP TABLE810DROP TABLE811DROP TABLE812DROP TABLE813DROP TABLE814DROP TABLE815DROP TABLE816DROP TABLE817DROP TABLE818DROP TABLE8192026-10-27 10:47:43 [INFO] Running pgtap test: docs-connections.sql820$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-connections.sql821 ssl | database | connected_role | application_name | query | state 822-----+----------+----------------+------------------+--------------------------------------------+--------823 f | testing | supabase_admin | psql | select +| active824 | | | | ssl, +| 825 | | | | datname as database, +| 826 | | | | usename as connected_role, +| 827 | | | | application_name, +| 828 | | | | query, +| 829 | | | | state +| 830 | | | | from pg_stat_ssl +| 831 | | | | join pg_stat_activity +| 832 | | | | on pg_stat_ssl.pid = pg_stat_activity.pid; | 833(1 row)8348352026-10-27 10:47:43 [INFO] Running pgtap test: docs-enums.sql836$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-enums.sql837CREATE TYPE838CREATE TABLE839INSERT 0 1840INSERT 0 1841INSERT 0 1842 id | name | current_mood 843----+------+--------------844 2 | Bob | sad845(1 row)846847 id | name | current_mood 848----+-------+--------------849 1 | Alice | happy850(1 row)851852UPDATE 1853 id | name | current_mood 854----+-------+--------------855 1 | Alice | excited856(1 row)857858ALTER TYPE859INSERT 0 1860 enum_range 861----------------------------------862 {happy,sad,excited,calm,content}863(1 row)864865 id | name | current_mood 866----+-------+--------------867 4 | David | content868(1 row)869870CREATE TYPE871CREATE TABLE872INSERT 0 3873 id | order_number | status 874----+--------------+--------875 1 | ORD-001 | active876(1 row)877878UPDATE 1879 id | order_number | status 880----+--------------+----------881 2 | ORD-002 | inactive882(1 row)883884ALTER TYPE885INSERT 0 1886 enum_range 887-------------------------------------888 {active,inactive,pending,cancelled}889(1 row)890891 id | order_number | status 892----+--------------+-----------893 4 | ORD-004 | cancelled894(1 row)895896CREATE TYPE897CREATE TABLE898INSERT 0 3899 id | title | priority 900----+----------------+----------901 3 | Security audit | critical902(1 row)903904UPDATE 1905 id | title | priority 906----+-------------+----------907 2 | Update docs | medium908(1 row)909910ALTER TYPE911INSERT 0 1912 enum_range 913-----------------------------------914 {low,medium,high,critical,urgent}915(1 row)916917 id | title | priority 918----+--------------------+----------919 4 | Server maintenance | urgent920(1 row)921922DROP TABLE923DROP TABLE924DROP TABLE925DROP TYPE926DROP TYPE927DROP TYPE9282026-10-27 10:47:43 [INFO] Running pgtap test: docs-full-text-search.sql929$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-full-text-search.sql930CREATE TABLE931INSERT 0 5932 to_tsvector 933---------------------------934 'egg':2 'green':1 'ham':4935(1 row)936937 to_tsvector 938---------------------------939 'egg':2 'green':1 'ham':4940(1 row)941942 id | title | author | description 943----+-------+--------+-------------944(0 rows)945946 id | title | author | description 947----+-------------------------------------+--------------+-------------------------------------------------948 5 | Harry Potter and the Goblet of Fire | J.K. Rowling | Fourth year of school starts, big drama ensues.949(1 row)950951 id | title | author | description 952----+-------------------------------------+-------------------+-------------------------------------------------953 3 | Tootle | Gertrude Crampton | Little toy train has big dreams.954 5 | Harry Potter and the Goblet of Fire | J.K. Rowling | Fourth year of school starts, big drama ensues.955(2 rows)956957 id | title | author | description 958----+-----------------------+------------------------+---------------------------------------------959 1 | The Poky Little Puppy | Janette Sebring Lowrey | Puppy is slower than other, bigger animals.960 3 | Tootle | Gertrude Crampton | Little toy train has big dreams.961(2 rows)962963CREATE FUNCTION964 id | title | author | description 965----+-----------------------+------------------------+---------------------------------------------966 1 | The Poky Little Puppy | Janette Sebring Lowrey | Puppy is slower than other, bigger animals.967 3 | Tootle | Gertrude Crampton | Little toy train has big dreams.968(2 rows)969970 id | title | author | description 971----+--------+-------------------+----------------------------------972 3 | Tootle | Gertrude Crampton | Little toy train has big dreams.973(1 row)974975 id | title | author | description 976----+-------------------------------------+-------------------+-------------------------------------------------977 3 | Tootle | Gertrude Crampton | Little toy train has big dreams.978 5 | Harry Potter and the Goblet of Fire | J.K. Rowling | Fourth year of school starts, big drama ensues.979(2 rows)980981 title 982-----------------------983 The Poky Little Puppy984(1 row)985986CREATE FUNCTION987 id | title | author | description 988----+-----------------------+------------------------+---------------------------------------------989 1 | The Poky Little Puppy | Janette Sebring Lowrey | Puppy is slower than other, bigger animals.990(1 row)991992 id | title | author | description 993----+-----------------------+------------------------+---------------------------------------------994 1 | The Poky Little Puppy | Janette Sebring Lowrey | Puppy is slower than other, bigger animals.995(1 row)996997ALTER TABLE998CREATE INDEX999 id | fts 1000----+-----------------------------------------------------------------------------------------------------------------1001 1 | 'anim':7 'bigger':6 'littl':10 'poki':9 'puppi':1,11 'slower':31002 2 | 'eat':2 'peter':8 'rabbit':1,9 'tale':6 'veget':41003 3 | 'big':5 'dream':6 'littl':1 'tootl':7 'toy':2 'train':31004 4 | 'chang':3 'color':9 'eat':7 'egg':12 'food':4,10 'green':11 'ham':14 'prefer':5 'sam':1 'unusu':81005 5 | 'big':6 'drama':7 'ensu':8 'fire':15 'fourth':1 'goblet':13 'harri':9 'potter':10 'school':4 'start':5 'year':21006(5 rows)10071008 id | title | author | description | fts 1009----+--------+-------------------+----------------------------------+---------------------------------------------------------1010 3 | Tootle | Gertrude Crampton | Little toy train has big dreams. | 'big':5 'dream':6 'littl':1 'tootl':7 'toy':2 'train':31011(1 row)10121013 id | title | author | description | fts 1014----+--------+-------------------+----------------------------------+---------------------------------------------------------1015 3 | Tootle | Gertrude Crampton | Little toy train has big dreams. | 'big':5 'dream':6 'littl':1 'tootl':7 'toy':2 'train':31016(1 row)10171018 id | title | author | description | fts 1019----+-------------------------------------+--------------+-------------------------------------------------+-----------------------------------------------------------------------------------------------------------------1020 5 | Harry Potter and the Goblet of Fire | J.K. Rowling | Fourth year of school starts, big drama ensues. | 'big':6 'drama':7 'ensu':8 'fire':15 'fourth':1 'goblet':13 'harri':9 'potter':10 'school':4 'start':5 'year':21021(1 row)10221023 id | title | author | description | fts 1024----+-------------------------------------+--------------+-------------------------------------------------+-----------------------------------------------------------------------------------------------------------------1025 5 | Harry Potter and the Goblet of Fire | J.K. Rowling | Fourth year of school starts, big drama ensues. | 'big':6 'drama':7 'ensu':8 'fire':15 'fourth':1 'goblet':13 'harri':9 'potter':10 'school':4 'start':5 'year':21026(1 row)10271028 id | title | author | description | fts 1029----+-------------------------------------+--------------+-------------------------------------------------+-----------------------------------------------------------------------------------------------------------------1030 5 | Harry Potter and the Goblet of Fire | J.K. Rowling | Fourth year of school starts, big drama ensues. | 'big':6 'drama':7 'ensu':8 'fire':15 'fourth':1 'goblet':13 'harri':9 'potter':10 'school':4 'start':5 'year':21031(1 row)10321033 id | title | author | description | fts 1034----+--------------------+-----------+--------------------------------------------------------------------+---------------------------------------------------------------------------------------------------1035 4 | Green Eggs and Ham | Dr. Seuss | Sam has changing food preferences and eats unusually colored food. | 'chang':3 'color':9 'eat':7 'egg':12 'food':4,10 'green':11 'ham':14 'prefer':5 'sam':1 'unusu':81036(1 row)10371038 id | title | author | description | fts 1039----+--------+-------------------+----------------------------------+---------------------------------------------------------1040 3 | Tootle | Gertrude Crampton | Little toy train has big dreams. | 'big':5 'dream':6 'littl':1 'tootl':7 'toy':2 'train':31041(1 row)10421043 id | title | author | description | fts 1044----+-------+--------+-------------+-----1045(0 rows)10461047 id | title | author | description | fts 1048----+--------------------------+----------------+------------------------------+---------------------------------------------------1049 2 | The Tale of Peter Rabbit | Beatrix Potter | Rabbit eats some vegetables. | 'eat':2 'peter':8 'rabbit':1,9 'tale':6 'veget':41050(1 row)10511052 id | title | author | description | fts 1053----+-------------------------------------+--------------+-------------------------------------------------+-----------------------------------------------------------------------------------------------------------------1054 5 | Harry Potter and the Goblet of Fire | J.K. Rowling | Fourth year of school starts, big drama ensues. | 'big':6 'drama':7 'ensu':8 'fire':15 'fourth':1 'goblet':13 'harri':9 'potter':10 'school':4 'start':5 'year':21055(1 row)10561057 id | title | author | description | fts 1058----+-------+--------+-------------+-----1059(0 rows)10601061 id | title | author | description | fts 1062----+--------+-------------------+----------------------------------+---------------------------------------------------------1063 3 | Tootle | Gertrude Crampton | Little toy train has big dreams. | 'big':5 'dream':6 'littl':1 'tootl':7 'toy':2 'train':31064(1 row)10651066DROP FUNCTION1067DROP FUNCTION1068DROP TABLE10692026-10-27 10:47:43 [INFO] Running pgtap test: docs-functions.sql1070$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-functions.sql1071CREATE FUNCTION1072 hello_world 1073-------------1074 hello world1075(1 row)10761077CREATE TABLE1078INSERT 0 31079CREATE TABLE1080INSERT 0 41081CREATE FUNCTION1082 id | name 1083----+----------1084 1 | Tattoine1085(1 row)10861087CREATE FUNCTION1088psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-functions.sql:64: ERROR: duplicate key value violates unique constraint "planets_pkey"1089DETAIL: Key (id)=(1) already exists.1090CONTEXT: SQL statement "insert into planets(name)1091 values (add_planet.name)1092 returning id"1093PL/pgSQL function add_planet(text) line 5 at SQL statement1094CREATE FUNCTION1095 hello_world_definer 1096---------------------1097 hello world1098(1 row)10991100REVOKE1101psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-functions.sql:79: ERROR: role "anon" does not exist1102psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-functions.sql:81: ERROR: role "authenticated" does not exist1103REVOKE1104psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-functions.sql:84: ERROR: role "anon" does not exist1105ALTER DEFAULT PRIVILEGES1106psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-functions.sql:87: ERROR: role "anon" does not exist1107psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-functions.sql:89: ERROR: role "authenticated" does not exist1108CREATE FUNCTION1109psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-functions.sql:106: WARNING: logging warning: WARNING MESSAGE1110psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-functions.sql:106: ERROR: logging error: ERROR MESSAGE1111CONTEXT: PL/pgSQL function logging_example(text,text,text) line 5 at RAISE1112CREATE FUNCTION1113 error_if_null 1114---------------1115 not null1116(1 row)11171118CREATE TABLE1119INSERT 0 11120CREATE FUNCTION1121 assert_example 1122--------------------------------------1123 123e4567-e89b-12d3-a456-4266141740001124(1 row)11251126CREATE FUNCTION1127psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-functions.sql:162: ERROR: An error occurred in function <function name>: relation "table_that_does_not_exist" does not exist1128CONTEXT: PL/pgSQL function error_example() line 7 at RAISE1129CREATE TABLE1130INSERT 0 11131CREATE FUNCTION1132 advanced_example 1133------------------1134 42,new val1135(1 row)11361137DROP FUNCTION1138DROP FUNCTION1139DROP FUNCTION1140DROP FUNCTION1141DROP FUNCTION1142DROP FUNCTION1143DROP FUNCTION1144DROP FUNCTION1145DROP FUNCTION1146DROP TABLE1147DROP TABLE1148DROP TABLE1149DROP TABLE1150GRANT1151psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-functions.sql:221: ERROR: role "anon" does not exist1152ALTER DEFAULT PRIVILEGES1153psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-functions.sql:224: ERROR: role "anon" does not exist11542026-10-27 10:47:44 [INFO] Running pgtap test: docs-indexes.sql1155$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-indexes.sql1156CREATE TABLE1157INSERT 0 11158 name 1159----------1160 John Doe1161(1 row)11621163CREATE INDEX1164CREATE INDEX1165CREATE INDEX1166REINDEX1167REINDEX1168DROP TABLE11692026-10-27 10:47:44 [INFO] Running pgtap test: docs-json.sql1170$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-json.sql1171CREATE TABLE1172INSERT 0 51173 title | description | price | low_age | high_age 1174-------------------------------------+--------------------------------------------------------------------+-------+---------+----------1175 The Poky Little Puppy | Puppy is slower than other, bigger animals. | 5.95 | 3 | 61176 The Tale of Peter Rabbit | Rabbit eats some vegetables. | 4.49 | 2 | 51177 Tootle | Little toy train has big dreams. | 3.99 | 2 | 51178 Green Eggs and Ham | Sam has changing food preferences and eats unusually colored food. | 7.49 | 4 | 81179 Harry Potter and the Goblet of Fire | Fourth year of school starts, big drama ensues. | 24.95 | 10 | 991180(5 rows)11811182DROP TABLE11832026-10-27 10:47:44 [INFO] Running pgtap test: docs-partitioning.sql1184$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-partitioning.sql1185CREATE TABLE1186CREATE TABLE1187CREATE TABLE1188INSERT 0 41189 id | order_date | customer_id | amount 1190----+------------+-------------+--------1191 1 | 2000-01-15 | 1 | 1001192 2 | 2000-01-20 | 2 | 2001193 3 | 2000-02-10 | 3 | 1501194 4 | 2000-02-25 | 4 | 3001195(4 rows)11961197 id | order_date | customer_id | amount 1198----+------------+-------------+--------1199 3 | 2000-02-10 | 3 | 1501200 4 | 2000-02-25 | 4 | 3001201(2 rows)12021203DROP TABLE1204CREATE TABLE1205CREATE TABLE1206CREATE TABLE1207INSERT 0 51208 id | name | country 1209----+------------+---------1210 1 | John Doe | US1211 2 | Jane Smith | CANADA1212(2 rows)12131214 id | name | country 1215----+-------------+---------1216 3 | Li Wei | CHINA1217 4 | Priya Patel | INDIA1218 5 | Yuki Tanaka | JAPAN1219(3 rows)12201221DROP TABLE1222CREATE TABLE1223CREATE TABLE1224CREATE TABLE1225INSERT 0 41226 id | name | category | price 1227----+--------+-------------+-------1228 1 | Laptop | Electronics | 9991229 2 | Phone | Electronics | 5991230(2 rows)12311232 count 1233-------1234 21235(1 row)12361237 count 1238-------1239 21240(1 row)12411242DROP TABLE12432026-10-27 10:47:44 [INFO] Running pgtap test: docs-tables-and-data.sql1244$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-tables-and-data.sql1245CREATE TABLE1246 table_name | column_name | data_type | is_nullable | column_default 1247------------+-------------+-----------+-------------+----------------1248 movies | id | bigint | NO | 1249 movies | name | text | YES | 1250 movies | description | text | YES | 1251(3 rows)12521253DROP TABLE1254CREATE TABLE1255 column_name | data_type | is_nullable | column_default | is_identity | identity_generation 1256-------------+-----------+-------------+----------------+-------------+---------------------1257 id | bigint | NO | | YES | ALWAYS1258(1 row)12591260DROP TABLE1261CREATE TABLE1262 column_name | data_type | is_nullable | column_default | is_identity | identity_generation 1263-------------+-----------+-------------+----------------+-------------+---------------------1264 id | bigint | NO | | YES | BY DEFAULT1265(1 row)12661267DROP TABLE1268CREATE TABLE1269INSERT 0 21270 id | name | description 1271----+-------------------------+--------------------------------------------------------------------------------------------------------------------------------1272 1 | The Empire Strikes Back | After the Rebels are brutally overpowered by the Empire on the ice planet Hoth, Luke Skywalker begins Jedi training with Yoda.1273 2 | Return of the Jedi | After a daring mission to rescue Han Solo from Jabba the Hutt, the Rebels dispatch to Endor to destroy the second Death Star.1274(2 rows)12751276DROP TABLE1277psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-tables-and-data.sql:57: NOTICE: table "categories" does not exist, skipping1278DROP TABLE1279CREATE TABLE1280CREATE TABLE1281ALTER TABLE1282 table_name | column_name | foreign_table_name | foreign_column_name 1283------------+-------------+--------------------+---------------------1284 movies | category_id | categories | id1285(1 row)12861287psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-tables-and-data.sql:89: NOTICE: table "performances" does not exist, skipping1288DROP TABLE1289psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-tables-and-data.sql:90: NOTICE: table "actors" does not exist, skipping1290DROP TABLE1291DROP TABLE1292CREATE TABLE1293CREATE TABLE1294CREATE TABLE1295 table_name 1296--------------1297 actors1298 movies1299 performances1300(3 rows)13011302CREATE SCHEMA1303 schema_name 1304-------------1305 private1306(1 row)13071308psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-tables-and-data.sql:120: NOTICE: table "salaries" does not exist, skipping1309DROP TABLE1310psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-tables-and-data.sql:121: NOTICE: drop cascades to constraint performances_actor_id_fkey on table performances1311DROP TABLE1312CREATE TABLE1313CREATE TABLE1314 table_schema | table_name 1315--------------+------------1316 private | salaries1317(1 row)13181319psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-tables-and-data.sql:137: NOTICE: table "grades" does not exist, skipping1320DROP TABLE1321psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-tables-and-data.sql:138: NOTICE: table "courses" does not exist, skipping1322DROP TABLE1323psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-tables-and-data.sql:139: NOTICE: table "students" does not exist, skipping1324DROP TABLE1325psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-tables-and-data.sql:140: NOTICE: view "transcripts" does not exist, skipping1326DROP VIEW1327CREATE TABLE1328CREATE TABLE1329CREATE TABLE1330INSERT 0 31331INSERT 0 31332INSERT 0 61333CREATE VIEW1334psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-tables-and-data.sql:192: ERROR: role "authenticated" does not exist1335 name | type | title | code | result 1336------------------+---------------+--------------------------+---------+--------1337 Anakin Skywalker | graduate | Authentication Theories | AUTH205 | A1338 Anakin Skywalker | graduate | Introduction to Postgres | PG101 | A-1339 Anakin Skywalker | graduate | Fundamentals of Supabase | SUP412 | B-1340 Princess Leia | undergraduate | Introduction to Postgres | PG101 | B+1341 Princess Leia | undergraduate | Fundamentals of Supabase | SUP412 | A+1342 Yoda | graduate | Authentication Theories | AUTH205 | A1343(6 rows)13441345psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-tables-and-data.sql:196: NOTICE: materialized view "transcripts_materialized" does not exist, skipping1346DROP MATERIALIZED VIEW1347SELECT 61348 name | type | title | code | result 1349------------------+---------------+--------------------------+---------+--------1350 Anakin Skywalker | graduate | Authentication Theories | AUTH205 | A1351 Anakin Skywalker | graduate | Introduction to Postgres | PG101 | A-1352 Anakin Skywalker | graduate | Fundamentals of Supabase | SUP412 | B-1353 Princess Leia | undergraduate | Introduction to Postgres | PG101 | B+1354 Princess Leia | undergraduate | Fundamentals of Supabase | SUP412 | A+1355 Yoda | graduate | Authentication Theories | AUTH205 | A1356(6 rows)13571358REFRESH MATERIALIZED VIEW1359 count 1360-------1361 61362(1 row)13631364psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-tables-and-data.sql:217: NOTICE: view "secure_transcripts" does not exist, skipping1365DROP VIEW1366CREATE VIEW1367 schemaname | viewname 1368------------+--------------------1369 public | secure_transcripts1370(1 row)13711372psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-tables-and-data.sql:228: NOTICE: view "test_view" does not exist, skipping1373DROP VIEW1374CREATE VIEW1375ALTER VIEW1376 schemaname | viewname 1377------------+-----------1378 public | test_view1379(1 row)13801381DROP MATERIALIZED VIEW1382DROP VIEW1383DROP VIEW1384DROP VIEW1385DROP TABLE1386DROP TABLE1387DROP TABLE1388DROP TABLE1389DROP TABLE1390DROP TABLE1391DROP TABLE1392DROP TABLE1393DROP SCHEMA13942026-10-27 10:47:44 [INFO] Running pgtap test: docs-triggers.sql1395$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-triggers.sql1396CREATE TABLE1397CREATE TABLE1398CREATE FUNCTION1399CREATE TRIGGER1400INSERT 0 11401INSERT 0 11402UPDATE 11403 id | employee_id | old_salary | new_salary 1404----+-------------+------------+------------1405 1 | 1 | 50000 | 550001406(1 row)14071408CREATE TABLE1409CREATE TABLE1410CREATE FUNCTION1411CREATE TRIGGER1412CREATE TABLE1413CREATE FUNCTION1414CREATE TRIGGER1415INSERT 0 11416INSERT 0 11417INSERT 0 11418INSERT 0 11419DELETE 11420 id | customer_id | action | customer_name 1421----+-------------+--------+---------------1422 1 | 1 | DELETE | Alice Johnson1423(1 row)14241425CREATE TABLE1426CREATE FUNCTION1427CREATE TRIGGER1428INSERT 0 11429 id | trigger_name | operation | table_name 1430----+-------------------------+-----------+------------1431 1 | statement_level_trigger | INSERT | orders1432(1 row)14331434CREATE TABLE1435CREATE FUNCTION1436CREATE TRIGGER1437INSERT 0 11438UPDATE 11439DELETE 11440 id | trigger_name | trigger_when | operation | table_name | table_schema | row_id 1441----+-------------------+--------------+-----------+------------+--------------+--------1442 1 | variables_trigger | AFTER | INSERT | employees | public | 31443 2 | variables_trigger | AFTER | UPDATE | employees | public | 31444 3 | variables_trigger | AFTER | DELETE | employees | public | 31445(3 rows)14461447CREATE TABLE1448CREATE FUNCTION1449CREATE TRIGGER1450INSERT 0 11451INSERT 0 11452 id | employee_name | salary 1453----+---------------+--------1454 1 | Executive | 1500001455(1 row)14561457DROP TRIGGER1458DROP TRIGGER1459DROP TRIGGER1460DROP TRIGGER1461DROP TRIGGER1462DROP TRIGGER1463DROP FUNCTION1464DROP FUNCTION1465DROP FUNCTION1466DROP FUNCTION1467DROP FUNCTION1468DROP FUNCTION1469DROP TABLE1470DROP TABLE1471DROP TABLE1472DROP TABLE1473DROP TABLE1474DROP TABLE1475DROP TABLE1476DROP TABLE14772026-10-27 10:47:44 [INFO] Running pgtap test: docs-webhooks.sql1478$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-webhooks.sql1479CREATE TABLE1480CREATE TABLE1481CREATE FUNCTION1482CREATE TRIGGER1483CREATE TRIGGER1484CREATE TRIGGER1485INSERT 0 11486INSERT 0 11487 id | webhook_name | event_type | table_name | schema_name | ?column? 1488----+----------------+------------+------------+-------------+--------------------------------------------------------------1489 1 | insert_webhook | INSERT | profiles | public | {"id": 1, "name": "John Doe", "email": "john@example.com"}1490 2 | insert_webhook | INSERT | profiles | public | {"id": 2, "name": "Jane Smith", "email": "jane@example.com"}1491(2 rows)14921493UPDATE 11494 id | webhook_name | event_type | table_name | schema_name | ?column? | ?column? 1495----+----------------+------------+------------+-------------+----------------------------------------------------------------+------------------------------------------------------------1496 3 | update_webhook | UPDATE | profiles | public | {"id": 1, "name": "John Doe", "email": "john.doe@example.com"} | {"id": 1, "name": "John Doe", "email": "john@example.com"}1497(1 row)14981499DELETE 11500 id | webhook_name | event_type | table_name | schema_name | ?column? 1501----+----------------+------------+------------+-------------+--------------------------------------------------------------1502 4 | delete_webhook | DELETE | profiles | public | {"id": 2, "name": "Jane Smith", "email": "jane@example.com"}1503(1 row)15041505CREATE TABLE1506CREATE TABLE1507CREATE FUNCTION1508CREATE FUNCTION1509CREATE TRIGGER1510INSERT 0 11511INSERT 0 11512 id | webhook_name | url | method | response_status | response_data 1513----+----------------+----------------------------------+--------+-----------------+------------------------------------------------------------------------------------------1514 1 | orders_webhook | https://dummyjson.com/products/1 | GET | 200 | {"id": 1, "price": 9.99, "title": "Essence Mascara Lash Princess", "category": "beauty"}1515 2 | orders_webhook | https://dummyjson.com/products/1 | GET | 200 | {"id": 1, "price": 9.99, "title": "Essence Mascara Lash Princess", "category": "beauty"}1516(2 rows)15171518CREATE TABLE1519INSERT 0 11520CREATE FUNCTION1521CREATE TRIGGER1522INSERT 0 11523 id | webhook_name | url | method | response_status | response_data 1524----+-----------------+----------------------------------+--------+-----------------+-------------------------------------------------------------------------------------------1525 3 | product_webhook | https://dummyjson.com/products/2 | GET | 200 | {"id": 2, "price": 19.99, "title": "Eyeshadow Palette with Mirror", "category": "beauty"}1526(1 row)15271528CREATE FUNCTION1529 webhook_name | event_type | table_name | record_count 1530----------------+------------+------------+--------------1531 delete_webhook | DELETE | profiles | 11532 insert_webhook | INSERT | profiles | 31533 update_webhook | UPDATE | profiles | 11534(3 rows)15351536DROP TRIGGER1537DROP TRIGGER1538DROP TRIGGER1539DROP TRIGGER1540DROP TRIGGER1541DROP FUNCTION1542DROP FUNCTION1543DROP FUNCTION1544DROP FUNCTION1545DROP FUNCTION1546DROP TABLE1547DROP TABLE1548DROP TABLE1549DROP TABLE1550DROP TABLE15512026-10-27 10:47:44 [INFO] Running pgtap test: enable_tracking.sql1552$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/enable_tracking.sql1553psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/enable_tracking.sql:1: ERROR: role "postgres" does not exist1554psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/enable_tracking.sql:2: ERROR: role "postgres" does not exist1555psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/enable_tracking.sql:4: ERROR: role "postgres" does not exist1556psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/enable_tracking.sql:5: ERROR: role "postgres" does not exist15572026-10-27 10:47:44 [INFO] Running pgtap test: event_trigger_search_path.sql1558$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/event_trigger_search_path.sql1559DO15602026-10-27 10:47:44 [INFO] Running pgtap test: intarray_ltree_query.sql1561$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/intarray_ltree_query.sql1562BEGIN1563SET1564CREATE EXTENSION1565CREATE EXTENSION1566 q_and 1567-------1568 f1569(1 row)15701571 q_or 1572------1573 t1574(1 row)15751576 lquery_match 1577--------------1578 t1579(1 row)15801581 ltxtquery_match 1582-----------------1583 t1584(1 row)15851586psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/intarray_ltree_query.sql:38: ERROR: query_int expression is too complex1587psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/intarray_ltree_query.sql:42: ERROR: current transaction is aborted, commands ignored until end of transaction block1588psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/intarray_ltree_query.sql:45: ERROR: current transaction is aborted, commands ignored until end of transaction block1589psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/intarray_ltree_query.sql:47: ERROR: current transaction is aborted, commands ignored until end of transaction block1590ROLLBACK15912026-10-27 10:47:44 [INFO] Running pgtap test: ltree_label_overflow.sql1592$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/ltree_label_overflow.sql1593BEGIN1594SET1595CREATE EXTENSION1596 na | nb | a_gt_b | a_lt_b | b_lt_a | a_eq_a 1597-------+----+--------+--------+--------+--------1598 20001 | 1 | t | f | t | t1599(1 row)16001601ROLLBACK16022026-10-27 10:47:45 [INFO] Running pgtap test: multirange_create_priv.sql1603$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/multirange_create_priv.sql1604BEGIN1605CREATE SCHEMA1606CREATE SCHEMA1607psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/multirange_create_priv.sql:16: ERROR: role "postgres" does not exist1608psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/multirange_create_priv.sql:18: ERROR: current transaction is aborted, commands ignored until end of transaction block1609psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/multirange_create_priv.sql:24: ERROR: current transaction is aborted, commands ignored until end of transaction block1610psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/multirange_create_priv.sql:28: ERROR: current transaction is aborted, commands ignored until end of transaction block1611psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/multirange_create_priv.sql:32: ERROR: current transaction is aborted, commands ignored until end of transaction block1612psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/multirange_create_priv.sql:33: ERROR: savepoint "no_priv" does not exist1613psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/multirange_create_priv.sql:35: ERROR: current transaction is aborted, commands ignored until end of transaction block1614ROLLBACK16152026-10-27 10:47:45 [INFO] Running pgtap test: operator_breaking_change.sql1616$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/operator_breaking_change.sql1617BEGIN1618SET1619CREATE EXTENSION1620CREATE SCHEMA1621psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/operator_breaking_change.sql:22: ERROR: role "postgres" does not exist1622psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/operator_breaking_change.sql:26: ERROR: current transaction is aborted, commands ignored until end of transaction block1623psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/operator_breaking_change.sql:29: ERROR: current transaction is aborted, commands ignored until end of transaction block1624psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/operator_breaking_change.sql:32: ERROR: current transaction is aborted, commands ignored until end of transaction block1625psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/operator_breaking_change.sql:37: ERROR: current transaction is aborted, commands ignored until end of transaction block1626psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/operator_breaking_change.sql:38: ERROR: savepoint "before_restrict" does not exist1627psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/operator_breaking_change.sql:41: ERROR: current transaction is aborted, commands ignored until end of transaction block1628psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/operator_breaking_change.sql:46: ERROR: current transaction is aborted, commands ignored until end of transaction block1629psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/operator_breaking_change.sql:47: ERROR: savepoint "before_join" does not exist1630psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/operator_breaking_change.sql:55: ERROR: current transaction is aborted, commands ignored until end of transaction block1631psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/operator_breaking_change.sql:56: ERROR: current transaction is aborted, commands ignored until end of transaction block1632psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/operator_breaking_change.sql:58: ERROR: current transaction is aborted, commands ignored until end of transaction block1633psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/operator_breaking_change.sql:60: ERROR: current transaction is aborted, commands ignored until end of transaction block1634ROLLBACK16352026-10-27 10:47:45 [INFO] Running pgtap test: pg-safeupdate.sql1636$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pg-safeupdate.sql1637LOAD1638SET1639CREATE SCHEMA1640CREATE TABLE1641psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pg-safeupdate.sql:13: ERROR: UPDATE requires a WHERE clause1642psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pg-safeupdate.sql:15: NOTICE: drop cascades to table v.foo1643DROP SCHEMA16442026-10-27 10:47:45 [INFO] Running pgtap test: pg_graphql.sql1645$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pg_graphql.sql1646BEGIN1647COMMENT1648CREATE TABLE1649CREATE TABLE1650COMMENT1651CREATE FUNCTION1652 resolve 1653----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------1654 {"data": {"insertIntoAccountCollection": {"records": [{"id": 1, "status": "active", "echoEmail": "foo@barsley.com", "blogCollection": {"totalCount": 0}}, {"id": 2, "status": "active", "echoEmail": "bar@foosworth.com", "blogCollection": {"totalCount": 0}}], "affectedCount": 2}}}1655(1 row)16561657 resolve 1658--------------------------------------------------------------------------------------1659 {"data": {"insertIntoBlogCollection": {"records": [{"id": 1, "owner": {"id": 1}}]}}}1660(1 row)16611662 resolve 1663------------------------------------------------------------------------------------------------------------------------1664 {"data": {"insertIntoAccountCollection": {"records": [{"email": "baz@baz.com", "status": null}], "affectedCount": 1}}}1665(1 row)16661667 resolve 1668--------------------------------------------------------------------------------------------------------------------------------1669 {"data": {"xyz": {"records": [{"id": 4, "email": "foo@bar.com"}, {"id": 5, "email": "other@email.com"}], "affectedCount": 2}}}1670(1 row)16711672 resolve 1673------------------------------------------------------------------------------------------------1674 {"data": {"xyz": {"records": [{"email": "1@email.com", "status": null}], "affectedCount": 1}}}1675(1 row)16761677 resolve 1678------------------------------------------------------------------------------------------------1679 {"data": {"xyz": {"records": [{"email": "x@y.com", "status": "active"}], "affectedCount": 1}}}1680(1 row)16811682 resolve 1683-----------------------------------------------------------------------------------------------------------------1684 {"data": {"insertIntoAccountCollection": {"records": [{"id": 8, "email": "bar@foo.com"}], "affectedCount": 1}}}1685(1 row)16861687 resolve 1688-----------------------------------------------------------------------------------------------------------------1689 {"data": {"insertIntoAccountCollection": {"records": [{"id": 9, "email": "bar@foo.com"}], "affectedCount": 1}}}1690(1 row)16911692 resolve 1693--------------------------------------------------------------1694 {"data": {"insertIntoBlogCollection": {"affectedCount": 1}}}1695(1 row)16961697 resolve 1698---------------------------------------------------------------------------------------------------------------------1699 {"data": null, "errors": [{"message": "Input for type AccountInsertInput contains extra keys [\"doesNotExist\"]"}]}1700(1 row)17011702 resolve 1703-----------------------------------------------------------------------------------1704 {"data": null, "errors": [{"message": "Invalid input for BlogInsertInput type"}]}1705(1 row)17061707 resolve 1708---------------------------------------------------------------------------1709 {"data": null, "errors": [{"message": "Invalid input for NonNull type"}]}1710(1 row)17111712 resolve 1713--------------------------------------------------------------------------------------------1714 {"data": null, "errors": [{"message": "At least one record must be provided to objects"}]}1715(1 row)17161717ROLLBACK17182026-10-27 10:47:45 [INFO] Running pgtap test: pg_net.sql1719$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pg_net.sql1720 request_id 1721------------1722 11723(1 row)172417252026-10-27 10:47:45 [INFO] Running pgtap test: pg_plan_filter.sql1726$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pg_plan_filter.sql1727BEGIN1728psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pg_plan_filter.sql:2: ERROR: could not access file "plan_filter": No such file or directory1729psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pg_plan_filter.sql:4: ERROR: current transaction is aborted, commands ignored until end of transaction block1730psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pg_plan_filter.sql:10: ERROR: current transaction is aborted, commands ignored until end of transaction block1731psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pg_plan_filter.sql:14: ERROR: current transaction is aborted, commands ignored until end of transaction block1732psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pg_plan_filter.sql:16: ERROR: current transaction is aborted, commands ignored until end of transaction block1733psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pg_plan_filter.sql:18: ERROR: current transaction is aborted, commands ignored until end of transaction block1734ROLLBACK17352026-10-27 10:47:45 [INFO] Running pgtap test: pgaudit.sql1736$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pgaudit.sql1737SET1738SET1739SET1740CREATE SCHEMA1741CREATE TABLE1742INSERT 0 11743 id | name | password | description 1744----+-------+----------+-------------1745 1 | user1 | HASH1 | blah, blah1746(1 row)17471748psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pgaudit.sql:23: NOTICE: drop cascades to table v.account1749DROP SCHEMA17502026-10-27 10:47:45 [INFO] Running pgtap test: pgbouncer.sql1751$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pgbouncer.sql1752 schema_name | owner 1753-------------+-------1754(0 rows)17551756 schema_name | function_name | owner 1757-------------+---------------+-------1758(0 rows)17591760 schema | object_name | grantee | privilege_type 1761--------+-------------+---------+----------------1762(0 rows)17631764CREATE ROLE1765CREATE ROLE1766UPDATE 11767psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pgbouncer.sql:61: ERROR: schema "pgbouncer" does not exist1768LINE 1: select pgbouncer.get_auth('test_expired_user_password');1769 ^1770psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pgbouncer.sql:63: ERROR: schema "pgbouncer" does not exist1771LINE 1: select pgbouncer.get_auth('test_valid_user_password');1772 ^1773psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pgbouncer.sql:66: ERROR: role "pgbouncer" does not exist1774psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pgbouncer.sql:67: ERROR: schema "pgbouncer" does not exist1775LINE 1: select pgbouncer.get_auth('test_valid_user_password');1776 ^1777RESET1778psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pgbouncer.sql:71: ERROR: role "postgres" does not exist1779psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pgbouncer.sql:72: ERROR: schema "pgbouncer" does not exist1780LINE 1: select pgbouncer.get_auth('test_valid_user_password');1781 ^1782RESET1783DROP ROLE1784DROP ROLE17852026-10-27 10:47:45 [INFO] Running pgtap test: pgcrypto_cipher_matrix.sql1786$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pgcrypto_cipher_matrix.sql1787BEGIN1788CREATE EXTENSION1789SAVEPOINT1790psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pgcrypto_cipher_matrix.sql:26: ERROR: encrypt error: Cipher cannot be initialized1791ROLLBACK1792SAVEPOINT1793psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pgcrypto_cipher_matrix.sql:30: ERROR: encrypt error: Cipher cannot be initialized1794ROLLBACK1795SAVEPOINT1796psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pgcrypto_cipher_matrix.sql:34: ERROR: encrypt error: Cipher cannot be initialized1797ROLLBACK1798 aes128_rt 1799-----------1800 secret1801(1 row)18021803 aes192_rt 1804-----------1805 secret1806(1 row)18071808 aes256_rt 1809-----------1810 secret1811(1 row)18121813 des3_rt 1814---------1815 secret1816(1 row)18171818SAVEPOINT1819psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pgcrypto_cipher_matrix.sql:45: ERROR: Wrong key or corrupt data1820ROLLBACK1821SAVEPOINT1822psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pgcrypto_cipher_matrix.sql:49: ERROR: Wrong key or corrupt data1823ROLLBACK1824 post_error_ok 1825---------------1826 still-here1827(1 row)18281829ROLLBACK18302026-10-27 10:47:45 [INFO] Running pgtap test: pgsodium.sql1831$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pgsodium.sql1832 status 1833--------1834 valid1835(1 row)183618372026-10-27 10:47:45 [INFO] Running pgtap test: realtime.sql1838$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/realtime.sql1839 publication_name | owner | puballtables | pubinsert | pubupdate | pubdelete | pubtruncate 1840------------------+-------+--------------+-----------+-----------+-----------+-------------1841(0 rows)184218432026-10-27 10:47:45 [INFO] Running pgtap test: replica_identity_upsert.sql1844$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/replica_identity_upsert.sql1845BEGIN1846CREATE TABLE1847CREATE PUBLICATION1848INSERT 0 11849SAVEPOINT1850psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/replica_identity_upsert.sql:17: ERROR: cannot update table "ri" because it does not have a replica identity and publishes updates1851HINT: To enable updating the table, set REPLICA IDENTITY using ALTER TABLE.1852ROLLBACK1853SAVEPOINT1854psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/replica_identity_upsert.sql:22: ERROR: cannot update table "ri" because it does not have a replica identity and publishes updates1855HINT: To enable updating the table, set REPLICA IDENTITY using ALTER TABLE.1856ROLLBACK1857ALTER TABLE1858INSERT 0 11859MERGE 11860 v 1861----1862 301863(1 row)18641865ROLLBACK18662026-10-27 10:47:45 [INFO] Running pgtap test: storage.sql1867$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/storage.sql1868 schema_name | owner 1869-------------+-------1870(0 rows)18711872 schema_name | table_name | owner | rls_enabled | rls_policies 1873-------------+------------+-------+-------------+--------------1874(0 rows)18751876 schema_name | table_name | role_name | privilege_type | is_grantable 1877-------------+------------+-----------+----------------+--------------1878(0 rows)18791880 table_schema | table_name | index_name | index_owner 1881--------------+------------+------------+-------------1882(0 rows)18831884 schema_name | function_name | owner 1885-------------+---------------+-------1886(0 rows)18871888CREATE ROLE1889psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/storage.sql:98: ERROR: role "postgres" does not exist1890psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/storage.sql:100: ERROR: role "postgres" does not exist1891psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/storage.sql:101: ERROR: schema "storage" does not exist1892psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/storage.sql:102: ERROR: schema "storage" does not exist1893psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/storage.sql:104: ERROR: role "postgres" does not exist1894DROP OWNED1895DROP ROLE1896RESET18972026-10-27 10:47:45 [INFO] Running pgtap test: supautils_reserved_roles.sql1898$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_reserved_roles.sql1899BEGIN1900psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_reserved_roles.sql:5: ERROR: role "postgres" does not exist1901psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_reserved_roles.sql:8: ERROR: current transaction is aborted, commands ignored until end of transaction block1902psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_reserved_roles.sql:9: ERROR: current transaction is aborted, commands ignored until end of transaction block1903psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_reserved_roles.sql:10: ERROR: savepoint "before_drop" does not exist1904psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_reserved_roles.sql:12: ERROR: current transaction is aborted, commands ignored until end of transaction block1905psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_reserved_roles.sql:14: ERROR: current transaction is aborted, commands ignored until end of transaction block1906ROLLBACK19072026-10-27 10:47:45 [INFO] Running pgtap test: supautils_warehouse_writer.sql1908$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql1909BEGIN1910 protection_registered 1911-----------------------1912 f1913(1 row)19141915CREATE ROLE1916CREATE ROLE1917CREATE ROLE1918GRANT ROLE1919psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:9: ERROR: role "postgres" does not exist1920psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:10: ERROR: current transaction is aborted, commands ignored until end of transaction block1921psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:11: ERROR: current transaction is aborted, commands ignored until end of transaction block1922psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:12: ERROR: savepoint "denied" does not exist1923psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:13: ERROR: current transaction is aborted, commands ignored until end of transaction block1924psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:14: ERROR: current transaction is aborted, commands ignored until end of transaction block1925psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:15: ERROR: savepoint "denied" does not exist1926psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:16: ERROR: current transaction is aborted, commands ignored until end of transaction block1927psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:17: ERROR: current transaction is aborted, commands ignored until end of transaction block1928psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:18: ERROR: savepoint "denied" does not exist1929psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:19: ERROR: current transaction is aborted, commands ignored until end of transaction block1930psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:20: ERROR: current transaction is aborted, commands ignored until end of transaction block1931psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:21: ERROR: savepoint "denied" does not exist1932psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:22: ERROR: current transaction is aborted, commands ignored until end of transaction block1933psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:23: ERROR: current transaction is aborted, commands ignored until end of transaction block1934psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:24: ERROR: savepoint "denied" does not exist1935psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:25: ERROR: current transaction is aborted, commands ignored until end of transaction block1936psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:26: ERROR: current transaction is aborted, commands ignored until end of transaction block1937psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:27: ERROR: savepoint "denied" does not exist1938psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:28: ERROR: current transaction is aborted, commands ignored until end of transaction block1939psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:29: ERROR: current transaction is aborted, commands ignored until end of transaction block1940psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:30: ERROR: savepoint "denied" does not exist1941psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:31: ERROR: current transaction is aborted, commands ignored until end of transaction block1942psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:32: ERROR: current transaction is aborted, commands ignored until end of transaction block1943psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:33: ERROR: savepoint "denied" does not exist1944psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:34: ERROR: current transaction is aborted, commands ignored until end of transaction block1945psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:35: ERROR: current transaction is aborted, commands ignored until end of transaction block1946psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:36: ERROR: savepoint "denied" does not exist1947psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:37: ERROR: current transaction is aborted, commands ignored until end of transaction block1948psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:38: ERROR: current transaction is aborted, commands ignored until end of transaction block1949psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:39: ERROR: current transaction is aborted, commands ignored until end of transaction block1950psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:40: ERROR: current transaction is aborted, commands ignored until end of transaction block1951psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:41: ERROR: current transaction is aborted, commands ignored until end of transaction block1952psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:42: ERROR: current transaction is aborted, commands ignored until end of transaction block1953ROLLBACK19542026-10-27 10:47:45 [INFO] Running pgtap test: vault.sql1955$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/vault.sql1956 schema | object_name | grantee | privilege_type 1957--------+---------------------------+----------------+----------------1958 vault | _crypto_aead_det_decrypt | supabase_admin | EXECUTE1959 vault | _crypto_aead_det_encrypt | supabase_admin | EXECUTE1960 vault | _crypto_aead_det_noncegen | supabase_admin | EXECUTE1961 vault | create_secret | supabase_admin | EXECUTE1962 vault | update_secret | supabase_admin | EXECUTE1963(5 rows)19641965 schema | table | index_name | index_owner | index_type 1966--------+---------+------------------+----------------+------------1967 vault | secrets | secrets_name_idx | supabase_admin | Unique1968 vault | secrets | secrets_pkey | supabase_admin | Unique1969(2 rows)19701971 search_path 1972-----------------1973 "$user", public1974(1 row)19751976SET1977DROP EXTENSION1978CREATE TABLE1979psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/vault.sql:65: ERROR: role "postgres" does not exist1980LINE 1: ...g_extension values (0, 'supabase_vault', '0.2.8', 'postgres'...1981 ^1982CREATE EXTENSION1983DROP TABLE1984RESET1985 function_name | grantee | privilege_type 1986---------------+---------+----------------1987(0 rows)19881989psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/vault.sql:83: ERROR: role "postgres" does not exist1990 search_path 1991-----------------1992 "$user", public1993(1 row)199419952026-10-27 10:47:46 [INFO] Running pgtap test: wal2json.sql1996$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/wal2json.sql1997CREATE SCHEMA1998CREATE TABLE1999psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/wal2json.sql:10: ERROR: could not access file "wal2json": No such file or directory2000INSERT 0 12001psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/wal2json.sql:28: ERROR: replication slot "reg_test" does not exist2002psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/wal2json.sql:31: ERROR: replication slot "reg_test" does not exist2003psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/wal2json.sql:33: NOTICE: drop cascades to table v.foo2004DROP SCHEMA20052026-10-27 10:47:46 [INFO] Running pgtap test: z_17_intarray_ltree_query.sql2006$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/z_17_intarray_ltree_query.sql2007BEGIN2008SET2009CREATE EXTENSION2010psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/z_17_intarray_ltree_query.sql:7: ERROR: lquery level is too large2011DETAIL: Total size of level exceeds the maximum allowed (65535 bytes).2012psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/z_17_intarray_ltree_query.sql:9: ERROR: current transaction is aborted, commands ignored until end of transaction block2013ROLLBACK20142026-10-27 10:47:46 [INFO] Running pgtap test: z_17_wal_summarize.sql2015$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/z_17_wal_summarize.sql2016 summarize_wal_default_ok 2017--------------------------2018 f2019(1 row)20202021$ pg_ctl -D /build/tmp.OtiT8d8AMV stop2022waiting for server to shut down.... done2023server stopped20242026-10-27 10:47:46 [INFO] Starting PostgreSQL server for pg_regress tests2025$ /nix/store/wf5602rc1bkp16ywhq6i9lcffcq53wy0-start-postgres-server-test/bin/start-postgres-server 17 --daemonize2026Starting server for PSQL 172027/nix/store/wf5602rc1bkp16ywhq6i9lcffcq53wy0-start-postgres-server-test/bin/start-postgres-server: line 190: warning: setlocale: LC_ALL: cannot change locale (en_US.UTF-8): No such file or directory2028KEY_FILE: /build/tmp.t4uSscoz79/pgsodium.key2029KEY_FILE contents:2030cat: /build/tmp.t4uSscoz79/pgsodium.key: No such file or directory2031PGSODIUM_GETKEY_SCRIPT: /nix/store/w9di5d0d375pnbgky9kz1gqgh0jv7i65-pgsodium-getkey/bin/pgsodium-getkey2032NOTE: using port 5541 for server2033NOTE: using temporary directory /build/tmp.t4uSscoz79 for data2034NOTE: you are free to re-use this data directory at will2035The files belonging to this database system will be owned by user "nixbld".2036This user must also own the server process.20372038The database cluster will be initialized with locale "en_US.UTF-8".2039The default database encoding has accordingly been set to "UTF8".2040The default text search configuration will be set to "english".20412042Data page checksums are disabled.20432044fixing permissions on existing directory /build/tmp.t4uSscoz79 ... ok2045creating subdirectories ... ok2046selecting dynamic shared memory implementation ... posix2047selecting default "max_connections" ... 1002048selecting default "shared_buffers" ... 128MB2049selecting default time zone ... UTC2050creating configuration files ... ok2051running bootstrap script ... ok2052performing post-bootstrap initialization ... ok2053syncing data to disk ... ok20542055initdb: warning: enabling "trust" authentication for local connections2056initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.20572058Success. You can now start the database server using:20592060 /nix/store/0kc57vrr3jdbz3jqh7q142rdxndjs2b6-postgresql-and-plugins-17.11/bin/pg_ctl -D /build/tmp.t4uSscoz79 -l logfile start20612062NOTE: patching postgresql.conf files2063non-macos pg 17 conf2064waiting for server to start.... done2065server started2066pg_ctl: server is running (PID: 1213)2067/nix/store/0kc57vrr3jdbz3jqh7q142rdxndjs2b6-postgresql-and-plugins-17.11/bin/postgres "-D" "/build/tmp.t4uSscoz79" "--config-file=/build/tmp.t4uSscoz79/postgresql.conf" "-p" "5541" "-k" "/build/tmp.t4uSscoz79/tmp"2068PostgreSQL is ready2069WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2070DETAIL: "supautils" is now a reserved prefix.2071NOTICE: empty string is not a valid password, clearing password2072CREATE ROLE2073ALTER DATABASE2074Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/init-scripts/00000000000000-initial-schema.sql2075WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2076DETAIL: "supautils" is now a reserved prefix.2077CREATE PUBLICATION2078ALTER ROLE2079CREATE ROLE2080CREATE ROLE2081GRANT ROLE2082GRANT2083CREATE ROLE2084GRANT ROLE2085CREATE SCHEMA2086CREATE EXTENSION2087CREATE EXTENSION2088CREATE ROLE2089CREATE ROLE2090CREATE ROLE2091CREATE ROLE2092GRANT ROLE2093GRANT ROLE2094GRANT ROLE2095GRANT ROLE2096GRANT2097ALTER DEFAULT PRIVILEGES2098ALTER DEFAULT PRIVILEGES2099ALTER DEFAULT PRIVILEGES2100GRANT2101ALTER ROLE2102ALTER DEFAULT PRIVILEGES2103ALTER DEFAULT PRIVILEGES2104ALTER DEFAULT PRIVILEGES2105ALTER ROLE2106ALTER ROLE2107Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/init-scripts/00000000000001-auth-schema.sql2108WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2109DETAIL: "supautils" is now a reserved prefix.2110CREATE SCHEMA2111CREATE TABLE2112CREATE INDEX2113CREATE INDEX2114COMMENT2115CREATE TABLE2116CREATE INDEX2117CREATE INDEX2118CREATE INDEX2119COMMENT2120CREATE TABLE2121COMMENT2122CREATE TABLE2123CREATE INDEX2124COMMENT2125CREATE TABLE2126COMMENT2127INSERT 0 72128CREATE FUNCTION2129CREATE FUNCTION2130CREATE FUNCTION2131GRANT2132CREATE ROLE2133GRANT2134GRANT2135GRANT2136ALTER ROLE2137ALTER TABLE2138ALTER TABLE2139ALTER TABLE2140ALTER TABLE2141ALTER TABLE2142Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/init-scripts/00000000000002-storage-schema.sql2143WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2144DETAIL: "supautils" is now a reserved prefix.2145CREATE SCHEMA2146CREATE ROLE2147ALTER ROLE2148GRANT2149DO2150Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/init-scripts/00000000000003-post-setup.sql2151WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2152DETAIL: "supautils" is now a reserved prefix.2153ALTER ROLE2154ALTER ROLE2155CREATE FUNCTION2156CREATE EVENT TRIGGER2157COMMENT2158CREATE FUNCTION2159COMMENT2160DO2161CREATE ROLE2162GRANT2163GRANT2164GRANT2165GRANT2166GRANT2167GRANT2168GRANT2169GRANT2170GRANT2171DO2172WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2173DETAIL: "supautils" is now a reserved prefix.2174NOTICE: empty string is not a valid password, clearing password2175ALTER ROLE2176WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2177DETAIL: "supautils" is now a reserved prefix.2178CREATE ROLE2179REVOKE2180CREATE SCHEMA2181CREATE FUNCTION2182REVOKE2183GRANT2184WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2185DETAIL: "supautils" is now a reserved prefix.2186psql:/nix/store/0s4wf39csywl7iy2bchhiaqzcinrk17w-stat-extension:1: NOTICE: schema "extensions" already exists, skipping2187CREATE SCHEMA2188CREATE EXTENSION2189Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/10000000000000_demote-postgres.sql2190WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2191DETAIL: "supautils" is now a reserved prefix.2192GRANT2193GRANT2194GRANT2195GRANT2196GRANT2197GRANT2198GRANT2199GRANT2200GRANT2201DO2202ALTER ROLE2203Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20211115181400_update-auth-permissions.sql2204WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2205DETAIL: "supautils" is now a reserved prefix.2206GRANT2207GRANT2208GRANT2209ALTER TABLE2210ALTER TABLE2211ALTER TABLE2212ALTER TABLE2213ALTER TABLE2214GRANT2215GRANT2216GRANT2217GRANT2218ALTER DEFAULT PRIVILEGES2219ALTER DEFAULT PRIVILEGES2220ALTER DEFAULT PRIVILEGES2221Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20211118015519_create-realtime-schema.sql2222WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2223DETAIL: "supautils" is now a reserved prefix.2224CREATE SCHEMA2225Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20211122051245_update-realtime-permissions.sql2226WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2227DETAIL: "supautils" is now a reserved prefix.2228GRANT2229GRANT2230GRANT2231GRANT2232Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20211124212715_update-auth-owner.sql2233WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2234DETAIL: "supautils" is now a reserved prefix.2235DO2236DO2237DO2238Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20211130151719_update-realtime-permissions.sql2239WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2240DETAIL: "supautils" is now a reserved prefix.2241ALTER DEFAULT PRIVILEGES2242ALTER DEFAULT PRIVILEGES2243ALTER DEFAULT PRIVILEGES2244Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220118070449_enable-safeupdate-postgrest.sql2245WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2246DETAIL: "supautils" is now a reserved prefix.2247ALTER ROLE2248Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220126121436_finer-postgrest-triggers.sql2249WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2250DETAIL: "supautils" is now a reserved prefix.2251psql:/nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220126121436_finer-postgrest-triggers.sql:3: NOTICE: event trigger "api_restart" does not exist, skipping2252DROP EVENT TRIGGER2253psql:/nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220126121436_finer-postgrest-triggers.sql:4: NOTICE: function extensions.notify_api_restart() does not exist, skipping2254DROP FUNCTION2255CREATE FUNCTION2256CREATE FUNCTION2257psql:/nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220126121436_finer-postgrest-triggers.sql:59: NOTICE: event trigger "pgrst_ddl_watch" does not exist, skipping2258DROP EVENT TRIGGER2259CREATE EVENT TRIGGER2260psql:/nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220126121436_finer-postgrest-triggers.sql:64: NOTICE: event trigger "pgrst_drop_watch" does not exist, skipping2261DROP EVENT TRIGGER2262CREATE EVENT TRIGGER2263Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220224211803_fix-postgrest-supautils.sql2264WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2265DETAIL: "supautils" is now a reserved prefix.2266DO2267Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220317095840_pg_graphql.sql2268WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2269DETAIL: "supautils" is now a reserved prefix.2270CREATE SCHEMA2271psql:/nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220317095840_pg_graphql.sql:5: NOTICE: function graphql_public.graphql(text,text,jsonb) does not exist, skipping2272DROP FUNCTION2273CREATE FUNCTION2274GRANT2275ALTER DEFAULT PRIVILEGES2276ALTER DEFAULT PRIVILEGES2277ALTER DEFAULT PRIVILEGES2278ALTER DEFAULT PRIVILEGES2279ALTER DEFAULT PRIVILEGES2280ALTER DEFAULT PRIVILEGES2281CREATE FUNCTION2282psql:/nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220317095840_pg_graphql.sql:90: NOTICE: event trigger "issue_pg_graphql_access" does not exist, skipping2283DROP EVENT TRIGGER2284CREATE EVENT TRIGGER2285COMMENT2286CREATE FUNCTION2287psql:/nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220317095840_pg_graphql.sql:143: NOTICE: event trigger "issue_graphql_placeholder" does not exist, skipping2288DROP EVENT TRIGGER2289CREATE EVENT TRIGGER2290COMMENT2291Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220321174452_fix-postgrest-alter-type-event-trigger.sql2292WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2293DETAIL: "supautils" is now a reserved prefix.2294psql:/nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220321174452_fix-postgrest-alter-type-event-trigger.sql:3: NOTICE: event trigger "api_restart" does not exist, skipping2295DROP EVENT TRIGGER2296psql:/nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220321174452_fix-postgrest-alter-type-event-trigger.sql:4: NOTICE: function extensions.notify_api_restart() does not exist, skipping2297DROP FUNCTION2298CREATE FUNCTION2299CREATE FUNCTION2300DROP EVENT TRIGGER2301CREATE EVENT TRIGGER2302DROP EVENT TRIGGER2303CREATE EVENT TRIGGER2304Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220322085208_gotrue-session-limit.sql2305WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2306DETAIL: "supautils" is now a reserved prefix.2307ALTER ROLE2308Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220404205710_pg_graphql-on-by-default.sql2309WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2310DETAIL: "supautils" is now a reserved prefix.2311CREATE FUNCTION2312CREATE FUNCTION2313CREATE FUNCTION2314psql:/nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220404205710_pg_graphql-on-by-default.sql:142: NOTICE: extension "pg_graphql" does not exist, skipping2315DROP EXTENSION2316DO2317Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220609081115_grant-supabase-auth-admin-and-supabase-storage-admin-to-postgres.sql2318WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2319DETAIL: "supautils" is now a reserved prefix.2320GRANT ROLE2321Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220613123923_pg_graphql-pg-dump-perms.sql2322WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2323DETAIL: "supautils" is now a reserved prefix.2324CREATE FUNCTION2325DROP EXTENSION2326DO2327Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220713082019_pg_cron-pg_net-temp-perms-fix.sql2328WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2329DETAIL: "supautils" is now a reserved prefix.2330DO2331DO2332Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20221028101028_set_authenticator_timeout.sql2333WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2334DETAIL: "supautils" is now a reserved prefix.2335ALTER ROLE2336Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20221103090837_revoke_admin.sql2337WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2338DETAIL: "supautils" is now a reserved prefix.2339REVOKE ROLE2340Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20221207154255_create_pgsodium_and_vault.sql2341WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2342DETAIL: "supautils" is now a reserved prefix.2343DO2344Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20230201083204_grant_auth_roles_to_postgres.sql2345WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2346DETAIL: "supautils" is now a reserved prefix.2347GRANT ROLE2348Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20230224042246_grant_extensions_perms_for_postgres.sql2349WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2350DETAIL: "supautils" is now a reserved prefix.2351GRANT2352GRANT2353GRANT2354ALTER DEFAULT PRIVILEGES2355ALTER DEFAULT PRIVILEGES2356ALTER DEFAULT PRIVILEGES2357Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20230306081037_grant_pg_monitor_to_postgres.sql2358WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2359DETAIL: "supautils" is now a reserved prefix.2360GRANT ROLE2361Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20230327032006_grant_auth_roles_to_supabase_storage_admin.sql2362WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2363DETAIL: "supautils" is now a reserved prefix.2364GRANT ROLE2365Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20230529180330_alter_api_roles_for_inherit.sql2366WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2367DETAIL: "supautils" is now a reserved prefix.2368ALTER ROLE2369ALTER ROLE2370ALTER ROLE2371DO2372Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20231013070755_grant_authenticator_to_supabase_storage_admin.sql2373WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2374DETAIL: "supautils" is now a reserved prefix.2375GRANT ROLE2376REVOKE ROLE2377Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20231017062225_grant_pg_graphql_permissions_for_custom_roles.sql2378WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2379DETAIL: "supautils" is now a reserved prefix.2380CREATE FUNCTION2381DROP EXTENSION2382DO2383Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20231020085357_revoke_writes_on_cron_job_from_postgres.sql2384WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2385DETAIL: "supautils" is now a reserved prefix.2386DO2387CREATE FUNCTION2388DROP EVENT TRIGGER2389ALTER FUNCTION2390CREATE EVENT TRIGGER2391Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20231130133139_set_lock_timeout_to_authenticator_role.sql2392WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2393DETAIL: "supautils" is now a reserved prefix.2394ALTER ROLE2395Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20240124080435_alter_lo_export_lo_import_owner.sql2396WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2397DETAIL: "supautils" is now a reserved prefix.2398ALTER FUNCTION2399ALTER FUNCTION2400ALTER FUNCTION2401Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20240606060239_grant_predefined_roles_to_postgres.sql2402WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2403DETAIL: "supautils" is now a reserved prefix.2404GRANT ROLE2405Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20241031003909_create_orioledb.sql2406WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2407DETAIL: "supautils" is now a reserved prefix.2408DO2409Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20241215003910_backfill_pgmq_metadata.sql2410WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2411DETAIL: "supautils" is now a reserved prefix.2412DO2413DO2414Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20250205060043_disable_log_statement_on_internal_roles.sql2415WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2416DETAIL: "supautils" is now a reserved prefix.2417ALTER ROLE2418ALTER ROLE2419ALTER ROLE2420Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20250205144616_move_orioledb_to_extensions_schema.sql2421WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2422DETAIL: "supautils" is now a reserved prefix.2423DO2424Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20250218031949_pgsodium_mask_role.sql2425WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2426DETAIL: "supautils" is now a reserved prefix.2427DO2428Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20250220051611_pg_net_perms_fix.sql2429WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2430DETAIL: "supautils" is now a reserved prefix.2431CREATE FUNCTION2432DO2433Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20250312095419_pgbouncer_ownership.sql2434WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2435DETAIL: "supautils" is now a reserved prefix.2436ALTER FUNCTION2437GRANT2438Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20250402065937_alter_internal_event_triggers_owner_to_supabase_admin.sql2439WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2440DETAIL: "supautils" is now a reserved prefix.2441DROP EVENT TRIGGER2442ALTER FUNCTION2443CREATE EVENT TRIGGER2444Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20250402093753_grant_subscription_to_postgres_16_and_above.sql2445WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2446DETAIL: "supautils" is now a reserved prefix.2447DO2448Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20250417190610_update_pgbouncer_get_auth.sql2449WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2450DETAIL: "supautils" is now a reserved prefix.2451CREATE FUNCTION2452GRANT2453Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20250421084701_revoke_admin_roles_from_postgres.sql2454WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2455DETAIL: "supautils" is now a reserved prefix.2456REVOKE ROLE2457DO2458DO2459REVOKE ROLE2460REVOKE2461DO2462Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20250605172253_grant_with_admin_to_postgres_16_and_above.sql2463WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2464DETAIL: "supautils" is now a reserved prefix.2465DO2466Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20250623125453_tmp_grant_storage_tables_to_postgres_with_grant_option.sql2467WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2468DETAIL: "supautils" is now a reserved prefix.2469DO2470Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20250709135250_grant_storage_schema_to_postgres_with_grant_option.sql2471WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2472DETAIL: "supautils" is now a reserved prefix.2473DO2474Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20250710151649_supabase_read_only_user_default_transaction_read_only.sql2475WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2476DETAIL: "supautils" is now a reserved prefix.2477ALTER ROLE2478Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20251001204436_predefined_role_grants.sql2479WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2480DETAIL: "supautils" is now a reserved prefix.2481GRANT ROLE2482DO2483Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20251105172723_grant_pg_reload_conf_to_postgres.sql2484WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2485DETAIL: "supautils" is now a reserved prefix.2486GRANT2487Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20251121132723_correct_search_path_pgbouncer.sql2488WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2489DETAIL: "supautils" is now a reserved prefix.2490CREATE FUNCTION2491REVOKE2492REVOKE2493GRANT2494Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20260211120934_supabase_privileged_role.sql2495WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2496DETAIL: "supautils" is now a reserved prefix.2497DO2498Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20260413000000_fix-authenticator-session-preload-libraries.sql2499WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2500DETAIL: "supautils" is now a reserved prefix.2501ALTER ROLE2502Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20260421000000_pg_graphql-off-by-default.sql2503WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2504DETAIL: "supautils" is now a reserved prefix.2505DROP EXTENSION2506Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20260421000001_rescope_pg_graphql_access_trigger.sql2507WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2508DETAIL: "supautils" is now a reserved prefix.2509CREATE FUNCTION2510DROP EVENT TRIGGER2511CREATE EVENT TRIGGER2512Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20260730000000_revoke_trigger_on_cron_tables_from_postgres.sql2513WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2514DETAIL: "supautils" is now a reserved prefix.2515DO2516CREATE FUNCTION2517Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20260923021047_update_pgrst_watch_triggers.sql2518WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2519DETAIL: "supautils" is now a reserved prefix.2520CREATE FUNCTION2521CREATE FUNCTION2522Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20261016000001_search_path_for_supa_functions.sql2523WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2524DETAIL: "supautils" is now a reserved prefix.2525CREATE FUNCTION2526CREATE FUNCTION2527CREATE FUNCTION2528CREATE FUNCTION2529CREATE FUNCTION2530CREATE FUNCTION2531WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2532DETAIL: "supautils" is now a reserved prefix.2533ALTER DATABASE2534ALTER DATABASE2535ALTER ROLE2536ALTER ROLE2537ALTER ROLE2538ALTER ROLE2539ALTER ROLE2540ALTER ROLE2541ALTER ROLE2542ALTER ROLE2543ALTER ROLE2544ALTER ROLE2545Shutting down PostgreSQL...2546PostgreSQL is running in daemon mode. Please stop it using pg_ctl.2547pg_ctl: another server might be running; trying to start server anyway2548waiting for server to start.... stopped waiting2549pg_ctl: could not start server2550Examine the log output.2551pg_ctl: server is running (PID: 1213)2552/nix/store/0kc57vrr3jdbz3jqh7q142rdxndjs2b6-postgresql-and-plugins-17.11/bin/postgres "-D" "/build/tmp.t4uSscoz79" "--config-file=/build/tmp.t4uSscoz79/postgresql.conf" "-p" "5541" "-k" "/build/tmp.t4uSscoz79/tmp"2553$ pg_isready -h localhost -p 5541 -U supabase_admin -q25542026-10-27 10:47:51 [INFO] PostgreSQL is ready25552026-10-27 10:47:51 [INFO] CLI variant detected - loading CLI prime SQL file2556$ psql -p 5541 -h localhost --no-password --username=supabase_admin -d postgres -v ON_ERROR_STOP=1 -Xf /nix/store/ib75j74vyc0w374jcz7mqcg6njf21yx3-prime-cli.sql2557WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2558DETAIL: "supautils" is now a reserved prefix.2559SET2560CREATE EXTENSION2561CREATE EXTENSION2562CREATE EXTENSION2563CREATE EXTENSION25642026-10-27 10:47:51 [INFO] Creating test_config table for pg_regress tests2565$ psql -p 5541 -h localhost --no-password --username=supabase_admin -d postgres -c 2566 CREATE TABLE IF NOT EXISTS test_config (key TEXT PRIMARY KEY, value TEXT);2567 INSERT INTO test_config (key, value) VALUES ('http_mock_port', '8880')2568 ON CONFLICT (key) DO UPDATE SET value = EXCLUDED.value;2569 INSERT INTO test_config (key, value) VALUES ('http_mock_host', 'localhost')2570 ON CONFLICT (key) DO UPDATE SET value = EXCLUDED.value;25712572WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it2573DETAIL: "supautils" is now a reserved prefix.2574CREATE TABLE2575INSERT 0 12576INSERT 0 125772026-10-27 10:47:51 [INFO] CLI variant detected - running subset of pg_regress tests (38 tests)2578$ pg_regress --use-existing --dbname=postgres --inputdir=/nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests --outputdir=/nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output --host=localhost --port=5541 --user=supabase_admin auth create_statistics_priv dblink docs-array-test docs-cascades-deletes docs-connections docs-enums docs-full-text-search docs-functions docs-indexes docs-json docs-partitioning docs-tables-and-data docs-triggers docs-webhooks enable_tracking event_trigger_search_path intarray_ltree_query ltree_label_overflow multirange_create_priv operator_breaking_change pg-safeupdate pg_graphql pg_net pg_plan_filter pgaudit pgbouncer pgcrypto_cipher_matrix pgsodium realtime replica_identity_upsert storage supautils_reserved_roles supautils_warehouse_writer vault wal2json z_17_intarray_ltree_query z_17_wal_summarize2579(using postmaster on localhost, port 5541)2580============== running regression test queries ==============2581test auth ... FAILED 19 ms2582test create_statistics_priv ... FAILED 17 ms2583test dblink ... FAILED 64 ms2584test docs-array-test ... FAILED 19 ms2585test docs-cascades-deletes ... FAILED 149 ms2586test docs-connections ... FAILED 12 ms2587test docs-enums ... FAILED 64 ms2588test docs-full-text-search ... FAILED 41 ms2589test docs-functions ... FAILED 96 ms2590test docs-indexes ... FAILED 53 ms2591test docs-json ... FAILED 20 ms2592test docs-partitioning ... FAILED 52 ms2593test docs-tables-and-data ... FAILED 182 ms2594test docs-triggers ... FAILED 124 ms2595test docs-webhooks ... FAILED 90 ms2596test enable_tracking ... FAILED 13 ms2597test event_trigger_search_path ... FAILED 13 ms2598test intarray_ltree_query ... FAILED 107 ms2599test ltree_label_overflow ... FAILED 70 ms2600test multirange_create_priv ... FAILED 15 ms2601test operator_breaking_change ... FAILED 45 ms2602test pg-safeupdate ... FAILED 20 ms2603test pg_graphql ... FAILED 86 ms2604test pg_net ... FAILED 13 ms2605test pg_plan_filter ... FAILED 16 ms2606test pgaudit ... FAILED 329 ms2607test pgbouncer ... FAILED 33 ms2608test pgcrypto_cipher_matrix ... FAILED 31 ms2609test pgsodium ... FAILED 15 ms2610test realtime ... FAILED 11 ms2611test replica_identity_upsert ... FAILED 17 ms2612test storage ... FAILED 28 ms2613test supautils_reserved_roles ... FAILED 11 ms2614test supautils_warehouse_writer ... FAILED 16 ms2615test vault ... FAILED 59 ms2616test wal2json ... FAILED 61 ms2617test z_17_intarray_ltree_query ... FAILED 71 ms2618test z_17_wal_summarize ... FAILED 12 ms26192620========================2621 38 of 38 tests failed. 2622========================26232624The differences that caused some tests to fail can be viewed in the2625file "/nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/regression.diffs". A copy of the test summary that you see2626above is saved in the file "/nix/store/3r0k3am2cgbx3jrayjv3pk88l82daasd-run-check-harness-psql-17-cli/regression_output/regression.out".262726282026-10-27 10:47:53 [ERROR] pg_regress tests failed26292026-10-27 10:47:53 [ERROR] An error occurred. Exit code: 126302026-10-27 10:47:53 [ERROR] Debug logs: