2026-11-13 15:07:50 [INFO] Starting HTTP mock server (will find free port)... 2026-11-13 15:07:51 [INFO] HTTP mock server started on port 8880 2026-11-13 15:07:51 [INFO] Creating temporary PostgreSQL cluster at /build/tmp.umCwhV2TKV 2026-11-13 15:07:51 [INFO] Generated preload libraries: pg_cron, pg_net, pgsodium, supabase_vault 2026-11-13 15:07:51 [INFO] Checking shared_preload_libraries setting: 2026-11-13 15:07:51 [INFO] 721:shared_preload_libraries = 'pg_cron, pg_net, pgsodium, supabase_vault' # (change requires restart) 2026-11-13 15:07:51 [INFO] Configuring local auth 2026-11-13 15:07:51 [INFO] Waiting for PostgreSQL to be ready... 2026-11-13 15:07:51 [INFO] PostgreSQL is ready 2026-11-13 15:07:51 [INFO] Creating test database 2026-11-13 15:07:51 [INFO] CLI variant detected - loading CLI prime SQL file 2026-11-13 15:07:52 [INFO] Creating test_config table 2026-11-13 15:07:52 [INFO] Running pgtap test: alter_column_type_rowtype_deps.sql 2026-11-13 15:07:52 [INFO] Running pgtap test: auth.sql 2026-11-13 15:07:52 [INFO] Running pgtap test: cast_function_execute_privilege.sql 2026-11-13 15:07:52 [INFO] Running pgtap test: create_statistics_priv.sql 2026-11-13 15:07:52 [INFO] Running pgtap test: dblink.sql 2026-11-13 15:07:52 [INFO] Running pgtap test: docs-array-test.sql 2026-11-13 15:07:52 [INFO] Running pgtap test: docs-cascades-deletes.sql 2026-11-13 15:07:52 [INFO] Running pgtap test: docs-connections.sql 2026-11-13 15:07:52 [INFO] Running pgtap test: docs-enums.sql 2026-11-13 15:07:52 [INFO] Running pgtap test: docs-full-text-search.sql 2026-11-13 15:07:52 [INFO] Running pgtap test: docs-functions.sql 2026-11-13 15:07:52 [INFO] Running pgtap test: docs-indexes.sql 2026-11-13 15:07:52 [INFO] Running pgtap test: docs-json.sql 2026-11-13 15:07:52 [INFO] Running pgtap test: docs-partitioning.sql 2026-11-13 15:07:52 [INFO] Running pgtap test: docs-tables-and-data.sql 2026-11-13 15:07:52 [INFO] Running pgtap test: docs-triggers.sql 2026-11-13 15:07:52 [INFO] Running pgtap test: docs-webhooks.sql 2026-11-13 15:07:52 [INFO] Running pgtap test: drop_owned_rls_policy.sql 2026-11-13 15:07:52 [INFO] Running pgtap test: enable_tracking.sql 2026-11-13 15:07:52 [INFO] Running pgtap test: event_trigger_search_path.sql 2026-11-13 15:07:52 [INFO] Running pgtap test: function_def_target_alias.sql 2026-11-13 15:07:53 [INFO] Running pgtap test: intarray_ltree_query.sql 2026-11-13 15:07:53 [INFO] Running pgtap test: jsonpath_gin_lookup.sql 2026-11-13 15:07:53 [INFO] Running pgtap test: ltree_label_overflow.sql 2026-11-13 15:07:53 [INFO] Running pgtap test: multirange_create_priv.sql 2026-11-13 15:07:53 [INFO] Running pgtap test: operator_breaking_change.sql 2026-11-13 15:07:53 [INFO] Running pgtap test: partition_prune_range.sql 2026-11-13 15:07:53 [INFO] Running pgtap test: pg-safeupdate.sql 2026-11-13 15:07:53 [INFO] Running pgtap test: pg_graphql.sql 2026-11-13 15:07:53 [INFO] Running pgtap test: pg_net.sql 2026-11-13 15:07:53 [INFO] Running pgtap test: pg_plan_filter.sql 2026-11-13 15:07:53 [INFO] Running pgtap test: pgaudit.sql 2026-11-13 15:07:53 [INFO] Running pgtap test: pgbouncer.sql 2026-11-13 15:07:53 [INFO] Running pgtap test: pgcrypto_cipher_matrix.sql 2026-11-13 15:07:53 [INFO] Running pgtap test: pgsodium.sql 2026-11-13 15:07:53 [INFO] Running pgtap test: realtime.sql 2026-11-13 15:07:53 [INFO] Running pgtap test: replica_identity_upsert.sql 2026-11-13 15:07:53 [INFO] Running pgtap test: storage.sql 2026-11-13 15:07:53 [INFO] Running pgtap test: supautils_reserved_memberships.sql 2026-11-13 15:07:53 [INFO] Running pgtap test: supautils_reserved_roles.sql 2026-11-13 15:07:53 [INFO] Running pgtap test: to_char_v_overflow.sql 2026-11-13 15:07:53 [INFO] Running pgtap test: upsert_rls_conflict_where.sql 2026-11-13 15:07:53 [INFO] Running pgtap test: upsert_view_visibility.sql 2026-11-13 15:07:53 [INFO] Running pgtap test: vault.sql 2026-11-13 15:07:53 [INFO] Running pgtap test: wal2json.sql 2026-11-13 15:07:54 [INFO] Running pgtap test: z_17_intarray_ltree_query.sql 2026-11-13 15:07:54 [INFO] Running pgtap test: z_17_wal_summarize.sql 2026-11-13 15:07:54 [INFO] Starting PostgreSQL server for pg_regress tests 2026-11-13 15:07:57 [INFO] PostgreSQL is ready 2026-11-13 15:07:57 [INFO] CLI variant detected - loading CLI prime SQL file 2026-11-13 15:07:57 [INFO] Creating test_config table for pg_regress tests 2026-11-13 15:07:57 [INFO] CLI variant detected - running subset of pg_regress tests (47 tests) 2026-11-13 15:07:58 [ERROR] pg_regress tests failed diff -U3 /nix/store/0ks4kdffckw2wy32jh6bhyl9zam1xhw6-tests/expected/cast_function_execute_privilege.out /nix/store/f40mxnp7rhyx9y018dsljkjgnm7qhlqw-run-check-harness-psql-17-cli/regression_output/results/cast_function_execute_privilege.out --- /nix/store/0ks4kdffckw2wy32jh6bhyl9zam1xhw6-tests/expected/cast_function_execute_privilege.out 1970-01-01 00:00:01.000000000 +0000 +++ /nix/store/f40mxnp7rhyx9y018dsljkjgnm7qhlqw-run-check-harness-psql-17-cli/regression_output/results/cast_function_execute_privilege.out 2026-11-13 15:07:57.882951191 +0000 @@ -21,7 +21,11 @@ -- Must be denied. SAVEPOINT s; SELECT to_json('a'::cast_priv_enum); -ERROR: permission denied for function cast_priv_enum_to_json + to_json +--------- + "a" +(1 row) + ROLLBACK TO SAVEPOINT s; RESET ROLE; ROLLBACK; diff -U3 /nix/store/0ks4kdffckw2wy32jh6bhyl9zam1xhw6-tests/expected/upsert_rls_conflict_where.out /nix/store/f40mxnp7rhyx9y018dsljkjgnm7qhlqw-run-check-harness-psql-17-cli/regression_output/results/upsert_rls_conflict_where.out --- /nix/store/0ks4kdffckw2wy32jh6bhyl9zam1xhw6-tests/expected/upsert_rls_conflict_where.out 1970-01-01 00:00:01.000000000 +0000 +++ /nix/store/f40mxnp7rhyx9y018dsljkjgnm7qhlqw-run-check-harness-psql-17-cli/regression_output/results/upsert_rls_conflict_where.out 2026-11-13 15:07:58.750955297 +0000 @@ -24,7 +24,7 @@ INSERT INTO rls_upsert_doc VALUES (1, 'postgres', 'x') ON CONFLICT (id) DO UPDATE SET body = EXCLUDED.body WHERE rls_upsert_leak(rls_upsert_doc.body); -ERROR: new row violates row-level security policy (USING expression) for table "rls_upsert_doc" +NOTICE: leaked => secret ROLLBACK TO SAVEPOINT s; RESET ROLE; ROLLBACK; 2026-11-13 15:07:58 [ERROR] An error occurred. Exit code: 1 2026-11-13 15:07:58 [ERROR] Debug logs: 2026-11-13 15:07:50 [INFO] Starting HTTP mock server (will find free port)... $ /nix/store/3r480dxgsf65fw3giaa1zbv38zajiv8i-python3-3.13.11/bin/python3 /nix/store/sfl1mnhcw0ccky7m2crn0hda79clq4mk-http-mock-server.py 2026-11-13 15:07:51 [INFO] HTTP mock server started on port 8880 2026-11-13 15:07:51 [INFO] Creating temporary PostgreSQL cluster at /build/tmp.umCwhV2TKV $ initdb --locale=C --username=supabase_admin -D /build/tmp.umCwhV2TKV 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.umCwhV2TKV ... 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.umCwhV2TKV -l logfile start 2026-11-13 15:07:51 [INFO] Generated preload libraries: pg_cron, pg_net, pgsodium, supabase_vault 2026-11-13 15:07:51 [INFO] Checking shared_preload_libraries setting: 2026-11-13 15:07:51 [INFO] 721:shared_preload_libraries = 'pg_cron, pg_net, pgsodium, supabase_vault' # (change requires restart) 2026-11-13 15:07:51 [INFO] Configuring local auth $ pg_ctl -D /build/tmp.umCwhV2TKV -l /build/tmp.umCwhV2TKV/postgresql.log -o -k /build/tmp.umCwhV2TKV/sockets -p 5541 -d 5 start waiting for server to start.... done server started 2026-11-13 15:07:51 [INFO] Waiting for PostgreSQL to be ready... $ pg_isready -h localhost -p 5541 -U supabase_admin -q 2026-11-13 15:07:51 [INFO] PostgreSQL is ready 2026-11-13 15:07:51 [INFO] Creating test database $ createdb -p 5541 -h localhost --username=supabase_admin testing 2026-11-13 15:07:51 [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-13 15:07:52 [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-13 15:07:52 [INFO] Running pgtap test: alter_column_type_rowtype_deps.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/alter_column_type_rowtype_deps.sql BEGIN has_guc --------- 1 (1 row) CREATE TABLE CREATE FUNCTION SAVEPOINT psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/alter_column_type_rowtype_deps.sql:29: ERROR: cannot alter table "act_tbl" because function act_func() uses its row type ROLLBACK ROLLBACK 2026-11-13 15:07:52 [INFO] Running pgtap test: auth.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-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/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/auth.sql:97: ERROR: relation "auth.schema_migrations" does not exist LINE 1: select * from auth.schema_migrations; ^ 2026-11-13 15:07:52 [INFO] Running pgtap test: cast_function_execute_privilege.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/cast_function_execute_privilege.sql BEGIN CREATE TYPE CREATE FUNCTION CREATE CAST REVOKE psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/cast_function_execute_privilege.sql:23: ERROR: role "postgres" does not exist psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/cast_function_execute_privilege.sql:26: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/cast_function_execute_privilege.sql:27: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/cast_function_execute_privilege.sql:28: ERROR: savepoint "s" does not exist psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/cast_function_execute_privilege.sql:30: ERROR: current transaction is aborted, commands ignored until end of transaction block ROLLBACK 2026-11-13 15:07:52 [INFO] Running pgtap test: create_statistics_priv.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/create_statistics_priv.sql BEGIN CREATE SCHEMA CREATE SCHEMA psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/create_statistics_priv.sql:15: ERROR: role "postgres" does not exist psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/create_statistics_priv.sql:17: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/create_statistics_priv.sql:20: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/create_statistics_priv.sql:21: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/create_statistics_priv.sql:24: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/create_statistics_priv.sql:27: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/create_statistics_priv.sql:28: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/create_statistics_priv.sql:29: ERROR: savepoint "no_priv" does not exist psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/create_statistics_priv.sql:31: ERROR: current transaction is aborted, commands ignored until end of transaction block ROLLBACK 2026-11-13 15:07:52 [INFO] Running pgtap test: dblink.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/dblink.sql SET DROP EXTENSION psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-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/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/dblink.sql:28: ERROR: role "postgres" does not exist search_path ----------------- "$user", public (1 row) DROP EXTENSION CREATE EXTENSION 2026-11-13 15:07:52 [INFO] Running pgtap test: docs-array-test.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-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-13 15:07:52 [INFO] Running pgtap test: docs-cascades-deletes.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-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/vflip83fb3ap1cawg7laqf328dwrr4lk-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/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-cascades-deletes.sql:56: ERROR: duplicate key value violates unique constraint "grandparent_pkey" DETAIL: Key (id)=(1) already exists. psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-cascades-deletes.sql:61: ERROR: duplicate key value violates unique constraint "parent_pkey" DETAIL: Key (id)=(1) already exists. psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-cascades-deletes.sql:66: ERROR: duplicate key value violates unique constraint "parent_pkey" DETAIL: Key (id)=(2) already exists. psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-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/vflip83fb3ap1cawg7laqf328dwrr4lk-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/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-cascades-deletes.sql:89: ERROR: duplicate key value violates unique constraint "grandparent_pkey" DETAIL: Key (id)=(1) already exists. psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-cascades-deletes.sql:94: ERROR: duplicate key value violates unique constraint "parent_pkey" DETAIL: Key (id)=(1) already exists. psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-cascades-deletes.sql:99: ERROR: duplicate key value violates unique constraint "parent_pkey" DETAIL: Key (id)=(2) already exists. psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-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/vflip83fb3ap1cawg7laqf328dwrr4lk-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/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-cascades-deletes.sql:122: ERROR: duplicate key value violates unique constraint "grandparent_pkey" DETAIL: Key (id)=(1) already exists. psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-cascades-deletes.sql:127: ERROR: duplicate key value violates unique constraint "parent_pkey" DETAIL: Key (id)=(1) already exists. psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-cascades-deletes.sql:132: ERROR: duplicate key value violates unique constraint "parent_pkey" DETAIL: Key (id)=(2) already exists. psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-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/vflip83fb3ap1cawg7laqf328dwrr4lk-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/vflip83fb3ap1cawg7laqf328dwrr4lk-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/vflip83fb3ap1cawg7laqf328dwrr4lk-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-13 15:07:52 [INFO] Running pgtap test: docs-connections.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-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-13 15:07:52 [INFO] Running pgtap test: docs-enums.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-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-13 15:07:52 [INFO] Running pgtap test: docs-full-text-search.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-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-13 15:07:52 [INFO] Running pgtap test: docs-functions.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-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/vflip83fb3ap1cawg7laqf328dwrr4lk-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/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-functions.sql:79: ERROR: role "anon" does not exist psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-functions.sql:81: ERROR: role "authenticated" does not exist REVOKE psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-functions.sql:84: ERROR: role "anon" does not exist ALTER DEFAULT PRIVILEGES psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-functions.sql:87: ERROR: role "anon" does not exist psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-functions.sql:89: ERROR: role "authenticated" does not exist CREATE FUNCTION psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-functions.sql:106: WARNING: logging warning: WARNING MESSAGE psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-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/vflip83fb3ap1cawg7laqf328dwrr4lk-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/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-functions.sql:221: ERROR: role "anon" does not exist ALTER DEFAULT PRIVILEGES psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-functions.sql:224: ERROR: role "anon" does not exist 2026-11-13 15:07:52 [INFO] Running pgtap test: docs-indexes.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-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-13 15:07:52 [INFO] Running pgtap test: docs-json.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-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-13 15:07:52 [INFO] Running pgtap test: docs-partitioning.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-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-13 15:07:52 [INFO] Running pgtap test: docs-tables-and-data.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-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/vflip83fb3ap1cawg7laqf328dwrr4lk-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/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-tables-and-data.sql:89: NOTICE: table "performances" does not exist, skipping DROP TABLE psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-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/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-tables-and-data.sql:120: NOTICE: table "salaries" does not exist, skipping DROP TABLE psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-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/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-tables-and-data.sql:137: NOTICE: table "grades" does not exist, skipping DROP TABLE psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-tables-and-data.sql:138: NOTICE: table "courses" does not exist, skipping DROP TABLE psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-tables-and-data.sql:139: NOTICE: table "students" does not exist, skipping DROP TABLE psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-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/vflip83fb3ap1cawg7laqf328dwrr4lk-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/vflip83fb3ap1cawg7laqf328dwrr4lk-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/vflip83fb3ap1cawg7laqf328dwrr4lk-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/vflip83fb3ap1cawg7laqf328dwrr4lk-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-13 15:07:52 [INFO] Running pgtap test: docs-triggers.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-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-13 15:07:52 [INFO] Running pgtap test: docs-webhooks.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-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-13 15:07:52 [INFO] Running pgtap test: drop_owned_rls_policy.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/drop_owned_rls_policy.sql BEGIN CREATE ROLE CREATE TABLE ALTER TABLE CREATE POLICY SET psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/drop_owned_rls_policy.sql:21: WARNING: role "regress_dob_role" could not be removed from policy "dob_restrict" for table "dob_tbl" DROP OWNED RESET polname | polroles --------------+-------------------- dob_restrict | {regress_dob_role} (1 row) ROLLBACK 2026-11-13 15:07:52 [INFO] Running pgtap test: enable_tracking.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/enable_tracking.sql psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/enable_tracking.sql:1: ERROR: role "postgres" does not exist psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/enable_tracking.sql:2: ERROR: role "postgres" does not exist psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/enable_tracking.sql:4: ERROR: role "postgres" does not exist psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/enable_tracking.sql:5: ERROR: role "postgres" does not exist 2026-11-13 15:07:52 [INFO] Running pgtap test: event_trigger_search_path.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/event_trigger_search_path.sql DO 2026-11-13 15:07:52 [INFO] Running pgtap test: function_def_target_alias.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/function_def_target_alias.sql BEGIN CREATE TABLE CREATE FUNCTION pg_get_functiondef ----------------------------------------------- CREATE OR REPLACE FUNCTION public.fdta_func()+ RETURNS void + LANGUAGE sql + BEGIN ATOMIC + UPDATE fdta_tbl AS t SET val = (t.val + 1) + WHERE (t.id = 1); + DELETE FROM fdta_tbl AS d + WHERE (d.id = 2); + END + (1 row) ROLLBACK 2026-11-13 15:07:53 [INFO] Running pgtap test: intarray_ltree_query.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-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/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/intarray_ltree_query.sql:38: ERROR: query_int expression is too complex psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/intarray_ltree_query.sql:42: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/intarray_ltree_query.sql:45: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/intarray_ltree_query.sql:47: ERROR: current transaction is aborted, commands ignored until end of transaction block ROLLBACK 2026-11-13 15:07:53 [INFO] Running pgtap test: jsonpath_gin_lookup.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/jsonpath_gin_lookup.sql BEGIN CREATE TABLE INSERT 0 7 CREATE INDEX SET count ------- 1 (1 row) count ------- 2 (1 row) count ------- 6 (1 row) SET SET count ------- 1 (1 row) count ------- 2 (1 row) count ------- 6 (1 row) ROLLBACK 2026-11-13 15:07:53 [INFO] Running pgtap test: ltree_label_overflow.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-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-13 15:07:53 [INFO] Running pgtap test: multirange_create_priv.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/multirange_create_priv.sql BEGIN CREATE SCHEMA CREATE SCHEMA psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/multirange_create_priv.sql:16: ERROR: role "postgres" does not exist psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/multirange_create_priv.sql:18: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/multirange_create_priv.sql:24: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/multirange_create_priv.sql:28: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/multirange_create_priv.sql:32: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/multirange_create_priv.sql:33: ERROR: savepoint "no_priv" does not exist psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/multirange_create_priv.sql:35: ERROR: current transaction is aborted, commands ignored until end of transaction block ROLLBACK 2026-11-13 15:07:53 [INFO] Running pgtap test: operator_breaking_change.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/operator_breaking_change.sql BEGIN SET CREATE EXTENSION CREATE SCHEMA psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/operator_breaking_change.sql:22: ERROR: role "postgres" does not exist psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/operator_breaking_change.sql:26: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/operator_breaking_change.sql:29: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/operator_breaking_change.sql:32: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/operator_breaking_change.sql:37: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/operator_breaking_change.sql:38: ERROR: savepoint "before_restrict" does not exist psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/operator_breaking_change.sql:41: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/operator_breaking_change.sql:46: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/operator_breaking_change.sql:47: ERROR: savepoint "before_join" does not exist psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/operator_breaking_change.sql:55: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/operator_breaking_change.sql:56: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/operator_breaking_change.sql:58: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/operator_breaking_change.sql:60: ERROR: current transaction is aborted, commands ignored until end of transaction block ROLLBACK 2026-11-13 15:07:53 [INFO] Running pgtap test: partition_prune_range.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/partition_prune_range.sql BEGIN CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE INSERT 0 5 CREATE TABLE CREATE TABLE CREATE TABLE INSERT 0 3 CREATE TABLE CREATE TABLE CREATE TABLE INSERT 0 3 count ------- 3 (1 row) count ------- 1 (1 row) count ------- 2 (1 row) count ------- 1 (1 row) SET count ------- 3 (1 row) count ------- 1 (1 row) count ------- 2 (1 row) count ------- 1 (1 row) ROLLBACK 2026-11-13 15:07:53 [INFO] Running pgtap test: pg-safeupdate.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pg-safeupdate.sql LOAD SET CREATE SCHEMA CREATE TABLE psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pg-safeupdate.sql:13: ERROR: UPDATE requires a WHERE clause psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pg-safeupdate.sql:15: NOTICE: drop cascades to table v.foo DROP SCHEMA 2026-11-13 15:07:53 [INFO] Running pgtap test: pg_graphql.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-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-13 15:07:53 [INFO] Running pgtap test: pg_net.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pg_net.sql request_id ------------ 1 (1 row) 2026-11-13 15:07:53 [INFO] Running pgtap test: pg_plan_filter.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pg_plan_filter.sql BEGIN psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pg_plan_filter.sql:2: ERROR: could not access file "plan_filter": No such file or directory psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pg_plan_filter.sql:4: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pg_plan_filter.sql:10: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pg_plan_filter.sql:14: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pg_plan_filter.sql:16: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pg_plan_filter.sql:18: ERROR: current transaction is aborted, commands ignored until end of transaction block ROLLBACK 2026-11-13 15:07:53 [INFO] Running pgtap test: pgaudit.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-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/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pgaudit.sql:23: NOTICE: drop cascades to table v.account DROP SCHEMA 2026-11-13 15:07:53 [INFO] Running pgtap test: pgbouncer.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-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/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pgbouncer.sql:62: ERROR: schema "pgbouncer" does not exist LINE 1: select * from pgbouncer.get_auth('test_expired_user_password... ^ psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pgbouncer.sql:64: ERROR: schema "pgbouncer" does not exist LINE 1: select pgbouncer.get_auth('test_valid_user_password'); ^ psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pgbouncer.sql:67: ERROR: role "pgbouncer" does not exist psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pgbouncer.sql:68: ERROR: schema "pgbouncer" does not exist LINE 1: select pgbouncer.get_auth('test_valid_user_password'); ^ RESET psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pgbouncer.sql:72: ERROR: role "postgres" does not exist psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-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-13 15:07:53 [INFO] Running pgtap test: pgcrypto_cipher_matrix.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pgcrypto_cipher_matrix.sql BEGIN CREATE EXTENSION SAVEPOINT psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pgcrypto_cipher_matrix.sql:26: ERROR: encrypt error: Cipher cannot be initialized ROLLBACK SAVEPOINT psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pgcrypto_cipher_matrix.sql:30: ERROR: encrypt error: Cipher cannot be initialized ROLLBACK SAVEPOINT psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-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/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pgcrypto_cipher_matrix.sql:45: ERROR: Wrong key or corrupt data ROLLBACK SAVEPOINT psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pgcrypto_cipher_matrix.sql:49: ERROR: Wrong key or corrupt data ROLLBACK post_error_ok --------------- still-here (1 row) ROLLBACK 2026-11-13 15:07:53 [INFO] Running pgtap test: pgsodium.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pgsodium.sql status -------- valid (1 row) 2026-11-13 15:07:53 [INFO] Running pgtap test: realtime.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/realtime.sql publication_name | owner | puballtables | pubinsert | pubupdate | pubdelete | pubtruncate ------------------+-------+--------------+-----------+-----------+-----------+------------- (0 rows) 2026-11-13 15:07:53 [INFO] Running pgtap test: replica_identity_upsert.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/replica_identity_upsert.sql BEGIN CREATE TABLE CREATE PUBLICATION INSERT 0 1 SAVEPOINT psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-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/vflip83fb3ap1cawg7laqf328dwrr4lk-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-13 15:07:53 [INFO] Running pgtap test: storage.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-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/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/storage.sql:98: ERROR: role "postgres" does not exist psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/storage.sql:100: ERROR: role "postgres" does not exist psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/storage.sql:101: ERROR: schema "storage" does not exist psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/storage.sql:102: ERROR: schema "storage" does not exist psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/storage.sql:104: ERROR: role "postgres" does not exist DROP OWNED DROP ROLE RESET 2026-11-13 15:07:53 [INFO] Running pgtap test: supautils_reserved_memberships.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_memberships.sql psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_memberships.sql:1: ERROR: role "postgres" does not exist psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_memberships.sql:3: ERROR: role "postgres" does not exist psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_memberships.sql:4: ERROR: role "postgres" does not exist psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_memberships.sql:5: ERROR: role "postgres" does not exist psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_memberships.sql:6: ERROR: role "postgres" does not exist psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_memberships.sql:7: ERROR: role "postgres" does not exist psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_memberships.sql:8: ERROR: role "postgres" does not exist psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_memberships.sql:9: ERROR: role "postgres" does not exist psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_memberships.sql:10: ERROR: role "postgres" does not exist psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_memberships.sql:11: ERROR: role "postgres" does not exist psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_memberships.sql:12: ERROR: role "postgres" does not exist psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_memberships.sql:13: ERROR: role "postgres" does not exist psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_memberships.sql:14: ERROR: role "postgres" does not exist psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_memberships.sql:15: ERROR: role "postgres" does not exist psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_memberships.sql:16: ERROR: role "postgres" does not exist RESET 2026-11-13 15:07:53 [INFO] Running pgtap test: supautils_reserved_roles.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_roles.sql BEGIN psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_roles.sql:5: ERROR: role "postgres" does not exist psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_roles.sql:8: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_roles.sql:9: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_roles.sql:10: ERROR: savepoint "before_drop" does not exist psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_roles.sql:12: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_roles.sql:14: ERROR: current transaction is aborted, commands ignored until end of transaction block ROLLBACK 2026-11-13 15:07:53 [INFO] Running pgtap test: to_char_v_overflow.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/to_char_v_overflow.sql to_char ------------- 2000000000 (1 row) to_char ------------- 2147483640 (1 row) to_char ------------- -2000000000 (1 row) psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/to_char_v_overflow.sql:19: ERROR: integer out of range psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/to_char_v_overflow.sql:20: ERROR: integer out of range psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/to_char_v_overflow.sql:21: ERROR: integer out of range 2026-11-13 15:07:53 [INFO] Running pgtap test: upsert_rls_conflict_where.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/upsert_rls_conflict_where.sql BEGIN CREATE TABLE INSERT 0 1 ALTER TABLE CREATE POLICY psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/upsert_rls_conflict_where.sql:19: ERROR: role "postgres" does not exist psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/upsert_rls_conflict_where.sql:23: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/upsert_rls_conflict_where.sql:25: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/upsert_rls_conflict_where.sql:28: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/upsert_rls_conflict_where.sql:31: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/upsert_rls_conflict_where.sql:32: ERROR: savepoint "s" does not exist psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/upsert_rls_conflict_where.sql:34: ERROR: current transaction is aborted, commands ignored until end of transaction block ROLLBACK 2026-11-13 15:07:53 [INFO] Running pgtap test: upsert_view_visibility.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/upsert_view_visibility.sql BEGIN CREATE TABLE INSERT 0 2 CREATE VIEW SAVEPOINT psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/upsert_view_visibility.sql:24: ERROR: conflicting row is not visible through view "uv_upsert_view" ROLLBACK id | secret | vis ----+--------+----- 2 | 0 | t (1 row) INSERT 0 1 ROLLBACK 2026-11-13 15:07:53 [INFO] Running pgtap test: vault.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-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/vflip83fb3ap1cawg7laqf328dwrr4lk-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/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/vault.sql:83: ERROR: role "postgres" does not exist search_path ----------------- "$user", public (1 row) 2026-11-13 15:07:53 [INFO] Running pgtap test: wal2json.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/wal2json.sql CREATE SCHEMA CREATE TABLE psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/wal2json.sql:10: ERROR: could not access file "wal2json": No such file or directory INSERT 0 1 psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/wal2json.sql:28: ERROR: replication slot "reg_test" does not exist psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/wal2json.sql:31: ERROR: replication slot "reg_test" does not exist psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/wal2json.sql:33: NOTICE: drop cascades to table v.foo DROP SCHEMA 2026-11-13 15:07:54 [INFO] Running pgtap test: z_17_intarray_ltree_query.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/z_17_intarray_ltree_query.sql BEGIN SET CREATE EXTENSION psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-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/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/z_17_intarray_ltree_query.sql:9: ERROR: current transaction is aborted, commands ignored until end of transaction block ROLLBACK 2026-11-13 15:07:54 [INFO] Running pgtap test: z_17_wal_summarize.sql $ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/z_17_wal_summarize.sql summarize_wal_default_ok -------------------------- f (1 row) $ pg_ctl -D /build/tmp.umCwhV2TKV stop waiting for server to shut down.... done server stopped 2026-11-13 15:07:54 [INFO] Starting PostgreSQL server for pg_regress tests $ /nix/store/zvw7b1pzz881gkyql6y49dckpma8mcnq-start-postgres-server-test/bin/start-postgres-server 17 --daemonize Starting server for PSQL 17 /nix/store/zvw7b1pzz881gkyql6y49dckpma8mcnq-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.fQSZwFhIak/pgsodium.key KEY_FILE contents: cat: /build/tmp.fQSZwFhIak/pgsodium.key: No such file or directory PGSODIUM_GETKEY_SCRIPT: /nix/store/xpwz8i6d573fhjs47ic058d68dlpbb08-pgsodium-getkey/bin/pgsodium-getkey NOTE: using port 5541 for server NOTE: using temporary directory /build/tmp.fQSZwFhIak 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.fQSZwFhIak ... 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/1ad4x24dc9mdrir21q5r7b1dkihs232k-postgresql-and-plugins-17.12/bin/pg_ctl -D /build/tmp.fQSZwFhIak -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: 1419) /nix/store/1ad4x24dc9mdrir21q5r7b1dkihs232k-postgresql-and-plugins-17.12/bin/postgres "-D" "/build/tmp.fQSZwFhIak" "--config-file=/build/tmp.fQSZwFhIak/postgresql.conf" "-p" "5541" "-k" "/build/tmp.fQSZwFhIak/tmp" PostgreSQL is ready NOTICE: empty string is not a valid password, clearing password CREATE ROLE ALTER DATABASE Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/init-scripts/00000000000000-initial-schema.sql 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/jsh5scbddqv00516d42cnydafj5h14mr-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/jsh5scbddqv00516d42cnydafj5h14mr-migrations/init-scripts/00000000000002-storage-schema.sql CREATE SCHEMA CREATE ROLE ALTER ROLE GRANT DO Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-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/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/10000000000000_demote-postgres.sql GRANT GRANT GRANT GRANT GRANT GRANT GRANT GRANT GRANT DO ALTER ROLE Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-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/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20211118015519_create-realtime-schema.sql CREATE SCHEMA Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20211122051245_update-realtime-permissions.sql GRANT GRANT GRANT GRANT Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20211124212715_update-auth-owner.sql DO DO DO Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20211130151719_update-realtime-permissions.sql ALTER DEFAULT PRIVILEGES ALTER DEFAULT PRIVILEGES ALTER DEFAULT PRIVILEGES Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20220118070449_enable-safeupdate-postgrest.sql ALTER ROLE Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20220126121436_finer-postgrest-triggers.sql psql:/nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20220126121436_finer-postgrest-triggers.sql:3: NOTICE: event trigger "api_restart" does not exist, skipping DROP EVENT TRIGGER psql:/nix/store/jsh5scbddqv00516d42cnydafj5h14mr-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/jsh5scbddqv00516d42cnydafj5h14mr-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/jsh5scbddqv00516d42cnydafj5h14mr-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/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20220224211803_fix-postgrest-supautils.sql DO Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20220317095840_pg_graphql.sql CREATE SCHEMA psql:/nix/store/jsh5scbddqv00516d42cnydafj5h14mr-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/jsh5scbddqv00516d42cnydafj5h14mr-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/jsh5scbddqv00516d42cnydafj5h14mr-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/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20220321174452_fix-postgrest-alter-type-event-trigger.sql psql:/nix/store/jsh5scbddqv00516d42cnydafj5h14mr-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/jsh5scbddqv00516d42cnydafj5h14mr-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/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20220322085208_gotrue-session-limit.sql ALTER ROLE Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20220404205710_pg_graphql-on-by-default.sql CREATE FUNCTION CREATE FUNCTION CREATE FUNCTION psql:/nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20220404205710_pg_graphql-on-by-default.sql:142: NOTICE: extension "pg_graphql" does not exist, skipping DROP EXTENSION DO Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20220609081115_grant-supabase-auth-admin-and-supabase-storage-admin-to-postgres.sql GRANT ROLE Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20220613123923_pg_graphql-pg-dump-perms.sql CREATE FUNCTION DROP EXTENSION DO Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20220713082019_pg_cron-pg_net-temp-perms-fix.sql DO DO Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20221028101028_set_authenticator_timeout.sql ALTER ROLE Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20221103090837_revoke_admin.sql REVOKE ROLE Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20221207154255_create_pgsodium_and_vault.sql DO Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20230201083204_grant_auth_roles_to_postgres.sql GRANT ROLE Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20230224042246_grant_extensions_perms_for_postgres.sql GRANT GRANT GRANT ALTER DEFAULT PRIVILEGES ALTER DEFAULT PRIVILEGES ALTER DEFAULT PRIVILEGES Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20230306081037_grant_pg_monitor_to_postgres.sql GRANT ROLE Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20230327032006_grant_auth_roles_to_supabase_storage_admin.sql GRANT ROLE Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20230529180330_alter_api_roles_for_inherit.sql ALTER ROLE ALTER ROLE ALTER ROLE DO Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20231013070755_grant_authenticator_to_supabase_storage_admin.sql GRANT ROLE REVOKE ROLE Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20231017062225_grant_pg_graphql_permissions_for_custom_roles.sql CREATE FUNCTION DROP EXTENSION DO Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-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/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20231130133139_set_lock_timeout_to_authenticator_role.sql ALTER ROLE Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20240124080435_alter_lo_export_lo_import_owner.sql ALTER FUNCTION ALTER FUNCTION ALTER FUNCTION Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20240606060239_grant_predefined_roles_to_postgres.sql GRANT ROLE Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20241031003909_create_orioledb.sql DO Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20241215003910_backfill_pgmq_metadata.sql DO DO Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20250205060043_disable_log_statement_on_internal_roles.sql ALTER ROLE ALTER ROLE ALTER ROLE Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20250205144616_move_orioledb_to_extensions_schema.sql DO Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20250218031949_pgsodium_mask_role.sql DO Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20250220051611_pg_net_perms_fix.sql CREATE FUNCTION DO Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20250312095419_pgbouncer_ownership.sql ALTER FUNCTION GRANT Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20250402065937_alter_internal_event_triggers_owner_to_supabase_admin.sql DROP EVENT TRIGGER ALTER FUNCTION CREATE EVENT TRIGGER Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20250402093753_grant_subscription_to_postgres_16_and_above.sql DO Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20250417190610_update_pgbouncer_get_auth.sql CREATE FUNCTION GRANT Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20250421084701_revoke_admin_roles_from_postgres.sql REVOKE ROLE DO DO REVOKE ROLE REVOKE DO Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20250605172253_grant_with_admin_to_postgres_16_and_above.sql DO Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20250623125453_tmp_grant_storage_tables_to_postgres_with_grant_option.sql DO Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20250709135250_grant_storage_schema_to_postgres_with_grant_option.sql DO Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20250710151649_supabase_read_only_user_default_transaction_read_only.sql ALTER ROLE Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20251001204436_predefined_role_grants.sql GRANT ROLE DO Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20251105172723_grant_pg_reload_conf_to_postgres.sql GRANT Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20251121132723_correct_search_path_pgbouncer.sql CREATE FUNCTION REVOKE REVOKE GRANT Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20260211120934_supabase_privileged_role.sql DO Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20260413000000_fix-authenticator-session-preload-libraries.sql ALTER ROLE Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20260421000000_pg_graphql-off-by-default.sql DROP EXTENSION Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20260421000001_rescope_pg_graphql_access_trigger.sql CREATE FUNCTION DROP EVENT TRIGGER CREATE EVENT TRIGGER Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20260730000000_revoke_trigger_on_cron_tables_from_postgres.sql DO CREATE FUNCTION Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20260923021047_update_pgrst_watch_triggers.sql CREATE FUNCTION CREATE FUNCTION Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20261016000001_search_path_for_supa_functions.sql CREATE FUNCTION CREATE FUNCTION CREATE FUNCTION CREATE FUNCTION CREATE FUNCTION CREATE FUNCTION Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20261023000000_pgmq_drop_queue_search_path.sql DO 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: 1419) /nix/store/1ad4x24dc9mdrir21q5r7b1dkihs232k-postgresql-and-plugins-17.12/bin/postgres "-D" "/build/tmp.fQSZwFhIak" "--config-file=/build/tmp.fQSZwFhIak/postgresql.conf" "-p" "5541" "-k" "/build/tmp.fQSZwFhIak/tmp" $ pg_isready -h localhost -p 5541 -U supabase_admin -q 2026-11-13 15:07:57 [INFO] PostgreSQL is ready 2026-11-13 15:07:57 [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-13 15:07:57 [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-13 15:07:57 [INFO] CLI variant detected - running subset of pg_regress tests (47 tests) $ pg_regress --use-existing --dbname=postgres --inputdir=/nix/store/0ks4kdffckw2wy32jh6bhyl9zam1xhw6-tests --outputdir=/nix/store/f40mxnp7rhyx9y018dsljkjgnm7qhlqw-run-check-harness-psql-17-cli/regression_output --host=localhost --port=5541 --user=supabase_admin alter_column_type_rowtype_deps auth cast_function_execute_privilege 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 drop_owned_rls_policy enable_tracking event_trigger_search_path function_def_target_alias intarray_ltree_query jsonpath_gin_lookup ltree_label_overflow multirange_create_priv operator_breaking_change partition_prune_range 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 to_char_v_overflow upsert_rls_conflict_where upsert_view_visibility vault wal2json z_17_intarray_ltree_query z_17_wal_summarize (using postmaster on localhost, port 5541) ============== running regression test queries ============== test alter_column_type_rowtype_deps ... ok 13 ms test auth ... ok 12 ms test cast_function_execute_privilege ... FAILED 10 ms test create_statistics_priv ... ok 12 ms test dblink ... ok 30 ms test docs-array-test ... ok 9 ms test docs-cascades-deletes ... ok 52 ms test docs-connections ... ok 9 ms test docs-enums ... ok 23 ms test docs-full-text-search ... ok 23 ms test docs-functions ... ok 30 ms test docs-indexes ... ok 17 ms test docs-json ... ok 14 ms test docs-partitioning ... ok 25 ms test docs-tables-and-data ... ok 63 ms test docs-triggers ... ok 36 ms test docs-webhooks ... ok 33 ms test drop_owned_rls_policy ... ok 11 ms test enable_tracking ... ok 7 ms test event_trigger_search_path ... ok 8 ms test function_def_target_alias ... ok 8 ms test intarray_ltree_query ... ok 63 ms test jsonpath_gin_lookup ... ok 14 ms test ltree_label_overflow ... ok 49 ms test multirange_create_priv ... ok 11 ms test operator_breaking_change ... ok 28 ms test partition_prune_range ... ok 17 ms test pg-safeupdate ... ok 12 ms test pg_graphql ... ok 61 ms test pg_net ... ok 11 ms test pg_plan_filter ... ok 12 ms test pgaudit ... ok 12 ms test pgbouncer ... ok 19 ms test pgcrypto_cipher_matrix ... ok 21 ms test pgsodium ... ok 10 ms test realtime ... ok 9 ms test replica_identity_upsert ... ok 12 ms test storage ... ok 14 ms test supautils_reserved_memberships ... ok 8 ms test supautils_reserved_roles ... ok 9 ms test to_char_v_overflow ... ok 7 ms test upsert_rls_conflict_where ... FAILED 12 ms test upsert_view_visibility ... ok 11 ms test vault ... ok 26 ms test wal2json ... ok 13 ms test z_17_intarray_ltree_query ... ok 47 ms test z_17_wal_summarize ... ok 9 ms ======================= 2 of 47 tests failed. ======================= The differences that caused some tests to fail can be viewed in the file "/nix/store/f40mxnp7rhyx9y018dsljkjgnm7qhlqw-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/f40mxnp7rhyx9y018dsljkjgnm7qhlqw-run-check-harness-psql-17-cli/regression_output/regression.out". 2026-11-13 15:07:58 [ERROR] pg_regress tests failed 2026-11-13 15:07:58 [ERROR] An error occurred. Exit code: 1 2026-11-13 15:07:58 [ERROR] Debug logs: