2026-11-12 10:20:46 [INFO] Starting HTTP mock server (will find free port)... 2026-11-12 10:20:47 [INFO] HTTP mock server started on port 8880 2026-11-12 10:20:47 [INFO] Creating temporary PostgreSQL cluster at /build/tmp.a68nZwh05y 2026-11-12 10:20:49 [INFO] Generated preload libraries: pg_cron, pg_net, pgsodium, supabase_vault 2026-11-12 10:20:49 [INFO] Checking shared_preload_libraries setting: 2026-11-12 10:20:49 [INFO] 721:shared_preload_libraries = 'pg_cron, pg_net, pgsodium, supabase_vault' # (change requires restart) 2026-11-12 10:20:49 [INFO] Configuring local auth 2026-11-12 10:20:49 [INFO] Waiting for PostgreSQL to be ready... 2026-11-12 10:20:49 [INFO] PostgreSQL is ready 2026-11-12 10:20:49 [INFO] Creating test database 2026-11-12 10:20:49 [INFO] CLI variant detected - loading CLI prime SQL file 2026-11-12 10:20:49 [INFO] Creating test_config table 2026-11-12 10:20:50 [INFO] Running pgtap test: auth.sql 2026-11-12 10:20:50 [INFO] Running pgtap test: create_statistics_priv.sql 2026-11-12 10:20:50 [INFO] Running pgtap test: dblink.sql 2026-11-12 10:20:50 [INFO] Running pgtap test: docs-array-test.sql 2026-11-12 10:20:50 [INFO] Running pgtap test: docs-cascades-deletes.sql 2026-11-12 10:20:50 [INFO] Running pgtap test: docs-connections.sql 2026-11-12 10:20:50 [INFO] Running pgtap test: docs-enums.sql 2026-11-12 10:20:50 [INFO] Running pgtap test: docs-full-text-search.sql 2026-11-12 10:20:50 [INFO] Running pgtap test: docs-functions.sql 2026-11-12 10:20:51 [INFO] Running pgtap test: docs-indexes.sql 2026-11-12 10:20:51 [INFO] Running pgtap test: docs-json.sql 2026-11-12 10:20:51 [INFO] Running pgtap test: docs-partitioning.sql 2026-11-12 10:20:51 [INFO] Running pgtap test: docs-tables-and-data.sql 2026-11-12 10:20:51 [INFO] Running pgtap test: docs-triggers.sql 2026-11-12 10:20:51 [INFO] Running pgtap test: docs-webhooks.sql 2026-11-12 10:20:51 [INFO] Running pgtap test: enable_tracking.sql 2026-11-12 10:20:52 [INFO] Running pgtap test: event_trigger_search_path.sql 2026-11-12 10:20:52 [INFO] Running pgtap test: intarray_ltree_query.sql 2026-11-12 10:20:52 [INFO] Running pgtap test: ltree_label_overflow.sql 2026-11-12 10:20:52 [INFO] Running pgtap test: multirange_create_priv.sql 2026-11-12 10:20:52 [INFO] Running pgtap test: operator_breaking_change.sql 2026-11-12 10:20:52 [INFO] Running pgtap test: pg-safeupdate.sql 2026-11-12 10:20:52 [INFO] Running pgtap test: pg_graphql.sql 2026-11-12 10:20:52 [INFO] Running pgtap test: pg_net.sql 2026-11-12 10:20:52 [INFO] Running pgtap test: pg_plan_filter.sql 2026-11-12 10:20:52 [INFO] Running pgtap test: pgaudit.sql 2026-11-12 10:20:52 [INFO] Running pgtap test: pgbouncer.sql 2026-11-12 10:20:52 [INFO] Running pgtap test: pgcrypto_cipher_matrix.sql 2026-11-12 10:20:53 [INFO] Running pgtap test: pgsodium.sql 2026-11-12 10:20:53 [INFO] Running pgtap test: realtime.sql 2026-11-12 10:20:53 [INFO] Running pgtap test: replica_identity_upsert.sql 2026-11-12 10:20:53 [INFO] Running pgtap test: storage.sql 2026-11-12 10:20:53 [INFO] Running pgtap test: supautils_reserved_memberships.sql 2026-11-12 10:20:53 [INFO] Running pgtap test: supautils_reserved_roles.sql 2026-11-12 10:20:53 [INFO] Running pgtap test: vault.sql 2026-11-12 10:20:53 [INFO] Running pgtap test: wal2json.sql 2026-11-12 10:20:53 [INFO] Running pgtap test: z_17_intarray_ltree_query.sql 2026-11-12 10:20:53 [INFO] Running pgtap test: z_17_supabase_monitor_admin.sql 2026-11-12 10:20:53 [INFO] Running pgtap test: z_17_wal_summarize.sql 2026-11-12 10:20:54 [INFO] Starting PostgreSQL server for pg_regress tests 2026-11-12 10:20:58 [INFO] PostgreSQL is ready 2026-11-12 10:20:58 [INFO] CLI variant detected - loading CLI prime SQL file 2026-11-12 10:20:58 [INFO] Creating test_config table for pg_regress tests 2026-11-12 10:20:58 [INFO] CLI variant detected - running subset of pg_regress tests (39 tests) 2026-11-12 10:21:01 [ERROR] pg_regress tests failed diff -U3 /nix/store/68qn5zkm9ns9l6xyxvhxsy4d27a9r127-tests/expected/z_17_supabase_monitor_admin.out /nix/store/3jrms0m8j13h4lf6zzdq5yipi5d7l8ph-run-check-harness-psql-17-cli/regression_output/results/z_17_supabase_monitor_admin.out --- /nix/store/68qn5zkm9ns9l6xyxvhxsy4d27a9r127-tests/expected/z_17_supabase_monitor_admin.out 1970-01-01 00:00:01.000000000 +0000 +++ /nix/store/3jrms0m8j13h4lf6zzdq5yipi5d7l8ph-run-check-harness-psql-17-cli/regression_output/results/z_17_supabase_monitor_admin.out 2026-11-12 10:21:00.973612869 +0000 @@ -1,5 +1,4 @@ --- supabase_monitor_admin: passwordless, read-only --- monitoring role (quick_explainer.md, +-- supabase_monitor_admin: passwordless, read-only, for monitoring from localhost -- migrations/db/init-scripts/00000000000000-initial-schema.sql) -- attributes: login, no password, bypassrls, nothing else -- only accessible via localhost 2026-11-12 10:21:01 [ERROR] An error occurred. Exit code: 1 2026-11-12 10:21:01 [ERROR] Debug logs: 2026-11-12 10:20:46 [INFO] Starting HTTP mock server (will find free port)... $ /nix/store/a1mjjnpfivsx5gi4rxbcr54vl6gyjfzj-python3-3.13.11/bin/python3 /nix/store/sfl1mnhcw0ccky7m2crn0hda79clq4mk-http-mock-server.py 2026-11-12 10:20:47 [INFO] HTTP mock server started on port 8880 2026-11-12 10:20:47 [INFO] Creating temporary PostgreSQL cluster at /build/tmp.a68nZwh05y $ initdb --locale=C --username=supabase_admin -D /build/tmp.a68nZwh05y 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.a68nZwh05y ... 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.a68nZwh05y -l logfile start 2026-11-12 10:20:49 [INFO] Generated preload libraries: pg_cron, pg_net, pgsodium, supabase_vault 2026-11-12 10:20:49 [INFO] Checking shared_preload_libraries setting: 2026-11-12 10:20:49 [INFO] 721:shared_preload_libraries = 'pg_cron, pg_net, pgsodium, supabase_vault' # (change requires restart) 2026-11-12 10:20:49 [INFO] Configuring local auth $ pg_ctl -D /build/tmp.a68nZwh05y -l /build/tmp.a68nZwh05y/postgresql.log -o -k /build/tmp.a68nZwh05y/sockets -p 5541 -d 5 start waiting for server to start.... done server started 2026-11-12 10:20:49 [INFO] Waiting for PostgreSQL to be ready... $ pg_isready -h localhost -p 5541 -U supabase_admin -q 2026-11-12 10:20:49 [INFO] PostgreSQL is ready 2026-11-12 10:20:49 [INFO] Creating test database $ createdb -p 5541 -h localhost --username=supabase_admin testing 2026-11-12 10:20:49 [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-11-12 10:20:49 [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-11-12 10:20:50 [INFO] Running pgtap test: auth.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-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/ms7ip94l24bna36m00yzm09c352qnv8g-sql/auth.sql:97: ERROR: relation "auth.schema_migrations" does not exist LINE 1: select * from auth.schema_migrations; ^ 2026-11-12 10:20:50 [INFO] Running pgtap test: create_statistics_priv.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/create_statistics_priv.sql BEGIN CREATE SCHEMA CREATE SCHEMA psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/create_statistics_priv.sql:15: ERROR: role "postgres" does not exist psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/create_statistics_priv.sql:17: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/create_statistics_priv.sql:20: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/create_statistics_priv.sql:21: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/create_statistics_priv.sql:24: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/create_statistics_priv.sql:27: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/create_statistics_priv.sql:28: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/create_statistics_priv.sql:29: ERROR: savepoint "no_priv" does not exist psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/create_statistics_priv.sql:31: ERROR: current transaction is aborted, commands ignored until end of transaction block ROLLBACK 2026-11-12 10:20:50 [INFO] Running pgtap test: dblink.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/dblink.sql SET DROP EXTENSION psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-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/ms7ip94l24bna36m00yzm09c352qnv8g-sql/dblink.sql:28: ERROR: role "postgres" does not exist search_path ----------------- "$user", public (1 row) DROP EXTENSION CREATE EXTENSION 2026-11-12 10:20:50 [INFO] Running pgtap test: docs-array-test.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-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-11-12 10:20:50 [INFO] Running pgtap test: docs-cascades-deletes.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-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/ms7ip94l24bna36m00yzm09c352qnv8g-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/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-cascades-deletes.sql:56: ERROR: duplicate key value violates unique constraint "grandparent_pkey" DETAIL: Key (id)=(1) already exists. psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-cascades-deletes.sql:61: ERROR: duplicate key value violates unique constraint "parent_pkey" DETAIL: Key (id)=(1) already exists. psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-cascades-deletes.sql:66: ERROR: duplicate key value violates unique constraint "parent_pkey" DETAIL: Key (id)=(2) already exists. psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-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/ms7ip94l24bna36m00yzm09c352qnv8g-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/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-cascades-deletes.sql:89: ERROR: duplicate key value violates unique constraint "grandparent_pkey" DETAIL: Key (id)=(1) already exists. psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-cascades-deletes.sql:94: ERROR: duplicate key value violates unique constraint "parent_pkey" DETAIL: Key (id)=(1) already exists. psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-cascades-deletes.sql:99: ERROR: duplicate key value violates unique constraint "parent_pkey" DETAIL: Key (id)=(2) already exists. psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-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/ms7ip94l24bna36m00yzm09c352qnv8g-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/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-cascades-deletes.sql:122: ERROR: duplicate key value violates unique constraint "grandparent_pkey" DETAIL: Key (id)=(1) already exists. psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-cascades-deletes.sql:127: ERROR: duplicate key value violates unique constraint "parent_pkey" DETAIL: Key (id)=(1) already exists. psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-cascades-deletes.sql:132: ERROR: duplicate key value violates unique constraint "parent_pkey" DETAIL: Key (id)=(2) already exists. psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-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/ms7ip94l24bna36m00yzm09c352qnv8g-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/ms7ip94l24bna36m00yzm09c352qnv8g-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/ms7ip94l24bna36m00yzm09c352qnv8g-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-11-12 10:20:50 [INFO] Running pgtap test: docs-connections.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-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-11-12 10:20:50 [INFO] Running pgtap test: docs-enums.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-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-11-12 10:20:50 [INFO] Running pgtap test: docs-full-text-search.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-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-11-12 10:20:50 [INFO] Running pgtap test: docs-functions.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-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/ms7ip94l24bna36m00yzm09c352qnv8g-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/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-functions.sql:79: ERROR: role "anon" does not exist psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-functions.sql:81: ERROR: role "authenticated" does not exist REVOKE psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-functions.sql:84: ERROR: role "anon" does not exist ALTER DEFAULT PRIVILEGES psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-functions.sql:87: ERROR: role "anon" does not exist psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-functions.sql:89: ERROR: role "authenticated" does not exist CREATE FUNCTION psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-functions.sql:106: WARNING: logging warning: WARNING MESSAGE psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-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/ms7ip94l24bna36m00yzm09c352qnv8g-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/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-functions.sql:221: ERROR: role "anon" does not exist ALTER DEFAULT PRIVILEGES psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-functions.sql:224: ERROR: role "anon" does not exist 2026-11-12 10:20:51 [INFO] Running pgtap test: docs-indexes.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-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-11-12 10:20:51 [INFO] Running pgtap test: docs-json.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-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-11-12 10:20:51 [INFO] Running pgtap test: docs-partitioning.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-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-11-12 10:20:51 [INFO] Running pgtap test: docs-tables-and-data.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-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/ms7ip94l24bna36m00yzm09c352qnv8g-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/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-tables-and-data.sql:89: NOTICE: table "performances" does not exist, skipping DROP TABLE psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-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/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-tables-and-data.sql:120: NOTICE: table "salaries" does not exist, skipping DROP TABLE psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-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/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-tables-and-data.sql:137: NOTICE: table "grades" does not exist, skipping DROP TABLE psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-tables-and-data.sql:138: NOTICE: table "courses" does not exist, skipping DROP TABLE psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-tables-and-data.sql:139: NOTICE: table "students" does not exist, skipping DROP TABLE psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-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/ms7ip94l24bna36m00yzm09c352qnv8g-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/ms7ip94l24bna36m00yzm09c352qnv8g-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/ms7ip94l24bna36m00yzm09c352qnv8g-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/ms7ip94l24bna36m00yzm09c352qnv8g-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-11-12 10:20:51 [INFO] Running pgtap test: docs-triggers.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-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-11-12 10:20:51 [INFO] Running pgtap test: docs-webhooks.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-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-11-12 10:20:51 [INFO] Running pgtap test: enable_tracking.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/enable_tracking.sql psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/enable_tracking.sql:1: ERROR: role "postgres" does not exist psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/enable_tracking.sql:2: ERROR: role "postgres" does not exist psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/enable_tracking.sql:4: ERROR: role "postgres" does not exist psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/enable_tracking.sql:5: ERROR: role "postgres" does not exist 2026-11-12 10:20:52 [INFO] Running pgtap test: event_trigger_search_path.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/event_trigger_search_path.sql DO 2026-11-12 10:20:52 [INFO] Running pgtap test: intarray_ltree_query.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-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/ms7ip94l24bna36m00yzm09c352qnv8g-sql/intarray_ltree_query.sql:38: ERROR: query_int expression is too complex psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/intarray_ltree_query.sql:42: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/intarray_ltree_query.sql:45: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/intarray_ltree_query.sql:47: ERROR: current transaction is aborted, commands ignored until end of transaction block ROLLBACK 2026-11-12 10:20:52 [INFO] Running pgtap test: ltree_label_overflow.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-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-11-12 10:20:52 [INFO] Running pgtap test: multirange_create_priv.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/multirange_create_priv.sql BEGIN CREATE SCHEMA CREATE SCHEMA psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/multirange_create_priv.sql:16: ERROR: role "postgres" does not exist psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/multirange_create_priv.sql:18: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/multirange_create_priv.sql:24: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/multirange_create_priv.sql:28: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/multirange_create_priv.sql:32: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/multirange_create_priv.sql:33: ERROR: savepoint "no_priv" does not exist psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/multirange_create_priv.sql:35: ERROR: current transaction is aborted, commands ignored until end of transaction block ROLLBACK 2026-11-12 10:20:52 [INFO] Running pgtap test: operator_breaking_change.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/operator_breaking_change.sql BEGIN SET CREATE EXTENSION CREATE SCHEMA psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/operator_breaking_change.sql:22: ERROR: role "postgres" does not exist psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/operator_breaking_change.sql:26: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/operator_breaking_change.sql:29: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/operator_breaking_change.sql:32: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/operator_breaking_change.sql:37: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/operator_breaking_change.sql:38: ERROR: savepoint "before_restrict" does not exist psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/operator_breaking_change.sql:41: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/operator_breaking_change.sql:46: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/operator_breaking_change.sql:47: ERROR: savepoint "before_join" does not exist psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/operator_breaking_change.sql:55: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/operator_breaking_change.sql:56: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/operator_breaking_change.sql:58: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/operator_breaking_change.sql:60: ERROR: current transaction is aborted, commands ignored until end of transaction block ROLLBACK 2026-11-12 10:20:52 [INFO] Running pgtap test: pg-safeupdate.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pg-safeupdate.sql LOAD SET CREATE SCHEMA CREATE TABLE psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pg-safeupdate.sql:13: ERROR: UPDATE requires a WHERE clause psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pg-safeupdate.sql:15: NOTICE: drop cascades to table v.foo DROP SCHEMA 2026-11-12 10:20:52 [INFO] Running pgtap test: pg_graphql.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-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-11-12 10:20:52 [INFO] Running pgtap test: pg_net.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pg_net.sql request_id ------------ 1 (1 row) 2026-11-12 10:20:52 [INFO] Running pgtap test: pg_plan_filter.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pg_plan_filter.sql BEGIN psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pg_plan_filter.sql:2: ERROR: could not access file "plan_filter": No such file or directory psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pg_plan_filter.sql:4: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pg_plan_filter.sql:10: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pg_plan_filter.sql:14: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pg_plan_filter.sql:16: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pg_plan_filter.sql:18: ERROR: current transaction is aborted, commands ignored until end of transaction block ROLLBACK 2026-11-12 10:20:52 [INFO] Running pgtap test: pgaudit.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-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/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pgaudit.sql:23: NOTICE: drop cascades to table v.account DROP SCHEMA 2026-11-12 10:20:52 [INFO] Running pgtap test: pgbouncer.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-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 Null display is "". psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pgbouncer.sql:62: ERROR: schema "pgbouncer" does not exist LINE 1: select * from pgbouncer.get_auth('test_expired_user_password... ^ psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pgbouncer.sql:64: ERROR: schema "pgbouncer" does not exist LINE 1: select pgbouncer.get_auth('test_valid_user_password'); ^ psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pgbouncer.sql:67: ERROR: role "pgbouncer" does not exist psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pgbouncer.sql:68: ERROR: schema "pgbouncer" does not exist LINE 1: select pgbouncer.get_auth('test_valid_user_password'); ^ RESET psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pgbouncer.sql:72: ERROR: role "postgres" does not exist psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pgbouncer.sql:73: ERROR: schema "pgbouncer" does not exist LINE 1: select pgbouncer.get_auth('test_valid_user_password'); ^ RESET DROP ROLE DROP ROLE 2026-11-12 10:20:52 [INFO] Running pgtap test: pgcrypto_cipher_matrix.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pgcrypto_cipher_matrix.sql BEGIN CREATE EXTENSION SAVEPOINT psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pgcrypto_cipher_matrix.sql:26: ERROR: encrypt error: Cipher cannot be initialized ROLLBACK SAVEPOINT psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pgcrypto_cipher_matrix.sql:30: ERROR: encrypt error: Cipher cannot be initialized ROLLBACK SAVEPOINT psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-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/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pgcrypto_cipher_matrix.sql:45: ERROR: Wrong key or corrupt data ROLLBACK SAVEPOINT psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pgcrypto_cipher_matrix.sql:49: ERROR: Wrong key or corrupt data ROLLBACK post_error_ok --------------- still-here (1 row) ROLLBACK 2026-11-12 10:20:53 [INFO] Running pgtap test: pgsodium.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pgsodium.sql status -------- valid (1 row) 2026-11-12 10:20:53 [INFO] Running pgtap test: realtime.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/realtime.sql publication_name | owner | puballtables | pubinsert | pubupdate | pubdelete | pubtruncate ------------------+-------+--------------+-----------+-----------+-----------+------------- (0 rows) 2026-11-12 10:20:53 [INFO] Running pgtap test: replica_identity_upsert.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/replica_identity_upsert.sql BEGIN CREATE TABLE CREATE PUBLICATION INSERT 0 1 SAVEPOINT psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-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/ms7ip94l24bna36m00yzm09c352qnv8g-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-11-12 10:20:53 [INFO] Running pgtap test: storage.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-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/ms7ip94l24bna36m00yzm09c352qnv8g-sql/storage.sql:98: ERROR: role "postgres" does not exist psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/storage.sql:100: ERROR: role "postgres" does not exist psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/storage.sql:101: ERROR: schema "storage" does not exist psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/storage.sql:102: ERROR: schema "storage" does not exist psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/storage.sql:104: ERROR: role "postgres" does not exist DROP OWNED DROP ROLE RESET 2026-11-12 10:20:53 [INFO] Running pgtap test: supautils_reserved_memberships.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_memberships.sql psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_memberships.sql:1: ERROR: role "postgres" does not exist psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_memberships.sql:3: ERROR: role "postgres" does not exist psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_memberships.sql:4: ERROR: role "postgres" does not exist psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_memberships.sql:5: ERROR: role "postgres" does not exist psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_memberships.sql:6: ERROR: role "postgres" does not exist psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_memberships.sql:7: ERROR: role "postgres" does not exist psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_memberships.sql:8: ERROR: role "postgres" does not exist psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_memberships.sql:9: ERROR: role "postgres" does not exist psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_memberships.sql:10: ERROR: role "postgres" does not exist psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_memberships.sql:11: ERROR: role "postgres" does not exist psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_memberships.sql:12: ERROR: role "postgres" does not exist psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_memberships.sql:13: ERROR: role "postgres" does not exist psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_memberships.sql:14: ERROR: role "postgres" does not exist psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_memberships.sql:15: ERROR: role "postgres" does not exist psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_memberships.sql:16: ERROR: role "postgres" does not exist RESET 2026-11-12 10:20:53 [INFO] Running pgtap test: supautils_reserved_roles.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_roles.sql BEGIN psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_roles.sql:5: ERROR: role "postgres" does not exist psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_roles.sql:8: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_roles.sql:9: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_roles.sql:10: ERROR: savepoint "before_drop" does not exist psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_roles.sql:12: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_roles.sql:14: ERROR: current transaction is aborted, commands ignored until end of transaction block ROLLBACK 2026-11-12 10:20:53 [INFO] Running pgtap test: vault.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-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/ms7ip94l24bna36m00yzm09c352qnv8g-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/ms7ip94l24bna36m00yzm09c352qnv8g-sql/vault.sql:83: ERROR: role "postgres" does not exist search_path ----------------- "$user", public (1 row) 2026-11-12 10:20:53 [INFO] Running pgtap test: wal2json.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/wal2json.sql CREATE SCHEMA CREATE TABLE psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/wal2json.sql:10: ERROR: could not access file "wal2json": No such file or directory INSERT 0 1 psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/wal2json.sql:28: ERROR: replication slot "reg_test" does not exist psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/wal2json.sql:31: ERROR: replication slot "reg_test" does not exist psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/wal2json.sql:33: NOTICE: drop cascades to table v.foo DROP SCHEMA 2026-11-12 10:20:53 [INFO] Running pgtap test: z_17_intarray_ltree_query.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_intarray_ltree_query.sql BEGIN SET CREATE EXTENSION psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-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/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_intarray_ltree_query.sql:9: ERROR: current transaction is aborted, commands ignored until end of transaction block ROLLBACK 2026-11-12 10:20:53 [INFO] Running pgtap test: z_17_supabase_monitor_admin.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_supabase_monitor_admin.sql rolsuper | rolinherit | rolcreaterole | rolcreatedb | rolcanlogin | rolreplication | rolbypassrls | rolconnlimit | no_password ----------+------------+---------------+-------------+-------------+----------------+--------------+--------------+------------- (0 rows) setting --------- (0 rows) psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_supabase_monitor_admin.sql:16: ERROR: role "supabase_monitor_admin" does not exist LINE 2: from pg_auth_members where member = 'supabase_monitor_admin'... ^ psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_supabase_monitor_admin.sql:19: ERROR: role "supabase_monitor_admin" does not exist LINE 1: ...lect count(*) from pg_auth_members where roleid = 'supabase_... ^ psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_supabase_monitor_admin.sql:26: ERROR: role "supabase_monitor_admin" does not exist LINE 3: and refobjid = 'supabase_monitor_admin'::regrole ^ psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_supabase_monitor_admin.sql:29: ERROR: role "supabase_monitor_admin" does not exist CREATE TABLE INSERT 0 2 ALTER TABLE ALTER TABLE psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_supabase_monitor_admin.sql:39: ERROR: role "postgres" does not exist psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_supabase_monitor_admin.sql:40: ERROR: role "supabase_monitor_admin" does not exist count ------- 2 (1 row) INSERT 0 1 SET count ------- 0 (1 row) RESET DROP TABLE BEGIN psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_supabase_monitor_admin.sql:52: ERROR: role "postgres" does not exist psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_supabase_monitor_admin.sql:53: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_supabase_monitor_admin.sql:54: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_supabase_monitor_admin.sql:55: ERROR: savepoint "s" does not exist psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_supabase_monitor_admin.sql:56: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_supabase_monitor_admin.sql:57: ERROR: savepoint "s" does not exist psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_supabase_monitor_admin.sql:58: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_supabase_monitor_admin.sql:59: ERROR: savepoint "s" does not exist psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_supabase_monitor_admin.sql:60: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_supabase_monitor_admin.sql:61: ERROR: savepoint "s" does not exist psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_supabase_monitor_admin.sql:62: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_supabase_monitor_admin.sql:63: ERROR: savepoint "s" does not exist psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_supabase_monitor_admin.sql:64: ERROR: current transaction is aborted, commands ignored until end of transaction block ROLLBACK 2026-11-12 10:20:53 [INFO] Running pgtap test: z_17_wal_summarize.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_wal_summarize.sql summarize_wal_default_ok -------------------------- f (1 row) $ pg_ctl -D /build/tmp.a68nZwh05y stop waiting for server to shut down.... done server stopped 2026-11-12 10:20:54 [INFO] Starting PostgreSQL server for pg_regress tests $ /nix/store/rs68rvm264lkb78g8vc27m8p4nz2m9nx-start-postgres-server-test/bin/start-postgres-server 17 --daemonize Starting server for PSQL 17 /nix/store/rs68rvm264lkb78g8vc27m8p4nz2m9nx-start-postgres-server-test/bin/start-postgres-server: line 191: warning: setlocale: LC_ALL: cannot change locale (en_US.UTF-8): No such file or directory KEY_FILE: /build/tmp.a766tZ8TQK/pgsodium.key KEY_FILE contents: cat: /build/tmp.a766tZ8TQK/pgsodium.key: No such file or directory PGSODIUM_GETKEY_SCRIPT: /nix/store/1pwkb9dqp63rk9xi9f2vr1s4vd57z0yr-pgsodium-getkey/bin/pgsodium-getkey NOTE: using port 5541 for server NOTE: using temporary directory /build/tmp.a766tZ8TQK 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.a766tZ8TQK ... 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/9cgb3iwg25krw3rchysinlgn6bvh36kc-postgresql-and-plugins-17.11/bin/pg_ctl -D /build/tmp.a766tZ8TQK -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: 1237) /nix/store/9cgb3iwg25krw3rchysinlgn6bvh36kc-postgresql-and-plugins-17.11/bin/postgres "-D" "/build/tmp.a766tZ8TQK" "--config-file=/build/tmp.a766tZ8TQK/postgresql.conf" "-p" "5541" "-k" "/build/tmp.a766tZ8TQK/tmp" PostgreSQL is ready NOTICE: empty string is not a valid password, clearing password CREATE ROLE ALTER DATABASE Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/init-scripts/00000000000000-initial-schema.sql CREATE PUBLICATION ALTER ROLE CREATE ROLE CREATE ROLE GRANT ROLE GRANT CREATE ROLE GRANT ROLE CREATE ROLE GRANT ROLE ALTER ROLE ALTER ROLE ALTER ROLE ALTER ROLE ALTER ROLE ALTER 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/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/init-scripts/00000000000001-auth-schema.sql 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/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/init-scripts/00000000000002-storage-schema.sql CREATE SCHEMA CREATE ROLE ALTER ROLE GRANT DO Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/init-scripts/00000000000003-post-setup.sql 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 NOTICE: empty string is not a valid password, clearing password ALTER ROLE CREATE ROLE REVOKE CREATE SCHEMA CREATE FUNCTION REVOKE GRANT psql:/nix/store/0s4wf39csywl7iy2bchhiaqzcinrk17w-stat-extension:1: NOTICE: schema "extensions" already exists, skipping CREATE SCHEMA CREATE EXTENSION Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/10000000000000_demote-postgres.sql GRANT GRANT GRANT GRANT GRANT GRANT GRANT GRANT GRANT DO ALTER ROLE Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20211115181400_update-auth-permissions.sql 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/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20211118015519_create-realtime-schema.sql CREATE SCHEMA Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20211122051245_update-realtime-permissions.sql GRANT GRANT GRANT GRANT Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20211124212715_update-auth-owner.sql DO DO DO Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20211130151719_update-realtime-permissions.sql ALTER DEFAULT PRIVILEGES ALTER DEFAULT PRIVILEGES ALTER DEFAULT PRIVILEGES Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220118070449_enable-safeupdate-postgrest.sql ALTER ROLE Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220126121436_finer-postgrest-triggers.sql psql:/nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220126121436_finer-postgrest-triggers.sql:3: NOTICE: event trigger "api_restart" does not exist, skipping DROP EVENT TRIGGER psql:/nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-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/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-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/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-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/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220224211803_fix-postgrest-supautils.sql DO Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220317095840_pg_graphql.sql CREATE SCHEMA psql:/nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-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/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-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/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-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/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220321174452_fix-postgrest-alter-type-event-trigger.sql psql:/nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-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/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-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/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220322085208_gotrue-session-limit.sql ALTER ROLE Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220404205710_pg_graphql-on-by-default.sql CREATE FUNCTION CREATE FUNCTION CREATE FUNCTION psql:/nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220404205710_pg_graphql-on-by-default.sql:142: NOTICE: extension "pg_graphql" does not exist, skipping DROP EXTENSION DO Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220609081115_grant-supabase-auth-admin-and-supabase-storage-admin-to-postgres.sql GRANT ROLE Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220613123923_pg_graphql-pg-dump-perms.sql CREATE FUNCTION DROP EXTENSION DO Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220713082019_pg_cron-pg_net-temp-perms-fix.sql DO DO Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20221028101028_set_authenticator_timeout.sql ALTER ROLE Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20221103090837_revoke_admin.sql REVOKE ROLE Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20221207154255_create_pgsodium_and_vault.sql DO Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20230201083204_grant_auth_roles_to_postgres.sql GRANT ROLE Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20230224042246_grant_extensions_perms_for_postgres.sql GRANT GRANT GRANT ALTER DEFAULT PRIVILEGES ALTER DEFAULT PRIVILEGES ALTER DEFAULT PRIVILEGES Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20230306081037_grant_pg_monitor_to_postgres.sql GRANT ROLE Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20230327032006_grant_auth_roles_to_supabase_storage_admin.sql GRANT ROLE Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20230529180330_alter_api_roles_for_inherit.sql ALTER ROLE ALTER ROLE ALTER ROLE DO Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20231013070755_grant_authenticator_to_supabase_storage_admin.sql GRANT ROLE REVOKE ROLE Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20231017062225_grant_pg_graphql_permissions_for_custom_roles.sql CREATE FUNCTION DROP EXTENSION DO Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20231020085357_revoke_writes_on_cron_job_from_postgres.sql DO CREATE FUNCTION DROP EVENT TRIGGER ALTER FUNCTION CREATE EVENT TRIGGER Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20231130133139_set_lock_timeout_to_authenticator_role.sql ALTER ROLE Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20240124080435_alter_lo_export_lo_import_owner.sql ALTER FUNCTION ALTER FUNCTION ALTER FUNCTION Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20240606060239_grant_predefined_roles_to_postgres.sql GRANT ROLE Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20241031003909_create_orioledb.sql DO Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20241215003910_backfill_pgmq_metadata.sql DO DO Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20250205060043_disable_log_statement_on_internal_roles.sql ALTER ROLE ALTER ROLE ALTER ROLE Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20250205144616_move_orioledb_to_extensions_schema.sql DO Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20250218031949_pgsodium_mask_role.sql DO Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20250220051611_pg_net_perms_fix.sql CREATE FUNCTION DO Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20250312095419_pgbouncer_ownership.sql ALTER FUNCTION GRANT Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20250402065937_alter_internal_event_triggers_owner_to_supabase_admin.sql DROP EVENT TRIGGER ALTER FUNCTION CREATE EVENT TRIGGER Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20250402093753_grant_subscription_to_postgres_16_and_above.sql DO Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20250417190610_update_pgbouncer_get_auth.sql CREATE FUNCTION GRANT Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20250421084701_revoke_admin_roles_from_postgres.sql REVOKE ROLE DO DO REVOKE ROLE REVOKE DO Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20250605172253_grant_with_admin_to_postgres_16_and_above.sql DO Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20250623125453_tmp_grant_storage_tables_to_postgres_with_grant_option.sql DO Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20250709135250_grant_storage_schema_to_postgres_with_grant_option.sql DO Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20250710151649_supabase_read_only_user_default_transaction_read_only.sql ALTER ROLE Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20251001204436_predefined_role_grants.sql GRANT ROLE DO Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20251105172723_grant_pg_reload_conf_to_postgres.sql GRANT Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20251121132723_correct_search_path_pgbouncer.sql CREATE FUNCTION REVOKE REVOKE GRANT Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20260211120934_supabase_privileged_role.sql DO Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20260413000000_fix-authenticator-session-preload-libraries.sql ALTER ROLE Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20260421000000_pg_graphql-off-by-default.sql DROP EXTENSION Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20260421000001_rescope_pg_graphql_access_trigger.sql CREATE FUNCTION DROP EVENT TRIGGER CREATE EVENT TRIGGER Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20260730000000_revoke_trigger_on_cron_tables_from_postgres.sql DO CREATE FUNCTION Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20260923021047_update_pgrst_watch_triggers.sql CREATE FUNCTION CREATE FUNCTION Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20261016000001_search_path_for_supa_functions.sql CREATE FUNCTION CREATE FUNCTION CREATE FUNCTION CREATE FUNCTION CREATE FUNCTION CREATE FUNCTION 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: 1237) /nix/store/9cgb3iwg25krw3rchysinlgn6bvh36kc-postgresql-and-plugins-17.11/bin/postgres "-D" "/build/tmp.a766tZ8TQK" "--config-file=/build/tmp.a766tZ8TQK/postgresql.conf" "-p" "5541" "-k" "/build/tmp.a766tZ8TQK/tmp" $ pg_isready -h localhost -p 5541 -U supabase_admin -q 2026-11-12 10:20:58 [INFO] PostgreSQL is ready 2026-11-12 10:20:58 [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 SET CREATE EXTENSION CREATE EXTENSION CREATE EXTENSION CREATE EXTENSION 2026-11-12 10:20:58 [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; CREATE TABLE INSERT 0 1 INSERT 0 1 2026-11-12 10:20:58 [INFO] CLI variant detected - running subset of pg_regress tests (39 tests) $ pg_regress --use-existing --dbname=postgres --inputdir=/nix/store/68qn5zkm9ns9l6xyxvhxsy4d27a9r127-tests --outputdir=/nix/store/3jrms0m8j13h4lf6zzdq5yipi5d7l8ph-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_memberships supautils_reserved_roles vault wal2json z_17_intarray_ltree_query z_17_supabase_monitor_admin z_17_wal_summarize (using postmaster on localhost, port 5541) ============== running regression test queries ============== test auth ... ok 20 ms test create_statistics_priv ... ok 17 ms test dblink ... ok 58 ms test docs-array-test ... ok 20 ms test docs-cascades-deletes ... ok 152 ms test docs-connections ... ok 13 ms test docs-enums ... ok 67 ms test docs-full-text-search ... ok 45 ms test docs-functions ... ok 99 ms test docs-indexes ... ok 51 ms test docs-json ... ok 20 ms test docs-partitioning ... ok 62 ms test docs-tables-and-data ... ok 166 ms test docs-triggers ... ok 130 ms test docs-webhooks ... ok 100 ms test enable_tracking ... ok 16 ms test event_trigger_search_path ... ok 14 ms test intarray_ltree_query ... ok 109 ms test ltree_label_overflow ... ok 73 ms test multirange_create_priv ... ok 15 ms test operator_breaking_change ... ok 47 ms test pg-safeupdate ... ok 108 ms test pg_graphql ... ok 93 ms test pg_net ... ok 13 ms test pg_plan_filter ... ok 15 ms test pgaudit ... ok 22 ms test pgbouncer ... ok 37 ms test pgcrypto_cipher_matrix ... ok 28 ms test pgsodium ... ok 15 ms test realtime ... ok 10 ms test replica_identity_upsert ... ok 18 ms test storage ... ok 26 ms test supautils_reserved_memberships ... ok 12 ms test supautils_reserved_roles ... ok 14 ms test vault ... ok 49 ms test wal2json ... ok 59 ms test z_17_intarray_ltree_query ... ok 67 ms test z_17_supabase_monitor_admin ... FAILED 41 ms test z_17_wal_summarize ... ok 11 ms ======================= 1 of 39 tests failed. ======================= The differences that caused some tests to fail can be viewed in the file "/nix/store/3jrms0m8j13h4lf6zzdq5yipi5d7l8ph-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/3jrms0m8j13h4lf6zzdq5yipi5d7l8ph-run-check-harness-psql-17-cli/regression_output/regression.out". 2026-11-12 10:21:01 [ERROR] pg_regress tests failed 2026-11-12 10:21:01 [ERROR] An error occurred. Exit code: 1 2026-11-12 10:21:01 [ERROR] Debug logs: