2026-10-27 10:50:23 [INFO] Starting HTTP mock server (will find free port)... 2026-10-27 10:50:24 [INFO] HTTP mock server started on port 8880 2026-10-27 10:50:24 [INFO] Creating temporary PostgreSQL cluster at /build/tmp.60Ct7RqRoJ 2026-10-27 10:50:25 [INFO] Generated preload libraries: pg_cron, pg_net, pgsodium, supabase_vault 2026-10-27 10:50:25 [INFO] Checking shared_preload_libraries setting: 2026-10-27 10:50:25 [INFO] 721:shared_preload_libraries = 'pg_cron, pg_net, pgsodium, supabase_vault' # (change requires restart) 2026-10-27 10:50:25 [INFO] Configuring local auth 2026-10-27 10:50:25 [INFO] Waiting for PostgreSQL to be ready... 2026-10-27 10:50:25 [INFO] PostgreSQL is ready 2026-10-27 10:50:25 [INFO] Creating test database 2026-10-27 10:50:25 [INFO] CLI variant detected - loading CLI prime SQL file 2026-10-27 10:50:25 [INFO] Creating test_config table 2026-10-27 10:50:25 [INFO] Running pgtap test: auth.sql 2026-10-27 10:50:25 [INFO] Running pgtap test: create_statistics_priv.sql 2026-10-27 10:50:25 [INFO] Running pgtap test: dblink.sql 2026-10-27 10:50:25 [INFO] Running pgtap test: docs-array-test.sql 2026-10-27 10:50:25 [INFO] Running pgtap test: docs-cascades-deletes.sql 2026-10-27 10:50:25 [INFO] Running pgtap test: docs-connections.sql 2026-10-27 10:50:25 [INFO] Running pgtap test: docs-enums.sql 2026-10-27 10:50:25 [INFO] Running pgtap test: docs-full-text-search.sql 2026-10-27 10:50:26 [INFO] Running pgtap test: docs-functions.sql 2026-10-27 10:50:26 [INFO] Running pgtap test: docs-indexes.sql 2026-10-27 10:50:26 [INFO] Running pgtap test: docs-json.sql 2026-10-27 10:50:26 [INFO] Running pgtap test: docs-partitioning.sql 2026-10-27 10:50:26 [INFO] Running pgtap test: docs-tables-and-data.sql 2026-10-27 10:50:26 [INFO] Running pgtap test: docs-triggers.sql 2026-10-27 10:50:26 [INFO] Running pgtap test: docs-webhooks.sql 2026-10-27 10:50:26 [INFO] Running pgtap test: enable_tracking.sql 2026-10-27 10:50:26 [INFO] Running pgtap test: event_trigger_search_path.sql 2026-10-27 10:50:26 [INFO] Running pgtap test: intarray_ltree_query.sql 2026-10-27 10:50:26 [INFO] Running pgtap test: ltree_label_overflow.sql 2026-10-27 10:50:26 [INFO] Running pgtap test: multirange_create_priv.sql 2026-10-27 10:50:26 [INFO] Running pgtap test: operator_breaking_change.sql 2026-10-27 10:50:26 [INFO] Running pgtap test: pg-safeupdate.sql 2026-10-27 10:50:26 [INFO] Running pgtap test: pg_graphql.sql 2026-10-27 10:50:26 [INFO] Running pgtap test: pg_net.sql 2026-10-27 10:50:26 [INFO] Running pgtap test: pg_plan_filter.sql 2026-10-27 10:50:26 [INFO] Running pgtap test: pgaudit.sql 2026-10-27 10:50:26 [INFO] Running pgtap test: pgbouncer.sql 2026-10-27 10:50:26 [INFO] Running pgtap test: pgcrypto_cipher_matrix.sql 2026-10-27 10:50:27 [INFO] Running pgtap test: pgsodium.sql 2026-10-27 10:50:27 [INFO] Running pgtap test: realtime.sql 2026-10-27 10:50:27 [INFO] Running pgtap test: replica_identity_upsert.sql 2026-10-27 10:50:27 [INFO] Running pgtap test: storage.sql 2026-10-27 10:50:27 [INFO] Running pgtap test: supautils_reserved_roles.sql 2026-10-27 10:50:27 [INFO] Running pgtap test: supautils_warehouse_writer.sql 2026-10-27 10:50:27 [INFO] Running pgtap test: vault.sql 2026-10-27 10:50:27 [INFO] Running pgtap test: wal2json.sql 2026-10-27 10:50:27 [INFO] Running pgtap test: z_17_intarray_ltree_query.sql 2026-10-27 10:50:27 [INFO] Running pgtap test: z_17_wal_summarize.sql 2026-10-27 10:50:27 [INFO] Starting PostgreSQL server for pg_regress tests 2026-10-27 10:50:31 [INFO] PostgreSQL is ready 2026-10-27 10:50:31 [INFO] CLI variant detected - loading CLI prime SQL file 2026-10-27 10:50:31 [INFO] Creating test_config table for pg_regress tests 2026-10-27 10:50:31 [INFO] CLI variant detected - running subset of pg_regress tests (38 tests) 2026-10-27 10:50:32 [ERROR] pg_regress tests failed diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/auth.out /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/auth.out --- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/auth.out 1970-01-01 00:00:01.000000000 +0000 +++ /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/auth.out 2026-10-27 10:50:31.191236838 +0000 @@ -1,3 +1,5 @@ +WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it +DETAIL: "supautils" is now a reserved prefix. -- auth schema owner select n.nspname as schema_name, diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/create_statistics_priv.out /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/create_statistics_priv.out --- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/create_statistics_priv.out 1970-01-01 00:00:01.000000000 +0000 +++ /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/create_statistics_priv.out 2026-10-27 10:50:31.203236867 +0000 @@ -1,3 +1,5 @@ +WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it +DETAIL: "supautils" is now a reserved prefix. -- CVE-2025-12817: CREATE STATISTICS did not check CREATE privilege on the -- schema where the statistics object is created, letting a table owner create -- statistics objects in any schema (naming-conflict / privilege concern). diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/dblink.out /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/dblink.out --- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/dblink.out 1970-01-01 00:00:01.000000000 +0000 +++ /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/dblink.out 2026-10-27 10:50:31.227236926 +0000 @@ -1,3 +1,5 @@ +WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it +DETAIL: "supautils" is now a reserved prefix. -- The following test verifies that creating pg_proc in pg_temp doesn't shadow -- the real catalog table tricking the dblink/after-create.sql script to skip -- revoking the grants from all roles except supabase_admin, which would have diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-array-test.out /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/docs-array-test.out --- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-array-test.out 1970-01-01 00:00:01.000000000 +0000 +++ /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/docs-array-test.out 2026-10-27 10:50:31.246236972 +0000 @@ -1,3 +1,5 @@ +WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it +DETAIL: "supautils" is now a reserved prefix. -- testing sql found in https://supabase.com/docs/guides/database/arrays create table arraytest ( id integer not null, diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-cascades-deletes.out /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/docs-cascades-deletes.out --- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-cascades-deletes.out 1970-01-01 00:00:01.000000000 +0000 +++ /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/docs-cascades-deletes.out 2026-10-27 10:50:31.297237097 +0000 @@ -1,3 +1,5 @@ +WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it +DETAIL: "supautils" is now a reserved prefix. -- testing sql found in https://supabase.com/docs/guides/database/postgres/cascades-deletes -- all of the errors produced by this file are expected create table grandparent ( diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-connections.out /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/docs-connections.out --- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-connections.out 1970-01-01 00:00:01.000000000 +0000 +++ /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/docs-connections.out 2026-10-27 10:50:31.309237127 +0000 @@ -1,3 +1,5 @@ +WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it +DETAIL: "supautils" is now a reserved prefix. -- testing sql found in https://supabase.com/docs/guides/database/connection-management -- we can't test every sql statement in this doc because their results won't be deterministic select diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-enums.out /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/docs-enums.out --- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-enums.out 1970-01-01 00:00:01.000000000 +0000 +++ /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/docs-enums.out 2026-10-27 10:50:31.331237181 +0000 @@ -1,3 +1,5 @@ +WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it +DETAIL: "supautils" is now a reserved prefix. -- testing sql found in https://supabase.com/docs/guides/database/postgresenums create type mood as enum ( 'happy', diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-full-text-search.out /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/docs-full-text-search.out --- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-full-text-search.out 1970-01-01 00:00:01.000000000 +0000 +++ /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/docs-full-text-search.out 2026-10-27 10:50:31.353237235 +0000 @@ -1,3 +1,5 @@ +WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it +DETAIL: "supautils" is now a reserved prefix. -- testing sql found in https://supabase.com/docs/guides/database/full-text-search create table books ( id serial primary key, diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-functions.out /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/docs-functions.out --- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-functions.out 1970-01-01 00:00:01.000000000 +0000 +++ /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/docs-functions.out 2026-10-27 10:50:31.382237306 +0000 @@ -1,3 +1,5 @@ +WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it +DETAIL: "supautils" is now a reserved prefix. -- testing sql found in https://supabase.com/docs/guides/database/functions create or replace function hello_world() returns text diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-indexes.out /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/docs-indexes.out --- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-indexes.out 1970-01-01 00:00:01.000000000 +0000 +++ /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/docs-indexes.out 2026-10-27 10:50:31.401237352 +0000 @@ -1,3 +1,5 @@ +WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it +DETAIL: "supautils" is now a reserved prefix. -- testing sql found in https://supabase.com/docs/guides/database/indexes create table persons ( id bigint generated by default as identity primary key, diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-json.out /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/docs-json.out --- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-json.out 1970-01-01 00:00:01.000000000 +0000 +++ /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/docs-json.out 2026-10-27 10:50:31.414237384 +0000 @@ -1,3 +1,5 @@ +WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it +DETAIL: "supautils" is now a reserved prefix. -- testing sql found in https://supabase.com/docs/guides/database/json create table books ( id serial primary key, diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-partitioning.out /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/docs-partitioning.out --- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-partitioning.out 1970-01-01 00:00:01.000000000 +0000 +++ /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/docs-partitioning.out 2026-10-27 10:50:31.437721102 +0000 @@ -1,3 +1,5 @@ +WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it +DETAIL: "supautils" is now a reserved prefix. -- testing sql found in https://supabase.com/docs/guides/database/partitioning create table sales ( id bigint generated by default as identity, diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-tables-and-data.out /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/docs-tables-and-data.out --- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-tables-and-data.out 1970-01-01 00:00:01.000000000 +0000 +++ /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/docs-tables-and-data.out 2026-10-27 10:50:31.501237597 +0000 @@ -1,3 +1,5 @@ +WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it +DETAIL: "supautils" is now a reserved prefix. -- Test file for "Tables and Data" documentation -- This file contains all SQL statements from https://supabase.com/docs/guides/database/tables-and-data create table movies ( diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-triggers.out /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/docs-triggers.out --- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-triggers.out 1970-01-01 00:00:01.000000000 +0000 +++ /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/docs-triggers.out 2026-10-27 10:50:31.537237686 +0000 @@ -1,3 +1,5 @@ +WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it +DETAIL: "supautils" is now a reserved prefix. -- testing sql found in https://supabase.com/docs/guides/database/postgres/triggers create table employees ( id serial primary key, diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-webhooks.out /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/docs-webhooks.out --- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/docs-webhooks.out 1970-01-01 00:00:01.000000000 +0000 +++ /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/docs-webhooks.out 2026-10-27 10:50:31.569237764 +0000 @@ -1,3 +1,5 @@ +WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it +DETAIL: "supautils" is now a reserved prefix. -- testing sql found in https://supabase.com/docs/guides/database/webhooks create table profiles ( id serial primary key, diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/enable_tracking.out /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/enable_tracking.out --- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/enable_tracking.out 1970-01-01 00:00:01.000000000 +0000 +++ /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/enable_tracking.out 2026-10-27 10:50:31.579551755 +0000 @@ -1,3 +1,5 @@ +WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it +DETAIL: "supautils" is now a reserved prefix. alter role postgres set track_functions = 'pl'; alter role postgres set track_io_timing = on; alter role postgres reset track_functions; diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/event_trigger_search_path.out /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/event_trigger_search_path.out --- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/event_trigger_search_path.out 1970-01-01 00:00:01.000000000 +0000 +++ /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/event_trigger_search_path.out 2026-10-27 10:50:31.589415320 +0000 @@ -1,3 +1,5 @@ +WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it +DETAIL: "supautils" is now a reserved prefix. -- Regression test: every Supabase-owned event trigger function must pin search_path. -- -- Event triggers fire as superuser on DDL run by any role, so an event trigger function diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/intarray_ltree_query.out /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/intarray_ltree_query.out --- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/intarray_ltree_query.out 1970-01-01 00:00:01.000000000 +0000 +++ /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/intarray_ltree_query.out 2026-10-27 10:50:31.655237975 +0000 @@ -1,3 +1,5 @@ +WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it +DETAIL: "supautils" is now a reserved prefix. -- CVE-2026-6473 -- -- Overflow of the internal "left" / length / variant-count fields used diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/ltree_label_overflow.out /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/ltree_label_overflow.out --- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/ltree_label_overflow.out 1970-01-01 00:00:01.000000000 +0000 +++ /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/ltree_label_overflow.out 2026-10-27 10:50:31.705238097 +0000 @@ -1,3 +1,5 @@ +WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it +DETAIL: "supautils" is now a reserved prefix. -- contrib/ltree: an integer overflow in ltree_compare() made comparisons return -- the wrong sign once two values differed in depth by more than ~14,653 labels. -- A btree index over such values could therefore be built in the wrong order and diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/multirange_create_priv.out /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/multirange_create_priv.out --- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/multirange_create_priv.out 1970-01-01 00:00:01.000000000 +0000 +++ /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/multirange_create_priv.out 2026-10-27 10:50:31.718238129 +0000 @@ -1,3 +1,5 @@ +WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it +DETAIL: "supautils" is now a reserved prefix. -- CVE-2026-6472: CREATE TYPE ... AS RANGE auto-creates a companion multirange -- type. When the multirange type name was given EXPLICITLY, the schema CREATE -- privilege for that name was not validated (the auto-generated-name path was diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/operator_breaking_change.out /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/operator_breaking_change.out --- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/operator_breaking_change.out 1970-01-01 00:00:01.000000000 +0000 +++ /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/operator_breaking_change.out 2026-10-27 10:50:31.747238200 +0000 @@ -1,3 +1,5 @@ +WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it +DETAIL: "supautils" is now a reserved prefix. -- Pin CVE-2026-2004 behaviour: attaching a non-built-in selectivity estimator -- to an operator requires superuser. Verified against both RESTRICT and JOIN. -- diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/pg-safeupdate.out /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/pg-safeupdate.out --- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/pg-safeupdate.out 1970-01-01 00:00:01.000000000 +0000 +++ /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/pg-safeupdate.out 2026-10-27 10:50:31.759238230 +0000 @@ -1,3 +1,5 @@ +WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it +DETAIL: "supautils" is now a reserved prefix. load 'safeupdate'; set safeupdate.enabled=1; create schema v; diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/pg_graphql.out /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/pg_graphql.out --- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/pg_graphql.out 1970-01-01 00:00:01.000000000 +0000 +++ /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/pg_graphql.out 2026-10-27 10:50:31.816238369 +0000 @@ -1,3 +1,5 @@ +WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it +DETAIL: "supautils" is now a reserved prefix. begin; comment on schema public is '@graphql({"inflect_names": true})'; create table account( diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/pg_net.out /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/pg_net.out --- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/pg_net.out 1970-01-01 00:00:01.000000000 +0000 +++ /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/pg_net.out 2026-10-27 10:50:31.826238394 +0000 @@ -1,3 +1,5 @@ +WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it +DETAIL: "supautils" is now a reserved prefix. -- This is a very basic test because you can't get the value returned -- by a pg_net request in the same transaction that created it; select diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/pg_plan_filter.out /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/pg_plan_filter.out --- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/pg_plan_filter.out 1970-01-01 00:00:01.000000000 +0000 +++ /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/pg_plan_filter.out 2026-10-27 10:50:31.839238426 +0000 @@ -1,3 +1,5 @@ +WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it +DETAIL: "supautils" is now a reserved prefix. begin; load 'plan_filter'; create schema v; diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/pgaudit.out /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/pgaudit.out --- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/pgaudit.out 1970-01-01 00:00:01.000000000 +0000 +++ /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/pgaudit.out 2026-10-27 10:50:31.852238457 +0000 @@ -1,3 +1,5 @@ +WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it +DETAIL: "supautils" is now a reserved prefix. -- Note: there is no test that the logs were correctly output. Only checking for exceptions set pgaudit.log = 'write, ddl'; set pgaudit.log_relation = on; diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/pgbouncer.out /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/pgbouncer.out --- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/pgbouncer.out 1970-01-01 00:00:01.000000000 +0000 +++ /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/pgbouncer.out 2026-10-27 10:50:31.871238504 +0000 @@ -1,3 +1,5 @@ +WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it +DETAIL: "supautils" is now a reserved prefix. -- pgbouncer schema owner select n.nspname as schema_name, diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/pgcrypto_cipher_matrix.out /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/pgcrypto_cipher_matrix.out --- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/pgcrypto_cipher_matrix.out 1970-01-01 00:00:01.000000000 +0000 +++ /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/pgcrypto_cipher_matrix.out 2026-10-27 10:50:31.894238560 +0000 @@ -1,3 +1,5 @@ +WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it +DETAIL: "supautils" is now a reserved prefix. -- CVE-2026-14663: pgcrypto's PGP functions previously did not detect when the -- requested cipher was unavailable in the server's OpenSSL build. Encryption -- then silently produced output that was not actually encrypted, and decryption diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/pgsodium.out /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/pgsodium.out --- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/pgsodium.out 1970-01-01 00:00:01.000000000 +0000 +++ /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/pgsodium.out 2026-10-27 10:50:31.904238585 +0000 @@ -1,3 +1,5 @@ +WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it +DETAIL: "supautils" is now a reserved prefix. select status from diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/realtime.out /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/realtime.out --- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/realtime.out 1970-01-01 00:00:01.000000000 +0000 +++ /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/realtime.out 2026-10-27 10:50:31.913227336 +0000 @@ -1,3 +1,5 @@ +WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it +DETAIL: "supautils" is now a reserved prefix. -- only a publication from supabase realtime is expected SELECT pubname AS publication_name, diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/replica_identity_upsert.out /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/replica_identity_upsert.out --- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/replica_identity_upsert.out 1970-01-01 00:00:01.000000000 +0000 +++ /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/replica_identity_upsert.out 2026-10-27 10:50:31.925238636 +0000 @@ -1,3 +1,5 @@ +WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it +DETAIL: "supautils" is now a reserved prefix. -- 17.7/15.15 tightened logical-replication checks: MERGE and -- INSERT ... ON CONFLICT DO UPDATE now also require a REPLICA IDENTITY when the -- target table is in a publication that publishes updates (previously these two diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/storage.out /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/storage.out --- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/storage.out 1970-01-01 00:00:01.000000000 +0000 +++ /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/storage.out 2026-10-27 10:50:31.939238671 +0000 @@ -1,3 +1,5 @@ +WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it +DETAIL: "supautils" is now a reserved prefix. -- storage schema owner select n.nspname as schema_name, diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/supautils_reserved_roles.out /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/supautils_reserved_roles.out --- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/supautils_reserved_roles.out 1970-01-01 00:00:01.000000000 +0000 +++ /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/supautils_reserved_roles.out 2026-10-27 10:50:31.949238695 +0000 @@ -1,3 +1,5 @@ +WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it +DETAIL: "supautils" is now a reserved prefix. -- verify non-superuser postgres role cannot drop supabase_privileged_role BEGIN; -- Switch to the postgres role (non-superuser) to test supautils behavior diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/supautils_warehouse_writer.out /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/supautils_warehouse_writer.out --- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/supautils_warehouse_writer.out 1970-01-01 00:00:01.000000000 +0000 +++ /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/supautils_warehouse_writer.out 2026-10-27 10:50:31.961238725 +0000 @@ -1,10 +1,12 @@ +WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it +DETAIL: "supautils" is now a reserved prefix. BEGIN; SELECT count(*) = 1 AS protection_registered FROM pg_settings WHERE name = 'supautils.reserved_role_members' AND context = 'sighup'; protection_registered ----------------------- - t + f (1 row) CREATE ROLE supabase_warehouse_writer NOLOGIN; @@ -14,11 +16,13 @@ SET ROLE postgres; SAVEPOINT denied; GRANT supabase_warehouse_writer_test TO postgres; -ERROR: "supabase_warehouse_writer_test" role memberships are reserved, only superusers can grant them +ERROR: permission denied to grant role "supabase_warehouse_writer_test" +DETAIL: Only roles with the ADMIN option on role "supabase_warehouse_writer_test" may grant this role. ROLLBACK TO SAVEPOINT denied; SAVEPOINT denied; GRANT warehouse_writer_test_login TO postgres; -ERROR: "warehouse_writer_test_login" role memberships are reserved, only superusers can grant them +ERROR: permission denied to grant role "warehouse_writer_test_login" +DETAIL: Only roles with the ADMIN option on role "warehouse_writer_test_login" may grant this role. ROLLBACK TO SAVEPOINT denied; SAVEPOINT denied; GRANT pg_write_all_data TO postgres; @@ -30,23 +34,26 @@ ROLLBACK TO SAVEPOINT denied; SAVEPOINT denied; ALTER ROLE supabase_warehouse_writer_test LOGIN; -ERROR: "supabase_warehouse_writer_test" is a reserved role, only superusers can modify it ROLLBACK TO SAVEPOINT denied; SAVEPOINT denied; COMMENT ON ROLE supabase_warehouse_writer_test IS 'forged'; -ERROR: "supabase_warehouse_writer_test" is a reserved role, only superusers can modify it +ERROR: permission denied +DETAIL: The current user must have the ADMIN option on role "supabase_warehouse_writer_test". ROLLBACK TO SAVEPOINT denied; SAVEPOINT denied; DROP ROLE supabase_warehouse_writer_test; -ERROR: "supabase_warehouse_writer_test" is a reserved role, only superusers can modify it +ERROR: permission denied to drop role +DETAIL: Only roles with the CREATEROLE attribute and the ADMIN option on role "supabase_warehouse_writer_test" may drop this role. ROLLBACK TO SAVEPOINT denied; SAVEPOINT denied; REVOKE supabase_warehouse_writer_test FROM warehouse_writer_test_login; -ERROR: "supabase_warehouse_writer_test" role memberships are reserved, only superusers can grant them +ERROR: permission denied to revoke role "supabase_warehouse_writer_test" +DETAIL: Only roles with the ADMIN option on role "supabase_warehouse_writer_test" may revoke this role. ROLLBACK TO SAVEPOINT denied; SAVEPOINT denied; REVOKE supabase_warehouse_writer FROM supabase_warehouse_writer_test; -ERROR: "supabase_warehouse_writer" role memberships are reserved, only superusers can grant them +ERROR: permission denied to revoke role "supabase_warehouse_writer" +DETAIL: Only roles with the ADMIN option on role "supabase_warehouse_writer" may revoke this role. ROLLBACK TO SAVEPOINT denied; RESET ROLE; REVOKE supabase_warehouse_writer_test FROM warehouse_writer_test_login; diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/vault.out /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/vault.out --- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/vault.out 1970-01-01 00:00:01.000000000 +0000 +++ /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/vault.out 2026-10-27 10:50:31.987238788 +0000 @@ -1,3 +1,5 @@ +WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it +DETAIL: "supautils" is now a reserved prefix. -- Tests role privileges on the vault objects -- INSERT and UPDATE privileges should not be present on the vault tables for postgres and service_role, only SELECT and DELETE WITH schema_obj AS ( diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/wal2json.out /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/wal2json.out --- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/wal2json.out 1970-01-01 00:00:01.000000000 +0000 +++ /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/wal2json.out 2026-10-27 10:50:32.004455022 +0000 @@ -1,3 +1,5 @@ +WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it +DETAIL: "supautils" is now a reserved prefix. create schema v; create table v.foo( id int primary key diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/z_17_intarray_ltree_query.out /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/z_17_intarray_ltree_query.out --- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/z_17_intarray_ltree_query.out 1970-01-01 00:00:01.000000000 +0000 +++ /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/z_17_intarray_ltree_query.out 2026-10-27 10:50:32.049238940 +0000 @@ -1,3 +1,5 @@ +WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it +DETAIL: "supautils" is now a reserved prefix. BEGIN; SET client_min_messages = warning; -- cli does not have ltree so does not show the already exists notice CREATE EXTENSION IF NOT EXISTS ltree; diff -U3 /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/z_17_wal_summarize.out /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/z_17_wal_summarize.out --- /nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests/expected/z_17_wal_summarize.out 1970-01-01 00:00:01.000000000 +0000 +++ /nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/results/z_17_wal_summarize.out 2026-10-27 10:50:32.058530311 +0000 @@ -1,3 +1,5 @@ +WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it +DETAIL: "supautils" is now a reserved prefix. SELECT (SELECT setting FROM pg_settings WHERE name = 'summarize_wal') = 'on' AS summarize_wal_default_ok; summarize_wal_default_ok -------------------------- 2026-10-27 10:50:32 [ERROR] An error occurred. Exit code: 1 2026-10-27 10:50:32 [ERROR] Debug logs: 2026-10-27 10:50:23 [INFO] Starting HTTP mock server (will find free port)... $ /nix/store/qzc04a3npl70cyyy6flnnrb2ig3kayxm-python3-3.13.11/bin/python3 /nix/store/sfl1mnhcw0ccky7m2crn0hda79clq4mk-http-mock-server.py 2026-10-27 10:50:24 [INFO] HTTP mock server started on port 8880 2026-10-27 10:50:24 [INFO] Creating temporary PostgreSQL cluster at /build/tmp.60Ct7RqRoJ $ initdb --locale=C --username=supabase_admin -D /build/tmp.60Ct7RqRoJ The files belonging to this database system will be owned by user "nixbld". This user must also own the server process. The database cluster will be initialized with locale "C". The default database encoding has accordingly been set to "SQL_ASCII". The default text search configuration will be set to "english". Data page checksums are disabled. fixing permissions on existing directory /build/tmp.60Ct7RqRoJ ... ok creating subdirectories ... ok selecting dynamic shared memory implementation ... posix selecting default "max_connections" ... 100 selecting default "shared_buffers" ... 128MB selecting default time zone ... UTC creating configuration files ... ok running bootstrap script ... ok performing post-bootstrap initialization ... ok syncing data to disk ... ok initdb: warning: enabling "trust" authentication for local connections initdb: 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. Success. You can now start the database server using: pg_ctl -D /build/tmp.60Ct7RqRoJ -l logfile start 2026-10-27 10:50:25 [INFO] Generated preload libraries: pg_cron, pg_net, pgsodium, supabase_vault 2026-10-27 10:50:25 [INFO] Checking shared_preload_libraries setting: 2026-10-27 10:50:25 [INFO] 721:shared_preload_libraries = 'pg_cron, pg_net, pgsodium, supabase_vault' # (change requires restart) 2026-10-27 10:50:25 [INFO] Configuring local auth $ pg_ctl -D /build/tmp.60Ct7RqRoJ -l /build/tmp.60Ct7RqRoJ/postgresql.log -o -k /build/tmp.60Ct7RqRoJ/sockets -p 5541 -d 5 start waiting for server to start.... done server started 2026-10-27 10:50:25 [INFO] Waiting for PostgreSQL to be ready... $ pg_isready -h localhost -p 5541 -U supabase_admin -q 2026-10-27 10:50:25 [INFO] PostgreSQL is ready 2026-10-27 10:50:25 [INFO] Creating test database $ createdb -p 5541 -h localhost --username=supabase_admin testing 2026-10-27 10:50:25 [INFO] CLI variant detected - loading CLI prime SQL file $ psql -p 5541 -h localhost --username=supabase_admin -d testing -v ON_ERROR_STOP=1 -Xf /nix/store/ib75j74vyc0w374jcz7mqcg6njf21yx3-prime-cli.sql SET CREATE EXTENSION CREATE EXTENSION CREATE EXTENSION CREATE EXTENSION 2026-10-27 10:50:25 [INFO] Creating test_config table $ psql -p 5541 -h localhost --username=supabase_admin -d testing -c CREATE TABLE IF NOT EXISTS test_config (key TEXT PRIMARY KEY, value TEXT); INSERT INTO test_config (key, value) VALUES ('http_mock_port', '8880') ON CONFLICT (key) DO UPDATE SET value = EXCLUDED.value; INSERT INTO test_config (key, value) VALUES ('http_mock_host', 'localhost') ON CONFLICT (key) DO UPDATE SET value = EXCLUDED.value; CREATE TABLE INSERT 0 1 INSERT 0 1 2026-10-27 10:50:25 [INFO] Running pgtap test: auth.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/auth.sql schema_name | owner -------------+------- (0 rows) schema_name | table_name | owner | rls_enabled | rls_policies -------------+------------+-------+-------------+-------------- (0 rows) schema_name | table_name | role_name | privilege_type | is_grantable -------------+------------+-----------+----------------+-------------- (0 rows) table_schema | table_name | index_name | index_owner --------------+------------+------------+------------- (0 rows) schema_name | function_name | owner -------------+---------------+------- (0 rows) psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/auth.sql:97: ERROR: relation "auth.schema_migrations" does not exist LINE 1: select * from auth.schema_migrations; ^ 2026-10-27 10:50:25 [INFO] Running pgtap test: create_statistics_priv.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/create_statistics_priv.sql BEGIN CREATE SCHEMA CREATE SCHEMA psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/create_statistics_priv.sql:15: ERROR: role "postgres" does not exist psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/create_statistics_priv.sql:17: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/create_statistics_priv.sql:20: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/create_statistics_priv.sql:21: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/create_statistics_priv.sql:24: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/create_statistics_priv.sql:27: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/create_statistics_priv.sql:28: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/create_statistics_priv.sql:29: ERROR: savepoint "no_priv" does not exist psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/create_statistics_priv.sql:31: ERROR: current transaction is aborted, commands ignored until end of transaction block ROLLBACK 2026-10-27 10:50:25 [INFO] Running pgtap test: dblink.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/dblink.sql SET DROP EXTENSION psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/dblink.sql:10: ERROR: role "postgres" does not exist CREATE TABLE CREATE EXTENSION DROP TABLE RESET function_name | grantee | privilege_type -----------------------------+----------------+---------------- dblink_connect_u(text) | supabase_admin | EXECUTE dblink_connect_u(text,text) | supabase_admin | EXECUTE (2 rows) psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/dblink.sql:28: ERROR: role "postgres" does not exist search_path ----------------- "$user", public (1 row) DROP EXTENSION CREATE EXTENSION 2026-10-27 10:50:25 [INFO] Running pgtap test: docs-array-test.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-array-test.sql CREATE TABLE INSERT 0 1 id | textarray ----+------------------- 1 | {Harry,Larry,Moe} (1 row) textarray | array_length -----------+-------------- Harry | 3 (1 row) DROP TABLE 2026-10-27 10:50:25 [INFO] Running pgtap test: docs-cascades-deletes.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-cascades-deletes.sql CREATE TABLE CREATE TABLE CREATE TABLE INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 count ------- 1 (1 row) count ------- 2 (1 row) count ------- 1 (1 row) psql:/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" DETAIL: Key (id)=(1) is still referenced from table "child". count ------- 1 (1 row) count ------- 2 (1 row) count ------- 1 (1 row) psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-cascades-deletes.sql:56: ERROR: duplicate key value violates unique constraint "grandparent_pkey" DETAIL: Key (id)=(1) already exists. psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-cascades-deletes.sql:61: ERROR: duplicate key value violates unique constraint "parent_pkey" DETAIL: Key (id)=(1) already exists. psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-cascades-deletes.sql:66: ERROR: duplicate key value violates unique constraint "parent_pkey" DETAIL: Key (id)=(2) already exists. psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-cascades-deletes.sql:71: ERROR: duplicate key value violates unique constraint "child_pkey" DETAIL: Key (id)=(1) already exists. ALTER TABLE ALTER TABLE psql:/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" DETAIL: Key (id)=(1) is still referenced from table "child". count ------- 1 (1 row) count ------- 2 (1 row) count ------- 1 (1 row) psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-cascades-deletes.sql:89: ERROR: duplicate key value violates unique constraint "grandparent_pkey" DETAIL: Key (id)=(1) already exists. psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-cascades-deletes.sql:94: ERROR: duplicate key value violates unique constraint "parent_pkey" DETAIL: Key (id)=(1) already exists. psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-cascades-deletes.sql:99: ERROR: duplicate key value violates unique constraint "parent_pkey" DETAIL: Key (id)=(2) already exists. psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-cascades-deletes.sql:104: ERROR: duplicate key value violates unique constraint "child_pkey" DETAIL: Key (id)=(1) already exists. ALTER TABLE ALTER TABLE psql:/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" DETAIL: Key (id)=(1) is still referenced from table "child". count ------- 1 (1 row) count ------- 2 (1 row) count ------- 1 (1 row) psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-cascades-deletes.sql:122: ERROR: duplicate key value violates unique constraint "grandparent_pkey" DETAIL: Key (id)=(1) already exists. psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-cascades-deletes.sql:127: ERROR: duplicate key value violates unique constraint "parent_pkey" DETAIL: Key (id)=(1) already exists. psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-cascades-deletes.sql:132: ERROR: duplicate key value violates unique constraint "parent_pkey" DETAIL: Key (id)=(2) already exists. psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-cascades-deletes.sql:137: ERROR: duplicate key value violates unique constraint "child_pkey" DETAIL: Key (id)=(1) already exists. ALTER TABLE UPDATE 1 DELETE 1 count ------- 0 (1 row) count ------- 0 (1 row) count ------- 0 (1 row) CREATE TABLE CREATE TABLE INSERT 0 1 INSERT 0 1 DELETE 1 count ------- 0 (1 row) count ------- 0 (1 row) CREATE TABLE CREATE TABLE INSERT 0 1 INSERT 0 1 psql:/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" DETAIL: Key (id)=(1) is still referenced from table "test_restrict_child". count ------- 1 (1 row) count ------- 1 (1 row) CREATE TABLE CREATE TABLE INSERT 0 1 INSERT 0 1 DELETE 1 count ------- 0 (1 row) count ------- 1 (1 row) parent_id ----------- (1 row) CREATE TABLE CREATE TABLE INSERT 0 1 INSERT 0 1 psql:/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" DETAIL: Key (parent_id)=(999) is not present in table "test_set_default". count ------- 1 (1 row) count ------- 1 (1 row) parent_id ----------- 1 (1 row) CREATE TABLE CREATE TABLE INSERT 0 1 INSERT 0 1 psql:/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" DETAIL: Key (id)=(1) is still referenced from table "test_no_action_child". count ------- 1 (1 row) count ------- 1 (1 row) DROP TABLE DROP TABLE DROP TABLE DROP TABLE DROP TABLE DROP TABLE DROP TABLE DROP TABLE DROP TABLE DROP TABLE DROP TABLE DROP TABLE DROP TABLE 2026-10-27 10:50:25 [INFO] Running pgtap test: docs-connections.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-connections.sql ssl | database | connected_role | application_name | query | state -----+----------+----------------+------------------+--------------------------------------------+-------- f | testing | supabase_admin | psql | select +| active | | | | ssl, +| | | | | datname as database, +| | | | | usename as connected_role, +| | | | | application_name, +| | | | | query, +| | | | | state +| | | | | from pg_stat_ssl +| | | | | join pg_stat_activity +| | | | | on pg_stat_ssl.pid = pg_stat_activity.pid; | (1 row) 2026-10-27 10:50:25 [INFO] Running pgtap test: docs-enums.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-enums.sql CREATE TYPE CREATE TABLE INSERT 0 1 INSERT 0 1 INSERT 0 1 id | name | current_mood ----+------+-------------- 2 | Bob | sad (1 row) id | name | current_mood ----+-------+-------------- 1 | Alice | happy (1 row) UPDATE 1 id | name | current_mood ----+-------+-------------- 1 | Alice | excited (1 row) ALTER TYPE INSERT 0 1 enum_range ---------------------------------- {happy,sad,excited,calm,content} (1 row) id | name | current_mood ----+-------+-------------- 4 | David | content (1 row) CREATE TYPE CREATE TABLE INSERT 0 3 id | order_number | status ----+--------------+-------- 1 | ORD-001 | active (1 row) UPDATE 1 id | order_number | status ----+--------------+---------- 2 | ORD-002 | inactive (1 row) ALTER TYPE INSERT 0 1 enum_range ------------------------------------- {active,inactive,pending,cancelled} (1 row) id | order_number | status ----+--------------+----------- 4 | ORD-004 | cancelled (1 row) CREATE TYPE CREATE TABLE INSERT 0 3 id | title | priority ----+----------------+---------- 3 | Security audit | critical (1 row) UPDATE 1 id | title | priority ----+-------------+---------- 2 | Update docs | medium (1 row) ALTER TYPE INSERT 0 1 enum_range ----------------------------------- {low,medium,high,critical,urgent} (1 row) id | title | priority ----+--------------------+---------- 4 | Server maintenance | urgent (1 row) DROP TABLE DROP TABLE DROP TABLE DROP TYPE DROP TYPE DROP TYPE 2026-10-27 10:50:25 [INFO] Running pgtap test: docs-full-text-search.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-full-text-search.sql CREATE TABLE INSERT 0 5 to_tsvector --------------------------- 'egg':2 'green':1 'ham':4 (1 row) to_tsvector --------------------------- 'egg':2 'green':1 'ham':4 (1 row) id | title | author | description ----+-------+--------+------------- (0 rows) id | title | author | description ----+-------------------------------------+--------------+------------------------------------------------- 5 | Harry Potter and the Goblet of Fire | J.K. Rowling | Fourth year of school starts, big drama ensues. (1 row) id | title | author | description ----+-------------------------------------+-------------------+------------------------------------------------- 3 | Tootle | Gertrude Crampton | Little toy train has big dreams. 5 | Harry Potter and the Goblet of Fire | J.K. Rowling | Fourth year of school starts, big drama ensues. (2 rows) id | title | author | description ----+-----------------------+------------------------+--------------------------------------------- 1 | The Poky Little Puppy | Janette Sebring Lowrey | Puppy is slower than other, bigger animals. 3 | Tootle | Gertrude Crampton | Little toy train has big dreams. (2 rows) CREATE FUNCTION id | title | author | description ----+-----------------------+------------------------+--------------------------------------------- 1 | The Poky Little Puppy | Janette Sebring Lowrey | Puppy is slower than other, bigger animals. 3 | Tootle | Gertrude Crampton | Little toy train has big dreams. (2 rows) id | title | author | description ----+--------+-------------------+---------------------------------- 3 | Tootle | Gertrude Crampton | Little toy train has big dreams. (1 row) id | title | author | description ----+-------------------------------------+-------------------+------------------------------------------------- 3 | Tootle | Gertrude Crampton | Little toy train has big dreams. 5 | Harry Potter and the Goblet of Fire | J.K. Rowling | Fourth year of school starts, big drama ensues. (2 rows) title ----------------------- The Poky Little Puppy (1 row) CREATE FUNCTION id | title | author | description ----+-----------------------+------------------------+--------------------------------------------- 1 | The Poky Little Puppy | Janette Sebring Lowrey | Puppy is slower than other, bigger animals. (1 row) id | title | author | description ----+-----------------------+------------------------+--------------------------------------------- 1 | The Poky Little Puppy | Janette Sebring Lowrey | Puppy is slower than other, bigger animals. (1 row) ALTER TABLE CREATE INDEX id | fts ----+----------------------------------------------------------------------------------------------------------------- 1 | 'anim':7 'bigger':6 'littl':10 'poki':9 'puppi':1,11 'slower':3 2 | 'eat':2 'peter':8 'rabbit':1,9 'tale':6 'veget':4 3 | 'big':5 'dream':6 'littl':1 'tootl':7 'toy':2 'train':3 4 | 'chang':3 'color':9 'eat':7 'egg':12 'food':4,10 'green':11 'ham':14 'prefer':5 'sam':1 'unusu':8 5 | 'big':6 'drama':7 'ensu':8 'fire':15 'fourth':1 'goblet':13 'harri':9 'potter':10 'school':4 'start':5 'year':2 (5 rows) id | title | author | description | fts ----+--------+-------------------+----------------------------------+--------------------------------------------------------- 3 | Tootle | Gertrude Crampton | Little toy train has big dreams. | 'big':5 'dream':6 'littl':1 'tootl':7 'toy':2 'train':3 (1 row) id | title | author | description | fts ----+--------+-------------------+----------------------------------+--------------------------------------------------------- 3 | Tootle | Gertrude Crampton | Little toy train has big dreams. | 'big':5 'dream':6 'littl':1 'tootl':7 'toy':2 'train':3 (1 row) id | title | author | description | fts ----+-------------------------------------+--------------+-------------------------------------------------+----------------------------------------------------------------------------------------------------------------- 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':2 (1 row) id | title | author | description | fts ----+-------------------------------------+--------------+-------------------------------------------------+----------------------------------------------------------------------------------------------------------------- 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':2 (1 row) id | title | author | description | fts ----+-------------------------------------+--------------+-------------------------------------------------+----------------------------------------------------------------------------------------------------------------- 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':2 (1 row) id | title | author | description | fts ----+--------------------+-----------+--------------------------------------------------------------------+--------------------------------------------------------------------------------------------------- 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':8 (1 row) id | title | author | description | fts ----+--------+-------------------+----------------------------------+--------------------------------------------------------- 3 | Tootle | Gertrude Crampton | Little toy train has big dreams. | 'big':5 'dream':6 'littl':1 'tootl':7 'toy':2 'train':3 (1 row) id | title | author | description | fts ----+-------+--------+-------------+----- (0 rows) id | title | author | description | fts ----+--------------------------+----------------+------------------------------+--------------------------------------------------- 2 | The Tale of Peter Rabbit | Beatrix Potter | Rabbit eats some vegetables. | 'eat':2 'peter':8 'rabbit':1,9 'tale':6 'veget':4 (1 row) id | title | author | description | fts ----+-------------------------------------+--------------+-------------------------------------------------+----------------------------------------------------------------------------------------------------------------- 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':2 (1 row) id | title | author | description | fts ----+-------+--------+-------------+----- (0 rows) id | title | author | description | fts ----+--------+-------------------+----------------------------------+--------------------------------------------------------- 3 | Tootle | Gertrude Crampton | Little toy train has big dreams. | 'big':5 'dream':6 'littl':1 'tootl':7 'toy':2 'train':3 (1 row) DROP FUNCTION DROP FUNCTION DROP TABLE 2026-10-27 10:50:26 [INFO] Running pgtap test: docs-functions.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-functions.sql CREATE FUNCTION hello_world ------------- hello world (1 row) CREATE TABLE INSERT 0 3 CREATE TABLE INSERT 0 4 CREATE FUNCTION id | name ----+---------- 1 | Tattoine (1 row) CREATE FUNCTION psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-functions.sql:64: ERROR: duplicate key value violates unique constraint "planets_pkey" DETAIL: Key (id)=(1) already exists. CONTEXT: SQL statement "insert into planets(name) values (add_planet.name) returning id" PL/pgSQL function add_planet(text) line 5 at SQL statement CREATE FUNCTION hello_world_definer --------------------- hello world (1 row) REVOKE psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-functions.sql:79: ERROR: role "anon" does not exist psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-functions.sql:81: ERROR: role "authenticated" does not exist REVOKE psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-functions.sql:84: ERROR: role "anon" does not exist ALTER DEFAULT PRIVILEGES psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-functions.sql:87: ERROR: role "anon" does not exist psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-functions.sql:89: ERROR: role "authenticated" does not exist CREATE FUNCTION psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-functions.sql:106: WARNING: logging warning: WARNING MESSAGE psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-functions.sql:106: ERROR: logging error: ERROR MESSAGE CONTEXT: PL/pgSQL function logging_example(text,text,text) line 5 at RAISE CREATE FUNCTION error_if_null --------------- not null (1 row) CREATE TABLE INSERT 0 1 CREATE FUNCTION assert_example -------------------------------------- 123e4567-e89b-12d3-a456-426614174000 (1 row) CREATE FUNCTION psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-functions.sql:162: ERROR: An error occurred in function : relation "table_that_does_not_exist" does not exist CONTEXT: PL/pgSQL function error_example() line 7 at RAISE CREATE TABLE INSERT 0 1 CREATE FUNCTION advanced_example ------------------ 42,new val (1 row) DROP FUNCTION DROP FUNCTION DROP FUNCTION DROP FUNCTION DROP FUNCTION DROP FUNCTION DROP FUNCTION DROP FUNCTION DROP FUNCTION DROP TABLE DROP TABLE DROP TABLE DROP TABLE GRANT psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-functions.sql:221: ERROR: role "anon" does not exist ALTER DEFAULT PRIVILEGES psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-functions.sql:224: ERROR: role "anon" does not exist 2026-10-27 10:50:26 [INFO] Running pgtap test: docs-indexes.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-indexes.sql CREATE TABLE INSERT 0 1 name ---------- John Doe (1 row) CREATE INDEX CREATE INDEX CREATE INDEX REINDEX REINDEX DROP TABLE 2026-10-27 10:50:26 [INFO] Running pgtap test: docs-json.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-json.sql CREATE TABLE INSERT 0 5 title | description | price | low_age | high_age -------------------------------------+--------------------------------------------------------------------+-------+---------+---------- The Poky Little Puppy | Puppy is slower than other, bigger animals. | 5.95 | 3 | 6 The Tale of Peter Rabbit | Rabbit eats some vegetables. | 4.49 | 2 | 5 Tootle | Little toy train has big dreams. | 3.99 | 2 | 5 Green Eggs and Ham | Sam has changing food preferences and eats unusually colored food. | 7.49 | 4 | 8 Harry Potter and the Goblet of Fire | Fourth year of school starts, big drama ensues. | 24.95 | 10 | 99 (5 rows) DROP TABLE 2026-10-27 10:50:26 [INFO] Running pgtap test: docs-partitioning.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-partitioning.sql CREATE TABLE CREATE TABLE CREATE TABLE INSERT 0 4 id | order_date | customer_id | amount ----+------------+-------------+-------- 1 | 2000-01-15 | 1 | 100 2 | 2000-01-20 | 2 | 200 3 | 2000-02-10 | 3 | 150 4 | 2000-02-25 | 4 | 300 (4 rows) id | order_date | customer_id | amount ----+------------+-------------+-------- 3 | 2000-02-10 | 3 | 150 4 | 2000-02-25 | 4 | 300 (2 rows) DROP TABLE CREATE TABLE CREATE TABLE CREATE TABLE INSERT 0 5 id | name | country ----+------------+--------- 1 | John Doe | US 2 | Jane Smith | CANADA (2 rows) id | name | country ----+-------------+--------- 3 | Li Wei | CHINA 4 | Priya Patel | INDIA 5 | Yuki Tanaka | JAPAN (3 rows) DROP TABLE CREATE TABLE CREATE TABLE CREATE TABLE INSERT 0 4 id | name | category | price ----+--------+-------------+------- 1 | Laptop | Electronics | 999 2 | Phone | Electronics | 599 (2 rows) count ------- 2 (1 row) count ------- 2 (1 row) DROP TABLE 2026-10-27 10:50:26 [INFO] Running pgtap test: docs-tables-and-data.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-tables-and-data.sql CREATE TABLE table_name | column_name | data_type | is_nullable | column_default ------------+-------------+-----------+-------------+---------------- movies | id | bigint | NO | movies | name | text | YES | movies | description | text | YES | (3 rows) DROP TABLE CREATE TABLE column_name | data_type | is_nullable | column_default | is_identity | identity_generation -------------+-----------+-------------+----------------+-------------+--------------------- id | bigint | NO | | YES | ALWAYS (1 row) DROP TABLE CREATE TABLE column_name | data_type | is_nullable | column_default | is_identity | identity_generation -------------+-----------+-------------+----------------+-------------+--------------------- id | bigint | NO | | YES | BY DEFAULT (1 row) DROP TABLE CREATE TABLE INSERT 0 2 id | name | description ----+-------------------------+-------------------------------------------------------------------------------------------------------------------------------- 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. 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. (2 rows) DROP TABLE psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-tables-and-data.sql:57: NOTICE: table "categories" does not exist, skipping DROP TABLE CREATE TABLE CREATE TABLE ALTER TABLE table_name | column_name | foreign_table_name | foreign_column_name ------------+-------------+--------------------+--------------------- movies | category_id | categories | id (1 row) psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-tables-and-data.sql:89: NOTICE: table "performances" does not exist, skipping DROP TABLE psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-tables-and-data.sql:90: NOTICE: table "actors" does not exist, skipping DROP TABLE DROP TABLE CREATE TABLE CREATE TABLE CREATE TABLE table_name -------------- actors movies performances (3 rows) CREATE SCHEMA schema_name ------------- private (1 row) psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-tables-and-data.sql:120: NOTICE: table "salaries" does not exist, skipping DROP TABLE psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-tables-and-data.sql:121: NOTICE: drop cascades to constraint performances_actor_id_fkey on table performances DROP TABLE CREATE TABLE CREATE TABLE table_schema | table_name --------------+------------ private | salaries (1 row) psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-tables-and-data.sql:137: NOTICE: table "grades" does not exist, skipping DROP TABLE psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-tables-and-data.sql:138: NOTICE: table "courses" does not exist, skipping DROP TABLE psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-tables-and-data.sql:139: NOTICE: table "students" does not exist, skipping DROP TABLE psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-tables-and-data.sql:140: NOTICE: view "transcripts" does not exist, skipping DROP VIEW CREATE TABLE CREATE TABLE CREATE TABLE INSERT 0 3 INSERT 0 3 INSERT 0 6 CREATE VIEW psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-tables-and-data.sql:192: ERROR: role "authenticated" does not exist name | type | title | code | result ------------------+---------------+--------------------------+---------+-------- Anakin Skywalker | graduate | Authentication Theories | AUTH205 | A Anakin Skywalker | graduate | Introduction to Postgres | PG101 | A- Anakin Skywalker | graduate | Fundamentals of Supabase | SUP412 | B- Princess Leia | undergraduate | Introduction to Postgres | PG101 | B+ Princess Leia | undergraduate | Fundamentals of Supabase | SUP412 | A+ Yoda | graduate | Authentication Theories | AUTH205 | A (6 rows) psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-tables-and-data.sql:196: NOTICE: materialized view "transcripts_materialized" does not exist, skipping DROP MATERIALIZED VIEW SELECT 6 name | type | title | code | result ------------------+---------------+--------------------------+---------+-------- Anakin Skywalker | graduate | Authentication Theories | AUTH205 | A Anakin Skywalker | graduate | Introduction to Postgres | PG101 | A- Anakin Skywalker | graduate | Fundamentals of Supabase | SUP412 | B- Princess Leia | undergraduate | Introduction to Postgres | PG101 | B+ Princess Leia | undergraduate | Fundamentals of Supabase | SUP412 | A+ Yoda | graduate | Authentication Theories | AUTH205 | A (6 rows) REFRESH MATERIALIZED VIEW count ------- 6 (1 row) psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-tables-and-data.sql:217: NOTICE: view "secure_transcripts" does not exist, skipping DROP VIEW CREATE VIEW schemaname | viewname ------------+-------------------- public | secure_transcripts (1 row) psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-tables-and-data.sql:228: NOTICE: view "test_view" does not exist, skipping DROP VIEW CREATE VIEW ALTER VIEW schemaname | viewname ------------+----------- public | test_view (1 row) DROP MATERIALIZED VIEW DROP VIEW DROP VIEW DROP VIEW DROP TABLE DROP TABLE DROP TABLE DROP TABLE DROP TABLE DROP TABLE DROP TABLE DROP TABLE DROP SCHEMA 2026-10-27 10:50:26 [INFO] Running pgtap test: docs-triggers.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-triggers.sql CREATE TABLE CREATE TABLE CREATE FUNCTION CREATE TRIGGER INSERT 0 1 INSERT 0 1 UPDATE 1 id | employee_id | old_salary | new_salary ----+-------------+------------+------------ 1 | 1 | 50000 | 55000 (1 row) CREATE TABLE CREATE TABLE CREATE FUNCTION CREATE TRIGGER CREATE TABLE CREATE FUNCTION CREATE TRIGGER INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 DELETE 1 id | customer_id | action | customer_name ----+-------------+--------+--------------- 1 | 1 | DELETE | Alice Johnson (1 row) CREATE TABLE CREATE FUNCTION CREATE TRIGGER INSERT 0 1 id | trigger_name | operation | table_name ----+-------------------------+-----------+------------ 1 | statement_level_trigger | INSERT | orders (1 row) CREATE TABLE CREATE FUNCTION CREATE TRIGGER INSERT 0 1 UPDATE 1 DELETE 1 id | trigger_name | trigger_when | operation | table_name | table_schema | row_id ----+-------------------+--------------+-----------+------------+--------------+-------- 1 | variables_trigger | AFTER | INSERT | employees | public | 3 2 | variables_trigger | AFTER | UPDATE | employees | public | 3 3 | variables_trigger | AFTER | DELETE | employees | public | 3 (3 rows) CREATE TABLE CREATE FUNCTION CREATE TRIGGER INSERT 0 1 INSERT 0 1 id | employee_name | salary ----+---------------+-------- 1 | Executive | 150000 (1 row) DROP TRIGGER DROP TRIGGER DROP TRIGGER DROP TRIGGER DROP TRIGGER DROP TRIGGER DROP FUNCTION DROP FUNCTION DROP FUNCTION DROP FUNCTION DROP FUNCTION DROP FUNCTION DROP TABLE DROP TABLE DROP TABLE DROP TABLE DROP TABLE DROP TABLE DROP TABLE DROP TABLE 2026-10-27 10:50:26 [INFO] Running pgtap test: docs-webhooks.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/docs-webhooks.sql CREATE TABLE CREATE TABLE CREATE FUNCTION CREATE TRIGGER CREATE TRIGGER CREATE TRIGGER INSERT 0 1 INSERT 0 1 id | webhook_name | event_type | table_name | schema_name | ?column? ----+----------------+------------+------------+-------------+-------------------------------------------------------------- 1 | insert_webhook | INSERT | profiles | public | {"id": 1, "name": "John Doe", "email": "john@example.com"} 2 | insert_webhook | INSERT | profiles | public | {"id": 2, "name": "Jane Smith", "email": "jane@example.com"} (2 rows) UPDATE 1 id | webhook_name | event_type | table_name | schema_name | ?column? | ?column? ----+----------------+------------+------------+-------------+----------------------------------------------------------------+------------------------------------------------------------ 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"} (1 row) DELETE 1 id | webhook_name | event_type | table_name | schema_name | ?column? ----+----------------+------------+------------+-------------+-------------------------------------------------------------- 4 | delete_webhook | DELETE | profiles | public | {"id": 2, "name": "Jane Smith", "email": "jane@example.com"} (1 row) CREATE TABLE CREATE TABLE CREATE FUNCTION CREATE FUNCTION CREATE TRIGGER INSERT 0 1 INSERT 0 1 id | webhook_name | url | method | response_status | response_data ----+----------------+----------------------------------+--------+-----------------+------------------------------------------------------------------------------------------ 1 | orders_webhook | https://dummyjson.com/products/1 | GET | 200 | {"id": 1, "price": 9.99, "title": "Essence Mascara Lash Princess", "category": "beauty"} 2 | orders_webhook | https://dummyjson.com/products/1 | GET | 200 | {"id": 1, "price": 9.99, "title": "Essence Mascara Lash Princess", "category": "beauty"} (2 rows) CREATE TABLE INSERT 0 1 CREATE FUNCTION CREATE TRIGGER INSERT 0 1 id | webhook_name | url | method | response_status | response_data ----+-----------------+----------------------------------+--------+-----------------+------------------------------------------------------------------------------------------- 3 | product_webhook | https://dummyjson.com/products/2 | GET | 200 | {"id": 2, "price": 19.99, "title": "Eyeshadow Palette with Mirror", "category": "beauty"} (1 row) CREATE FUNCTION webhook_name | event_type | table_name | record_count ----------------+------------+------------+-------------- delete_webhook | DELETE | profiles | 1 insert_webhook | INSERT | profiles | 3 update_webhook | UPDATE | profiles | 1 (3 rows) DROP TRIGGER DROP TRIGGER DROP TRIGGER DROP TRIGGER DROP TRIGGER DROP FUNCTION DROP FUNCTION DROP FUNCTION DROP FUNCTION DROP FUNCTION DROP TABLE DROP TABLE DROP TABLE DROP TABLE DROP TABLE 2026-10-27 10:50:26 [INFO] Running pgtap test: enable_tracking.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/enable_tracking.sql psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/enable_tracking.sql:1: ERROR: role "postgres" does not exist psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/enable_tracking.sql:2: ERROR: role "postgres" does not exist psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/enable_tracking.sql:4: ERROR: role "postgres" does not exist psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/enable_tracking.sql:5: ERROR: role "postgres" does not exist 2026-10-27 10:50:26 [INFO] Running pgtap test: event_trigger_search_path.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/event_trigger_search_path.sql DO 2026-10-27 10:50:26 [INFO] Running pgtap test: intarray_ltree_query.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/intarray_ltree_query.sql BEGIN SET CREATE EXTENSION CREATE EXTENSION q_and ------- f (1 row) q_or ------ t (1 row) lquery_match -------------- t (1 row) ltxtquery_match ----------------- t (1 row) psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/intarray_ltree_query.sql:38: ERROR: query_int expression is too complex psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/intarray_ltree_query.sql:42: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/intarray_ltree_query.sql:45: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/intarray_ltree_query.sql:47: ERROR: current transaction is aborted, commands ignored until end of transaction block ROLLBACK 2026-10-27 10:50:26 [INFO] Running pgtap test: ltree_label_overflow.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/ltree_label_overflow.sql BEGIN SET CREATE EXTENSION na | nb | a_gt_b | a_lt_b | b_lt_a | a_eq_a -------+----+--------+--------+--------+-------- 20001 | 1 | t | f | t | t (1 row) ROLLBACK 2026-10-27 10:50:26 [INFO] Running pgtap test: multirange_create_priv.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/multirange_create_priv.sql BEGIN CREATE SCHEMA CREATE SCHEMA psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/multirange_create_priv.sql:16: ERROR: role "postgres" does not exist psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/multirange_create_priv.sql:18: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/multirange_create_priv.sql:24: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/multirange_create_priv.sql:28: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/multirange_create_priv.sql:32: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/multirange_create_priv.sql:33: ERROR: savepoint "no_priv" does not exist psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/multirange_create_priv.sql:35: ERROR: current transaction is aborted, commands ignored until end of transaction block ROLLBACK 2026-10-27 10:50:26 [INFO] Running pgtap test: operator_breaking_change.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/operator_breaking_change.sql BEGIN SET CREATE EXTENSION CREATE SCHEMA psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/operator_breaking_change.sql:22: ERROR: role "postgres" does not exist psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/operator_breaking_change.sql:26: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/operator_breaking_change.sql:29: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/operator_breaking_change.sql:32: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/operator_breaking_change.sql:37: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/operator_breaking_change.sql:38: ERROR: savepoint "before_restrict" does not exist psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/operator_breaking_change.sql:41: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/operator_breaking_change.sql:46: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/operator_breaking_change.sql:47: ERROR: savepoint "before_join" does not exist psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/operator_breaking_change.sql:55: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/operator_breaking_change.sql:56: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/operator_breaking_change.sql:58: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/operator_breaking_change.sql:60: ERROR: current transaction is aborted, commands ignored until end of transaction block ROLLBACK 2026-10-27 10:50:26 [INFO] Running pgtap test: pg-safeupdate.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pg-safeupdate.sql LOAD SET CREATE SCHEMA CREATE TABLE psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pg-safeupdate.sql:13: ERROR: UPDATE requires a WHERE clause psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pg-safeupdate.sql:15: NOTICE: drop cascades to table v.foo DROP SCHEMA 2026-10-27 10:50:26 [INFO] Running pgtap test: pg_graphql.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pg_graphql.sql BEGIN COMMENT CREATE TABLE CREATE TABLE COMMENT CREATE FUNCTION resolve ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- {"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}}} (1 row) resolve -------------------------------------------------------------------------------------- {"data": {"insertIntoBlogCollection": {"records": [{"id": 1, "owner": {"id": 1}}]}}} (1 row) resolve ------------------------------------------------------------------------------------------------------------------------ {"data": {"insertIntoAccountCollection": {"records": [{"email": "baz@baz.com", "status": null}], "affectedCount": 1}}} (1 row) resolve -------------------------------------------------------------------------------------------------------------------------------- {"data": {"xyz": {"records": [{"id": 4, "email": "foo@bar.com"}, {"id": 5, "email": "other@email.com"}], "affectedCount": 2}}} (1 row) resolve ------------------------------------------------------------------------------------------------ {"data": {"xyz": {"records": [{"email": "1@email.com", "status": null}], "affectedCount": 1}}} (1 row) resolve ------------------------------------------------------------------------------------------------ {"data": {"xyz": {"records": [{"email": "x@y.com", "status": "active"}], "affectedCount": 1}}} (1 row) resolve ----------------------------------------------------------------------------------------------------------------- {"data": {"insertIntoAccountCollection": {"records": [{"id": 8, "email": "bar@foo.com"}], "affectedCount": 1}}} (1 row) resolve ----------------------------------------------------------------------------------------------------------------- {"data": {"insertIntoAccountCollection": {"records": [{"id": 9, "email": "bar@foo.com"}], "affectedCount": 1}}} (1 row) resolve -------------------------------------------------------------- {"data": {"insertIntoBlogCollection": {"affectedCount": 1}}} (1 row) resolve --------------------------------------------------------------------------------------------------------------------- {"data": null, "errors": [{"message": "Input for type AccountInsertInput contains extra keys [\"doesNotExist\"]"}]} (1 row) resolve ----------------------------------------------------------------------------------- {"data": null, "errors": [{"message": "Invalid input for BlogInsertInput type"}]} (1 row) resolve --------------------------------------------------------------------------- {"data": null, "errors": [{"message": "Invalid input for NonNull type"}]} (1 row) resolve -------------------------------------------------------------------------------------------- {"data": null, "errors": [{"message": "At least one record must be provided to objects"}]} (1 row) ROLLBACK 2026-10-27 10:50:26 [INFO] Running pgtap test: pg_net.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pg_net.sql request_id ------------ 1 (1 row) 2026-10-27 10:50:26 [INFO] Running pgtap test: pg_plan_filter.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pg_plan_filter.sql BEGIN psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pg_plan_filter.sql:2: ERROR: could not access file "plan_filter": No such file or directory psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pg_plan_filter.sql:4: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pg_plan_filter.sql:10: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pg_plan_filter.sql:14: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pg_plan_filter.sql:16: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pg_plan_filter.sql:18: ERROR: current transaction is aborted, commands ignored until end of transaction block ROLLBACK 2026-10-27 10:50:26 [INFO] Running pgtap test: pgaudit.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pgaudit.sql SET SET SET CREATE SCHEMA CREATE TABLE INSERT 0 1 id | name | password | description ----+-------+----------+------------- 1 | user1 | HASH1 | blah, blah (1 row) psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pgaudit.sql:23: NOTICE: drop cascades to table v.account DROP SCHEMA 2026-10-27 10:50:26 [INFO] Running pgtap test: pgbouncer.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pgbouncer.sql schema_name | owner -------------+------- (0 rows) schema_name | function_name | owner -------------+---------------+------- (0 rows) schema | object_name | grantee | privilege_type --------+-------------+---------+---------------- (0 rows) CREATE ROLE CREATE ROLE UPDATE 1 psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pgbouncer.sql:61: ERROR: schema "pgbouncer" does not exist LINE 1: select pgbouncer.get_auth('test_expired_user_password'); ^ psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pgbouncer.sql:63: ERROR: schema "pgbouncer" does not exist LINE 1: select pgbouncer.get_auth('test_valid_user_password'); ^ psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pgbouncer.sql:66: ERROR: role "pgbouncer" does not exist psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pgbouncer.sql:67: ERROR: schema "pgbouncer" does not exist LINE 1: select pgbouncer.get_auth('test_valid_user_password'); ^ RESET psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pgbouncer.sql:71: ERROR: role "postgres" does not exist psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pgbouncer.sql:72: ERROR: schema "pgbouncer" does not exist LINE 1: select pgbouncer.get_auth('test_valid_user_password'); ^ RESET DROP ROLE DROP ROLE 2026-10-27 10:50:26 [INFO] Running pgtap test: pgcrypto_cipher_matrix.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pgcrypto_cipher_matrix.sql BEGIN CREATE EXTENSION SAVEPOINT psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pgcrypto_cipher_matrix.sql:26: ERROR: encrypt error: Cipher cannot be initialized ROLLBACK SAVEPOINT psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pgcrypto_cipher_matrix.sql:30: ERROR: encrypt error: Cipher cannot be initialized ROLLBACK SAVEPOINT psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pgcrypto_cipher_matrix.sql:34: ERROR: encrypt error: Cipher cannot be initialized ROLLBACK aes128_rt ----------- secret (1 row) aes192_rt ----------- secret (1 row) aes256_rt ----------- secret (1 row) des3_rt --------- secret (1 row) SAVEPOINT psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pgcrypto_cipher_matrix.sql:45: ERROR: Wrong key or corrupt data ROLLBACK SAVEPOINT psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pgcrypto_cipher_matrix.sql:49: ERROR: Wrong key or corrupt data ROLLBACK post_error_ok --------------- still-here (1 row) ROLLBACK 2026-10-27 10:50:27 [INFO] Running pgtap test: pgsodium.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/pgsodium.sql status -------- valid (1 row) 2026-10-27 10:50:27 [INFO] Running pgtap test: realtime.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/realtime.sql publication_name | owner | puballtables | pubinsert | pubupdate | pubdelete | pubtruncate ------------------+-------+--------------+-----------+-----------+-----------+------------- (0 rows) 2026-10-27 10:50:27 [INFO] Running pgtap test: replica_identity_upsert.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/replica_identity_upsert.sql BEGIN CREATE TABLE CREATE PUBLICATION INSERT 0 1 SAVEPOINT psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/replica_identity_upsert.sql:17: ERROR: cannot update table "ri" because it does not have a replica identity and publishes updates HINT: To enable updating the table, set REPLICA IDENTITY using ALTER TABLE. ROLLBACK SAVEPOINT psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/replica_identity_upsert.sql:22: ERROR: cannot update table "ri" because it does not have a replica identity and publishes updates HINT: To enable updating the table, set REPLICA IDENTITY using ALTER TABLE. ROLLBACK ALTER TABLE INSERT 0 1 MERGE 1 v ---- 30 (1 row) ROLLBACK 2026-10-27 10:50:27 [INFO] Running pgtap test: storage.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/storage.sql schema_name | owner -------------+------- (0 rows) schema_name | table_name | owner | rls_enabled | rls_policies -------------+------------+-------+-------------+-------------- (0 rows) schema_name | table_name | role_name | privilege_type | is_grantable -------------+------------+-----------+----------------+-------------- (0 rows) table_schema | table_name | index_name | index_owner --------------+------------+------------+------------- (0 rows) schema_name | function_name | owner -------------+---------------+------- (0 rows) CREATE ROLE psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/storage.sql:98: ERROR: role "postgres" does not exist psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/storage.sql:100: ERROR: role "postgres" does not exist psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/storage.sql:101: ERROR: schema "storage" does not exist psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/storage.sql:102: ERROR: schema "storage" does not exist psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/storage.sql:104: ERROR: role "postgres" does not exist DROP OWNED DROP ROLE RESET 2026-10-27 10:50:27 [INFO] Running pgtap test: supautils_reserved_roles.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_reserved_roles.sql BEGIN psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_reserved_roles.sql:5: ERROR: role "postgres" does not exist psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_reserved_roles.sql:8: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_reserved_roles.sql:9: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_reserved_roles.sql:10: ERROR: savepoint "before_drop" does not exist psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_reserved_roles.sql:12: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_reserved_roles.sql:14: ERROR: current transaction is aborted, commands ignored until end of transaction block ROLLBACK 2026-10-27 10:50:27 [INFO] Running pgtap test: supautils_warehouse_writer.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql BEGIN protection_registered ----------------------- f (1 row) CREATE ROLE CREATE ROLE CREATE ROLE GRANT ROLE psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:9: ERROR: role "postgres" does not exist psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:10: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:11: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:12: ERROR: savepoint "denied" does not exist psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:13: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:14: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:15: ERROR: savepoint "denied" does not exist psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:16: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:17: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:18: ERROR: savepoint "denied" does not exist psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:19: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:20: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:21: ERROR: savepoint "denied" does not exist psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:22: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:23: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:24: ERROR: savepoint "denied" does not exist psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:25: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:26: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:27: ERROR: savepoint "denied" does not exist psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:28: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:29: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:30: ERROR: savepoint "denied" does not exist psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:31: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:32: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:33: ERROR: savepoint "denied" does not exist psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:34: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:35: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:36: ERROR: savepoint "denied" does not exist psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:37: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:38: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:39: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:40: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:41: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/supautils_warehouse_writer.sql:42: ERROR: current transaction is aborted, commands ignored until end of transaction block ROLLBACK 2026-10-27 10:50:27 [INFO] Running pgtap test: vault.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/vault.sql schema | object_name | grantee | privilege_type --------+---------------------------+----------------+---------------- vault | _crypto_aead_det_decrypt | supabase_admin | EXECUTE vault | _crypto_aead_det_encrypt | supabase_admin | EXECUTE vault | _crypto_aead_det_noncegen | supabase_admin | EXECUTE vault | create_secret | supabase_admin | EXECUTE vault | update_secret | supabase_admin | EXECUTE (5 rows) schema | table | index_name | index_owner | index_type --------+---------+------------------+----------------+------------ vault | secrets | secrets_name_idx | supabase_admin | Unique vault | secrets | secrets_pkey | supabase_admin | Unique (2 rows) search_path ----------------- "$user", public (1 row) SET DROP EXTENSION CREATE TABLE psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/vault.sql:65: ERROR: role "postgres" does not exist LINE 1: ...g_extension values (0, 'supabase_vault', '0.2.8', 'postgres'... ^ CREATE EXTENSION DROP TABLE RESET function_name | grantee | privilege_type ---------------+---------+---------------- (0 rows) psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/vault.sql:83: ERROR: role "postgres" does not exist search_path ----------------- "$user", public (1 row) 2026-10-27 10:50:27 [INFO] Running pgtap test: wal2json.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/wal2json.sql CREATE SCHEMA CREATE TABLE psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/wal2json.sql:10: ERROR: could not access file "wal2json": No such file or directory INSERT 0 1 psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/wal2json.sql:28: ERROR: replication slot "reg_test" does not exist psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/wal2json.sql:31: ERROR: replication slot "reg_test" does not exist psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/wal2json.sql:33: NOTICE: drop cascades to table v.foo DROP SCHEMA 2026-10-27 10:50:27 [INFO] Running pgtap test: z_17_intarray_ltree_query.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/z_17_intarray_ltree_query.sql BEGIN SET CREATE EXTENSION psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/z_17_intarray_ltree_query.sql:7: ERROR: lquery level is too large DETAIL: Total size of level exceeds the maximum allowed (65535 bytes). psql:/nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/z_17_intarray_ltree_query.sql:9: ERROR: current transaction is aborted, commands ignored until end of transaction block ROLLBACK 2026-10-27 10:50:27 [INFO] Running pgtap test: z_17_wal_summarize.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/k2n0fs2jrd3bqr5qh5q2ixck7kmjh782-sql/z_17_wal_summarize.sql summarize_wal_default_ok -------------------------- f (1 row) $ pg_ctl -D /build/tmp.60Ct7RqRoJ stop waiting for server to shut down.... done server stopped 2026-10-27 10:50:27 [INFO] Starting PostgreSQL server for pg_regress tests $ /nix/store/vqzybg3xvf45qy1c2sai4z2y4iis11p5-start-postgres-server-test/bin/start-postgres-server 17 --daemonize Starting server for PSQL 17 /nix/store/vqzybg3xvf45qy1c2sai4z2y4iis11p5-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 directory KEY_FILE: /build/tmp.Q43BVlKmC1/pgsodium.key KEY_FILE contents: cat: /build/tmp.Q43BVlKmC1/pgsodium.key: No such file or directory PGSODIUM_GETKEY_SCRIPT: /nix/store/hm49fhplcc21kvjqvmyqk4wj50cqqmkx-pgsodium-getkey/bin/pgsodium-getkey NOTE: using port 5541 for server NOTE: using temporary directory /build/tmp.Q43BVlKmC1 for data NOTE: you are free to re-use this data directory at will The files belonging to this database system will be owned by user "nixbld". This user must also own the server process. The database cluster will be initialized with locale "en_US.UTF-8". The default database encoding has accordingly been set to "UTF8". The default text search configuration will be set to "english". Data page checksums are disabled. fixing permissions on existing directory /build/tmp.Q43BVlKmC1 ... ok creating subdirectories ... ok selecting dynamic shared memory implementation ... posix selecting default "max_connections" ... 100 selecting default "shared_buffers" ... 128MB selecting default time zone ... UTC creating configuration files ... ok running bootstrap script ... ok performing post-bootstrap initialization ... ok syncing data to disk ... ok initdb: warning: enabling "trust" authentication for local connections initdb: 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. Success. You can now start the database server using: /nix/store/bl7gnabbr7q4qr91f3wl7g4p72cib9a4-postgresql-and-plugins-17.11/bin/pg_ctl -D /build/tmp.Q43BVlKmC1 -l logfile start NOTE: patching postgresql.conf files non-macos pg 17 conf waiting for server to start.... done server started pg_ctl: server is running (PID: 1212) /nix/store/bl7gnabbr7q4qr91f3wl7g4p72cib9a4-postgresql-and-plugins-17.11/bin/postgres "-D" "/build/tmp.Q43BVlKmC1" "--config-file=/build/tmp.Q43BVlKmC1/postgresql.conf" "-p" "5541" "-k" "/build/tmp.Q43BVlKmC1/tmp" PostgreSQL is ready WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. NOTICE: empty string is not a valid password, clearing password CREATE ROLE ALTER DATABASE Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/init-scripts/00000000000000-initial-schema.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. CREATE PUBLICATION ALTER ROLE CREATE ROLE CREATE ROLE GRANT ROLE GRANT CREATE ROLE GRANT ROLE CREATE SCHEMA CREATE EXTENSION CREATE EXTENSION CREATE ROLE CREATE ROLE CREATE ROLE CREATE ROLE GRANT ROLE GRANT ROLE GRANT ROLE GRANT ROLE GRANT ALTER DEFAULT PRIVILEGES ALTER DEFAULT PRIVILEGES ALTER DEFAULT PRIVILEGES GRANT ALTER ROLE ALTER DEFAULT PRIVILEGES ALTER DEFAULT PRIVILEGES ALTER DEFAULT PRIVILEGES ALTER ROLE ALTER ROLE Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/init-scripts/00000000000001-auth-schema.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. CREATE SCHEMA CREATE TABLE CREATE INDEX CREATE INDEX COMMENT CREATE TABLE CREATE INDEX CREATE INDEX CREATE INDEX COMMENT CREATE TABLE COMMENT CREATE TABLE CREATE INDEX COMMENT CREATE TABLE COMMENT INSERT 0 7 CREATE FUNCTION CREATE FUNCTION CREATE FUNCTION GRANT CREATE ROLE GRANT GRANT GRANT ALTER ROLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/init-scripts/00000000000002-storage-schema.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. CREATE SCHEMA CREATE ROLE ALTER ROLE GRANT DO Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/init-scripts/00000000000003-post-setup.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. ALTER ROLE ALTER ROLE CREATE FUNCTION CREATE EVENT TRIGGER COMMENT CREATE FUNCTION COMMENT DO CREATE ROLE GRANT GRANT GRANT GRANT GRANT GRANT GRANT GRANT GRANT DO WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. NOTICE: empty string is not a valid password, clearing password ALTER ROLE WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. CREATE ROLE REVOKE CREATE SCHEMA CREATE FUNCTION REVOKE GRANT WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. psql:/nix/store/0s4wf39csywl7iy2bchhiaqzcinrk17w-stat-extension:1: NOTICE: schema "extensions" already exists, skipping CREATE SCHEMA CREATE EXTENSION Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/10000000000000_demote-postgres.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. GRANT GRANT GRANT GRANT GRANT GRANT GRANT GRANT GRANT DO ALTER ROLE Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20211115181400_update-auth-permissions.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. GRANT GRANT GRANT ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE GRANT GRANT GRANT GRANT ALTER DEFAULT PRIVILEGES ALTER DEFAULT PRIVILEGES ALTER DEFAULT PRIVILEGES Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20211118015519_create-realtime-schema.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. CREATE SCHEMA Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20211122051245_update-realtime-permissions.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. GRANT GRANT GRANT GRANT Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20211124212715_update-auth-owner.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. DO DO DO Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20211130151719_update-realtime-permissions.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. ALTER DEFAULT PRIVILEGES ALTER DEFAULT PRIVILEGES ALTER DEFAULT PRIVILEGES Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220118070449_enable-safeupdate-postgrest.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. ALTER ROLE Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220126121436_finer-postgrest-triggers.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. psql:/nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220126121436_finer-postgrest-triggers.sql:3: NOTICE: event trigger "api_restart" does not exist, skipping DROP EVENT TRIGGER psql:/nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220126121436_finer-postgrest-triggers.sql:4: NOTICE: function extensions.notify_api_restart() does not exist, skipping DROP FUNCTION CREATE FUNCTION CREATE FUNCTION psql:/nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220126121436_finer-postgrest-triggers.sql:59: NOTICE: event trigger "pgrst_ddl_watch" does not exist, skipping DROP EVENT TRIGGER CREATE EVENT TRIGGER psql:/nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220126121436_finer-postgrest-triggers.sql:64: NOTICE: event trigger "pgrst_drop_watch" does not exist, skipping DROP EVENT TRIGGER CREATE EVENT TRIGGER Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220224211803_fix-postgrest-supautils.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. DO Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220317095840_pg_graphql.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. CREATE SCHEMA psql:/nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220317095840_pg_graphql.sql:5: NOTICE: function graphql_public.graphql(text,text,jsonb) does not exist, skipping DROP FUNCTION CREATE FUNCTION GRANT ALTER DEFAULT PRIVILEGES ALTER DEFAULT PRIVILEGES ALTER DEFAULT PRIVILEGES ALTER DEFAULT PRIVILEGES ALTER DEFAULT PRIVILEGES ALTER DEFAULT PRIVILEGES CREATE FUNCTION psql:/nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220317095840_pg_graphql.sql:90: NOTICE: event trigger "issue_pg_graphql_access" does not exist, skipping DROP EVENT TRIGGER CREATE EVENT TRIGGER COMMENT CREATE FUNCTION psql:/nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220317095840_pg_graphql.sql:143: NOTICE: event trigger "issue_graphql_placeholder" does not exist, skipping DROP EVENT TRIGGER CREATE EVENT TRIGGER COMMENT Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220321174452_fix-postgrest-alter-type-event-trigger.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. psql:/nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220321174452_fix-postgrest-alter-type-event-trigger.sql:3: NOTICE: event trigger "api_restart" does not exist, skipping DROP EVENT TRIGGER psql:/nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220321174452_fix-postgrest-alter-type-event-trigger.sql:4: NOTICE: function extensions.notify_api_restart() does not exist, skipping DROP FUNCTION CREATE FUNCTION CREATE FUNCTION DROP EVENT TRIGGER CREATE EVENT TRIGGER DROP EVENT TRIGGER CREATE EVENT TRIGGER Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220322085208_gotrue-session-limit.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. ALTER ROLE Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220404205710_pg_graphql-on-by-default.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. CREATE FUNCTION CREATE FUNCTION CREATE FUNCTION psql:/nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220404205710_pg_graphql-on-by-default.sql:142: NOTICE: extension "pg_graphql" does not exist, skipping DROP EXTENSION DO Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220609081115_grant-supabase-auth-admin-and-supabase-storage-admin-to-postgres.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. GRANT ROLE Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220613123923_pg_graphql-pg-dump-perms.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. CREATE FUNCTION DROP EXTENSION DO Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220713082019_pg_cron-pg_net-temp-perms-fix.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. DO DO Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20221028101028_set_authenticator_timeout.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. ALTER ROLE Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20221103090837_revoke_admin.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. REVOKE ROLE Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20221207154255_create_pgsodium_and_vault.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. DO Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20230201083204_grant_auth_roles_to_postgres.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. GRANT ROLE Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20230224042246_grant_extensions_perms_for_postgres.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. GRANT GRANT GRANT ALTER DEFAULT PRIVILEGES ALTER DEFAULT PRIVILEGES ALTER DEFAULT PRIVILEGES Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20230306081037_grant_pg_monitor_to_postgres.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. GRANT ROLE Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20230327032006_grant_auth_roles_to_supabase_storage_admin.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. GRANT ROLE Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20230529180330_alter_api_roles_for_inherit.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. ALTER ROLE ALTER ROLE ALTER ROLE DO Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20231013070755_grant_authenticator_to_supabase_storage_admin.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. GRANT ROLE REVOKE ROLE Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20231017062225_grant_pg_graphql_permissions_for_custom_roles.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. CREATE FUNCTION DROP EXTENSION DO Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20231020085357_revoke_writes_on_cron_job_from_postgres.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. DO CREATE FUNCTION DROP EVENT TRIGGER ALTER FUNCTION CREATE EVENT TRIGGER Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20231130133139_set_lock_timeout_to_authenticator_role.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. ALTER ROLE Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20240124080435_alter_lo_export_lo_import_owner.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. ALTER FUNCTION ALTER FUNCTION ALTER FUNCTION Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20240606060239_grant_predefined_roles_to_postgres.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. GRANT ROLE Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20241031003909_create_orioledb.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. DO Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20241215003910_backfill_pgmq_metadata.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. DO DO Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20250205060043_disable_log_statement_on_internal_roles.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. ALTER ROLE ALTER ROLE ALTER ROLE Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20250205144616_move_orioledb_to_extensions_schema.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. DO Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20250218031949_pgsodium_mask_role.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. DO Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20250220051611_pg_net_perms_fix.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. CREATE FUNCTION DO Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20250312095419_pgbouncer_ownership.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. ALTER FUNCTION GRANT Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20250402065937_alter_internal_event_triggers_owner_to_supabase_admin.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. DROP EVENT TRIGGER ALTER FUNCTION CREATE EVENT TRIGGER Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20250402093753_grant_subscription_to_postgres_16_and_above.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. DO Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20250417190610_update_pgbouncer_get_auth.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. CREATE FUNCTION GRANT Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20250421084701_revoke_admin_roles_from_postgres.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. REVOKE ROLE DO DO REVOKE ROLE REVOKE DO Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20250605172253_grant_with_admin_to_postgres_16_and_above.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. DO Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20250623125453_tmp_grant_storage_tables_to_postgres_with_grant_option.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. DO Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20250709135250_grant_storage_schema_to_postgres_with_grant_option.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. DO Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20250710151649_supabase_read_only_user_default_transaction_read_only.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. ALTER ROLE Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20251001204436_predefined_role_grants.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. GRANT ROLE DO Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20251105172723_grant_pg_reload_conf_to_postgres.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. GRANT Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20251121132723_correct_search_path_pgbouncer.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. CREATE FUNCTION REVOKE REVOKE GRANT Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20260211120934_supabase_privileged_role.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. DO Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20260413000000_fix-authenticator-session-preload-libraries.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. ALTER ROLE Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20260421000000_pg_graphql-off-by-default.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. DROP EXTENSION Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20260421000001_rescope_pg_graphql_access_trigger.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. CREATE FUNCTION DROP EVENT TRIGGER CREATE EVENT TRIGGER Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20260730000000_revoke_trigger_on_cron_tables_from_postgres.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. DO CREATE FUNCTION Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20260923021047_update_pgrst_watch_triggers.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. CREATE FUNCTION CREATE FUNCTION Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20261016000001_search_path_for_supa_functions.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. CREATE FUNCTION CREATE FUNCTION CREATE FUNCTION CREATE FUNCTION CREATE FUNCTION CREATE FUNCTION WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. ALTER DATABASE ALTER DATABASE ALTER ROLE ALTER ROLE ALTER ROLE ALTER ROLE ALTER ROLE ALTER ROLE ALTER ROLE ALTER ROLE ALTER ROLE ALTER ROLE Shutting down PostgreSQL... PostgreSQL is running in daemon mode. Please stop it using pg_ctl. pg_ctl: another server might be running; trying to start server anyway waiting for server to start.... stopped waiting pg_ctl: could not start server Examine the log output. pg_ctl: server is running (PID: 1212) /nix/store/bl7gnabbr7q4qr91f3wl7g4p72cib9a4-postgresql-and-plugins-17.11/bin/postgres "-D" "/build/tmp.Q43BVlKmC1" "--config-file=/build/tmp.Q43BVlKmC1/postgresql.conf" "-p" "5541" "-k" "/build/tmp.Q43BVlKmC1/tmp" $ pg_isready -h localhost -p 5541 -U supabase_admin -q 2026-10-27 10:50:31 [INFO] PostgreSQL is ready 2026-10-27 10:50:31 [INFO] CLI variant detected - loading CLI prime SQL file $ psql -p 5541 -h localhost --no-password --username=supabase_admin -d postgres -v ON_ERROR_STOP=1 -Xf /nix/store/ib75j74vyc0w374jcz7mqcg6njf21yx3-prime-cli.sql WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. SET CREATE EXTENSION CREATE EXTENSION CREATE EXTENSION CREATE EXTENSION 2026-10-27 10:50:31 [INFO] Creating test_config table for pg_regress tests $ psql -p 5541 -h localhost --no-password --username=supabase_admin -d postgres -c CREATE TABLE IF NOT EXISTS test_config (key TEXT PRIMARY KEY, value TEXT); INSERT INTO test_config (key, value) VALUES ('http_mock_port', '8880') ON CONFLICT (key) DO UPDATE SET value = EXCLUDED.value; INSERT INTO test_config (key, value) VALUES ('http_mock_host', 'localhost') ON CONFLICT (key) DO UPDATE SET value = EXCLUDED.value; WARNING: invalid configuration parameter name "supautils.reserved_role_members", removing it DETAIL: "supautils" is now a reserved prefix. CREATE TABLE INSERT 0 1 INSERT 0 1 2026-10-27 10:50:31 [INFO] CLI variant detected - running subset of pg_regress tests (38 tests) $ pg_regress --use-existing --dbname=postgres --inputdir=/nix/store/bf6vqr1jkw18qib60zdf7smfc5xlzjp0-tests --outputdir=/nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-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_summarize (using postmaster on localhost, port 5541) ============== running regression test queries ============== test auth ... FAILED 11 ms test create_statistics_priv ... FAILED 10 ms test dblink ... FAILED 30 ms test docs-array-test ... FAILED 9 ms test docs-cascades-deletes ... FAILED 50 ms test docs-connections ... FAILED 9 ms test docs-enums ... FAILED 19 ms test docs-full-text-search ... FAILED 20 ms test docs-functions ... FAILED 28 ms test docs-indexes ... FAILED 17 ms test docs-json ... FAILED 12 ms test docs-partitioning ... FAILED 20 ms test docs-tables-and-data ... FAILED 62 ms test docs-triggers ... FAILED 35 ms test docs-webhooks ... FAILED 28 ms test enable_tracking ... FAILED 8 ms test event_trigger_search_path ... FAILED 10 ms test intarray_ltree_query ... FAILED 62 ms test ltree_label_overflow ... FAILED 49 ms test multirange_create_priv ... FAILED 9 ms test operator_breaking_change ... FAILED 27 ms test pg-safeupdate ... FAILED 10 ms test pg_graphql ... FAILED 55 ms test pg_net ... FAILED 8 ms test pg_plan_filter ... FAILED 12 ms test pgaudit ... FAILED 10 ms test pgbouncer ... FAILED 17 ms test pgcrypto_cipher_matrix ... FAILED 21 ms test pgsodium ... FAILED 8 ms test realtime ... FAILED 6 ms test replica_identity_upsert ... FAILED 12 ms test storage ... FAILED 12 ms test supautils_reserved_roles ... FAILED 8 ms test supautils_warehouse_writer ... FAILED 11 ms test vault ... FAILED 23 ms test wal2json ... FAILED 14 ms test z_17_intarray_ltree_query ... FAILED 42 ms test z_17_wal_summarize ... FAILED 8 ms ======================== 38 of 38 tests failed. ======================== The differences that caused some tests to fail can be viewed in the file "/nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/regression.diffs". A copy of the test summary that you see above is saved in the file "/nix/store/2jbyjy0f4vrgbccp7ddqxy3yvmgwq3sl-run-check-harness-psql-17-cli/regression_output/regression.out". 2026-10-27 10:50:32 [ERROR] pg_regress tests failed 2026-10-27 10:50:32 [ERROR] An error occurred. Exit code: 1 2026-10-27 10:50:32 [ERROR] Debug logs: