run-check-harness-psql-17-cli
checks.aarch64-linux.psql_17_cli
· build #711
· raw
12026-11-13 15:01:41 [INFO] Starting HTTP mock server (will find free port)...22026-11-13 15:01:42 [INFO] HTTP mock server started on port 888032026-11-13 15:01:42 [INFO] Creating temporary PostgreSQL cluster at /build/tmp.hNMG3EquQG42026-11-13 15:01:43 [INFO] Generated preload libraries: pg_cron, pg_net, pgsodium, supabase_vault52026-11-13 15:01:43 [INFO] Checking shared_preload_libraries setting:62026-11-13 15:01:43 [INFO] 721:shared_preload_libraries = 'pg_cron, pg_net, pgsodium, supabase_vault' # (change requires restart)72026-11-13 15:01:43 [INFO] Configuring local auth82026-11-13 15:01:43 [INFO] Waiting for PostgreSQL to be ready...92026-11-13 15:01:43 [INFO] PostgreSQL is ready102026-11-13 15:01:43 [INFO] Creating test database112026-11-13 15:01:44 [INFO] CLI variant detected - loading CLI prime SQL file122026-11-13 15:01:45 [INFO] Creating test_config table132026-11-13 15:01:45 [INFO] Running pgtap test: alter_column_type_rowtype_deps.sql142026-11-13 15:01:45 [INFO] Running pgtap test: auth.sql152026-11-13 15:01:45 [INFO] Running pgtap test: cast_function_execute_privilege.sql162026-11-13 15:01:45 [INFO] Running pgtap test: create_statistics_priv.sql172026-11-13 15:01:45 [INFO] Running pgtap test: dblink.sql182026-11-13 15:01:45 [INFO] Running pgtap test: docs-array-test.sql192026-11-13 15:01:45 [INFO] Running pgtap test: docs-cascades-deletes.sql202026-11-13 15:01:45 [INFO] Running pgtap test: docs-connections.sql212026-11-13 15:01:45 [INFO] Running pgtap test: docs-enums.sql222026-11-13 15:01:46 [INFO] Running pgtap test: docs-full-text-search.sql232026-11-13 15:01:46 [INFO] Running pgtap test: docs-functions.sql242026-11-13 15:01:46 [INFO] Running pgtap test: docs-indexes.sql252026-11-13 15:01:46 [INFO] Running pgtap test: docs-json.sql262026-11-13 15:01:46 [INFO] Running pgtap test: docs-partitioning.sql272026-11-13 15:01:46 [INFO] Running pgtap test: docs-tables-and-data.sql282026-11-13 15:01:46 [INFO] Running pgtap test: docs-triggers.sql292026-11-13 15:01:47 [INFO] Running pgtap test: docs-webhooks.sql302026-11-13 15:01:47 [INFO] Running pgtap test: drop_owned_rls_policy.sql312026-11-13 15:01:47 [INFO] Running pgtap test: enable_tracking.sql322026-11-13 15:01:47 [INFO] Running pgtap test: event_trigger_search_path.sql332026-11-13 15:01:47 [INFO] Running pgtap test: function_def_target_alias.sql342026-11-13 15:01:47 [INFO] Running pgtap test: intarray_ltree_query.sql352026-11-13 15:01:47 [INFO] Running pgtap test: jsonpath_gin_lookup.sql362026-11-13 15:01:47 [INFO] Running pgtap test: ltree_label_overflow.sql372026-11-13 15:01:48 [INFO] Running pgtap test: multirange_create_priv.sql382026-11-13 15:01:48 [INFO] Running pgtap test: operator_breaking_change.sql392026-11-13 15:01:48 [INFO] Running pgtap test: partition_prune_range.sql402026-11-13 15:01:48 [INFO] Running pgtap test: pg-safeupdate.sql412026-11-13 15:01:48 [INFO] Running pgtap test: pg_graphql.sql422026-11-13 15:01:48 [INFO] Running pgtap test: pg_net.sql432026-11-13 15:01:48 [INFO] Running pgtap test: pg_plan_filter.sql442026-11-13 15:01:48 [INFO] Running pgtap test: pgaudit.sql452026-11-13 15:01:48 [INFO] Running pgtap test: pgbouncer.sql462026-11-13 15:01:48 [INFO] Running pgtap test: pgcrypto_cipher_matrix.sql472026-11-13 15:01:48 [INFO] Running pgtap test: pgsodium.sql482026-11-13 15:01:48 [INFO] Running pgtap test: realtime.sql492026-11-13 15:01:48 [INFO] Running pgtap test: replica_identity_upsert.sql502026-11-13 15:01:48 [INFO] Running pgtap test: storage.sql512026-11-13 15:01:49 [INFO] Running pgtap test: supautils_reserved_memberships.sql522026-11-13 15:01:49 [INFO] Running pgtap test: supautils_reserved_roles.sql532026-11-13 15:01:49 [INFO] Running pgtap test: to_char_v_overflow.sql542026-11-13 15:01:49 [INFO] Running pgtap test: upsert_rls_conflict_where.sql552026-11-13 15:01:49 [INFO] Running pgtap test: upsert_view_visibility.sql562026-11-13 15:01:49 [INFO] Running pgtap test: vault.sql572026-11-13 15:01:49 [INFO] Running pgtap test: wal2json.sql582026-11-13 15:01:49 [INFO] Running pgtap test: z_17_intarray_ltree_query.sql592026-11-13 15:01:49 [INFO] Running pgtap test: z_17_wal_summarize.sql602026-11-13 15:01:50 [INFO] Starting PostgreSQL server for pg_regress tests612026-11-13 15:01:55 [INFO] PostgreSQL is ready622026-11-13 15:01:55 [INFO] CLI variant detected - loading CLI prime SQL file632026-11-13 15:01:55 [INFO] Creating test_config table for pg_regress tests642026-11-13 15:01:55 [INFO] CLI variant detected - running subset of pg_regress tests (47 tests)652026-11-13 15:01:57 [ERROR] pg_regress tests failed66diff -U3 /nix/store/0ks4kdffckw2wy32jh6bhyl9zam1xhw6-tests/expected/cast_function_execute_privilege.out /nix/store/shkqd39h2wcy2rm3w8pc594c3g8sirzh-run-check-harness-psql-17-cli/regression_output/results/cast_function_execute_privilege.out67--- /nix/store/0ks4kdffckw2wy32jh6bhyl9zam1xhw6-tests/expected/cast_function_execute_privilege.out 1970-01-01 00:00:01.000000000 +000068+++ /nix/store/shkqd39h2wcy2rm3w8pc594c3g8sirzh-run-check-harness-psql-17-cli/regression_output/results/cast_function_execute_privilege.out 2026-11-13 15:01:55.571460213 +000069@@ -21,7 +21,11 @@70 -- Must be denied.71 SAVEPOINT s;72 SELECT to_json('a'::cast_priv_enum);73-ERROR: permission denied for function cast_priv_enum_to_json74+ to_json 75+---------76+ "a"77+(1 row)78+79 ROLLBACK TO SAVEPOINT s;80 RESET ROLE;81 ROLLBACK;82diff -U3 /nix/store/0ks4kdffckw2wy32jh6bhyl9zam1xhw6-tests/expected/upsert_rls_conflict_where.out /nix/store/shkqd39h2wcy2rm3w8pc594c3g8sirzh-run-check-harness-psql-17-cli/regression_output/results/upsert_rls_conflict_where.out83--- /nix/store/0ks4kdffckw2wy32jh6bhyl9zam1xhw6-tests/expected/upsert_rls_conflict_where.out 1970-01-01 00:00:01.000000000 +000084+++ /nix/store/shkqd39h2wcy2rm3w8pc594c3g8sirzh-run-check-harness-psql-17-cli/regression_output/results/upsert_rls_conflict_where.out 2026-11-13 15:01:57.532461091 +000085@@ -24,7 +24,7 @@86 INSERT INTO rls_upsert_doc VALUES (1, 'postgres', 'x')87 ON CONFLICT (id) DO UPDATE SET body = EXCLUDED.body88 WHERE rls_upsert_leak(rls_upsert_doc.body);89-ERROR: new row violates row-level security policy (USING expression) for table "rls_upsert_doc"90+NOTICE: leaked => secret91 ROLLBACK TO SAVEPOINT s;92 RESET ROLE;93 ROLLBACK;942026-11-13 15:01:57 [ERROR] An error occurred. Exit code: 1952026-11-13 15:01:57 [ERROR] Debug logs:962026-11-13 15:01:41 [INFO] Starting HTTP mock server (will find free port)...97$ /nix/store/a1mjjnpfivsx5gi4rxbcr54vl6gyjfzj-python3-3.13.11/bin/python3 /nix/store/sfl1mnhcw0ccky7m2crn0hda79clq4mk-http-mock-server.py982026-11-13 15:01:42 [INFO] HTTP mock server started on port 8880992026-11-13 15:01:42 [INFO] Creating temporary PostgreSQL cluster at /build/tmp.hNMG3EquQG100$ initdb --locale=C --username=supabase_admin -D /build/tmp.hNMG3EquQG101The files belonging to this database system will be owned by user "nixbld".102This user must also own the server process.103104The database cluster will be initialized with locale "C".105The default database encoding has accordingly been set to "SQL_ASCII".106The default text search configuration will be set to "english".107108Data page checksums are disabled.109110fixing permissions on existing directory /build/tmp.hNMG3EquQG ... ok111creating subdirectories ... ok112selecting dynamic shared memory implementation ... posix113selecting default "max_connections" ... 100114selecting default "shared_buffers" ... 128MB115selecting default time zone ... UTC116creating configuration files ... ok117running bootstrap script ... ok118performing post-bootstrap initialization ... ok119syncing data to disk ... ok120121initdb: warning: enabling "trust" authentication for local connections122initdb: 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.123124Success. You can now start the database server using:125126 pg_ctl -D /build/tmp.hNMG3EquQG -l logfile start1271282026-11-13 15:01:43 [INFO] Generated preload libraries: pg_cron, pg_net, pgsodium, supabase_vault1292026-11-13 15:01:43 [INFO] Checking shared_preload_libraries setting:1302026-11-13 15:01:43 [INFO] 721:shared_preload_libraries = 'pg_cron, pg_net, pgsodium, supabase_vault' # (change requires restart)1312026-11-13 15:01:43 [INFO] Configuring local auth132$ pg_ctl -D /build/tmp.hNMG3EquQG -l /build/tmp.hNMG3EquQG/postgresql.log -o -k /build/tmp.hNMG3EquQG/sockets -p 5541 -d 5 start133waiting for server to start.... done134server started1352026-11-13 15:01:43 [INFO] Waiting for PostgreSQL to be ready...136$ pg_isready -h localhost -p 5541 -U supabase_admin -q1372026-11-13 15:01:43 [INFO] PostgreSQL is ready1382026-11-13 15:01:43 [INFO] Creating test database139$ createdb -p 5541 -h localhost --username=supabase_admin testing1402026-11-13 15:01:44 [INFO] CLI variant detected - loading CLI prime SQL file141$ psql -p 5541 -h localhost --username=supabase_admin -d testing -v ON_ERROR_STOP=1 -Xf /nix/store/ib75j74vyc0w374jcz7mqcg6njf21yx3-prime-cli.sql142SET143CREATE EXTENSION144CREATE EXTENSION145CREATE EXTENSION146CREATE EXTENSION1472026-11-13 15:01:45 [INFO] Creating test_config table148$ psql -p 5541 -h localhost --username=supabase_admin -d testing -c 149 CREATE TABLE IF NOT EXISTS test_config (key TEXT PRIMARY KEY, value TEXT);150 INSERT INTO test_config (key, value) VALUES ('http_mock_port', '8880')151 ON CONFLICT (key) DO UPDATE SET value = EXCLUDED.value;152 INSERT INTO test_config (key, value) VALUES ('http_mock_host', 'localhost')153 ON CONFLICT (key) DO UPDATE SET value = EXCLUDED.value;154155CREATE TABLE156INSERT 0 1157INSERT 0 11582026-11-13 15:01:45 [INFO] Running pgtap test: alter_column_type_rowtype_deps.sql159$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/alter_column_type_rowtype_deps.sql160BEGIN161 has_guc 162---------163 1164(1 row)165166CREATE TABLE167CREATE FUNCTION168SAVEPOINT169psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/alter_column_type_rowtype_deps.sql:29: ERROR: cannot alter table "act_tbl" because function act_func() uses its row type170ROLLBACK171ROLLBACK1722026-11-13 15:01:45 [INFO] Running pgtap test: auth.sql173$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/auth.sql174 schema_name | owner 175-------------+-------176(0 rows)177178 schema_name | table_name | owner | rls_enabled | rls_policies 179-------------+------------+-------+-------------+--------------180(0 rows)181182 schema_name | table_name | role_name | privilege_type | is_grantable 183-------------+------------+-----------+----------------+--------------184(0 rows)185186 table_schema | table_name | index_name | index_owner 187--------------+------------+------------+-------------188(0 rows)189190 schema_name | function_name | owner 191-------------+---------------+-------192(0 rows)193194psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/auth.sql:97: ERROR: relation "auth.schema_migrations" does not exist195LINE 1: select * from auth.schema_migrations;196 ^1972026-11-13 15:01:45 [INFO] Running pgtap test: cast_function_execute_privilege.sql198$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/cast_function_execute_privilege.sql199BEGIN200CREATE TYPE201CREATE FUNCTION202CREATE CAST203REVOKE204psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/cast_function_execute_privilege.sql:23: ERROR: role "postgres" does not exist205psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/cast_function_execute_privilege.sql:26: ERROR: current transaction is aborted, commands ignored until end of transaction block206psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/cast_function_execute_privilege.sql:27: ERROR: current transaction is aborted, commands ignored until end of transaction block207psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/cast_function_execute_privilege.sql:28: ERROR: savepoint "s" does not exist208psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/cast_function_execute_privilege.sql:30: ERROR: current transaction is aborted, commands ignored until end of transaction block209ROLLBACK2102026-11-13 15:01:45 [INFO] Running pgtap test: create_statistics_priv.sql211$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/create_statistics_priv.sql212BEGIN213CREATE SCHEMA214CREATE SCHEMA215psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/create_statistics_priv.sql:15: ERROR: role "postgres" does not exist216psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/create_statistics_priv.sql:17: ERROR: current transaction is aborted, commands ignored until end of transaction block217psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/create_statistics_priv.sql:20: ERROR: current transaction is aborted, commands ignored until end of transaction block218psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/create_statistics_priv.sql:21: ERROR: current transaction is aborted, commands ignored until end of transaction block219psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/create_statistics_priv.sql:24: ERROR: current transaction is aborted, commands ignored until end of transaction block220psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/create_statistics_priv.sql:27: ERROR: current transaction is aborted, commands ignored until end of transaction block221psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/create_statistics_priv.sql:28: ERROR: current transaction is aborted, commands ignored until end of transaction block222psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/create_statistics_priv.sql:29: ERROR: savepoint "no_priv" does not exist223psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/create_statistics_priv.sql:31: ERROR: current transaction is aborted, commands ignored until end of transaction block224ROLLBACK2252026-11-13 15:01:45 [INFO] Running pgtap test: dblink.sql226$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/dblink.sql227SET228DROP EXTENSION229psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/dblink.sql:10: ERROR: role "postgres" does not exist230CREATE TABLE231CREATE EXTENSION232DROP TABLE233RESET234 function_name | grantee | privilege_type 235-----------------------------+----------------+----------------236 dblink_connect_u(text) | supabase_admin | EXECUTE237 dblink_connect_u(text,text) | supabase_admin | EXECUTE238(2 rows)239240psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/dblink.sql:28: ERROR: role "postgres" does not exist241 search_path 242-----------------243 "$user", public244(1 row)245246DROP EXTENSION247CREATE EXTENSION2482026-11-13 15:01:45 [INFO] Running pgtap test: docs-array-test.sql249$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-array-test.sql250CREATE TABLE251INSERT 0 1252 id | textarray 253----+-------------------254 1 | {Harry,Larry,Moe}255(1 row)256257 textarray | array_length 258-----------+--------------259 Harry | 3260(1 row)261262DROP TABLE2632026-11-13 15:01:45 [INFO] Running pgtap test: docs-cascades-deletes.sql264$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-cascades-deletes.sql265CREATE TABLE266CREATE TABLE267CREATE TABLE268INSERT 0 1269INSERT 0 1270INSERT 0 1271INSERT 0 1272 count 273-------274 1275(1 row)276277 count 278-------279 2280(1 row)281282 count 283-------284 1285(1 row)286287psql:/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"288DETAIL: Key (id)=(1) is still referenced from table "child".289 count 290-------291 1292(1 row)293294 count 295-------296 2297(1 row)298299 count 300-------301 1302(1 row)303304psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-cascades-deletes.sql:56: ERROR: duplicate key value violates unique constraint "grandparent_pkey"305DETAIL: Key (id)=(1) already exists.306psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-cascades-deletes.sql:61: ERROR: duplicate key value violates unique constraint "parent_pkey"307DETAIL: Key (id)=(1) already exists.308psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-cascades-deletes.sql:66: ERROR: duplicate key value violates unique constraint "parent_pkey"309DETAIL: Key (id)=(2) already exists.310psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-cascades-deletes.sql:71: ERROR: duplicate key value violates unique constraint "child_pkey"311DETAIL: Key (id)=(1) already exists.312ALTER TABLE313ALTER TABLE314psql:/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"315DETAIL: Key (id)=(1) is still referenced from table "child".316 count 317-------318 1319(1 row)320321 count 322-------323 2324(1 row)325326 count 327-------328 1329(1 row)330331psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-cascades-deletes.sql:89: ERROR: duplicate key value violates unique constraint "grandparent_pkey"332DETAIL: Key (id)=(1) already exists.333psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-cascades-deletes.sql:94: ERROR: duplicate key value violates unique constraint "parent_pkey"334DETAIL: Key (id)=(1) already exists.335psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-cascades-deletes.sql:99: ERROR: duplicate key value violates unique constraint "parent_pkey"336DETAIL: Key (id)=(2) already exists.337psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-cascades-deletes.sql:104: ERROR: duplicate key value violates unique constraint "child_pkey"338DETAIL: Key (id)=(1) already exists.339ALTER TABLE340ALTER TABLE341psql:/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"342DETAIL: Key (id)=(1) is still referenced from table "child".343 count 344-------345 1346(1 row)347348 count 349-------350 2351(1 row)352353 count 354-------355 1356(1 row)357358psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-cascades-deletes.sql:122: ERROR: duplicate key value violates unique constraint "grandparent_pkey"359DETAIL: Key (id)=(1) already exists.360psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-cascades-deletes.sql:127: ERROR: duplicate key value violates unique constraint "parent_pkey"361DETAIL: Key (id)=(1) already exists.362psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-cascades-deletes.sql:132: ERROR: duplicate key value violates unique constraint "parent_pkey"363DETAIL: Key (id)=(2) already exists.364psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-cascades-deletes.sql:137: ERROR: duplicate key value violates unique constraint "child_pkey"365DETAIL: Key (id)=(1) already exists.366ALTER TABLE367UPDATE 1368DELETE 1369 count 370-------371 0372(1 row)373374 count 375-------376 0377(1 row)378379 count 380-------381 0382(1 row)383384CREATE TABLE385CREATE TABLE386INSERT 0 1387INSERT 0 1388DELETE 1389 count 390-------391 0392(1 row)393394 count 395-------396 0397(1 row)398399CREATE TABLE400CREATE TABLE401INSERT 0 1402INSERT 0 1403psql:/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"404DETAIL: Key (id)=(1) is still referenced from table "test_restrict_child".405 count 406-------407 1408(1 row)409410 count 411-------412 1413(1 row)414415CREATE TABLE416CREATE TABLE417INSERT 0 1418INSERT 0 1419DELETE 1420 count 421-------422 0423(1 row)424425 count 426-------427 1428(1 row)429430 parent_id 431-----------432 433(1 row)434435CREATE TABLE436CREATE TABLE437INSERT 0 1438INSERT 0 1439psql:/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"440DETAIL: Key (parent_id)=(999) is not present in table "test_set_default".441 count 442-------443 1444(1 row)445446 count 447-------448 1449(1 row)450451 parent_id 452-----------453 1454(1 row)455456CREATE TABLE457CREATE TABLE458INSERT 0 1459INSERT 0 1460psql:/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"461DETAIL: Key (id)=(1) is still referenced from table "test_no_action_child".462 count 463-------464 1465(1 row)466467 count 468-------469 1470(1 row)471472DROP TABLE473DROP TABLE474DROP TABLE475DROP TABLE476DROP TABLE477DROP TABLE478DROP TABLE479DROP TABLE480DROP TABLE481DROP TABLE482DROP TABLE483DROP TABLE484DROP TABLE4852026-11-13 15:01:45 [INFO] Running pgtap test: docs-connections.sql486$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-connections.sql487 ssl | database | connected_role | application_name | query | state 488-----+----------+----------------+------------------+--------------------------------------------+--------489 f | testing | supabase_admin | psql | select +| active490 | | | | ssl, +| 491 | | | | datname as database, +| 492 | | | | usename as connected_role, +| 493 | | | | application_name, +| 494 | | | | query, +| 495 | | | | state +| 496 | | | | from pg_stat_ssl +| 497 | | | | join pg_stat_activity +| 498 | | | | on pg_stat_ssl.pid = pg_stat_activity.pid; | 499(1 row)5005012026-11-13 15:01:45 [INFO] Running pgtap test: docs-enums.sql502$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-enums.sql503CREATE TYPE504CREATE TABLE505INSERT 0 1506INSERT 0 1507INSERT 0 1508 id | name | current_mood 509----+------+--------------510 2 | Bob | sad511(1 row)512513 id | name | current_mood 514----+-------+--------------515 1 | Alice | happy516(1 row)517518UPDATE 1519 id | name | current_mood 520----+-------+--------------521 1 | Alice | excited522(1 row)523524ALTER TYPE525INSERT 0 1526 enum_range 527----------------------------------528 {happy,sad,excited,calm,content}529(1 row)530531 id | name | current_mood 532----+-------+--------------533 4 | David | content534(1 row)535536CREATE TYPE537CREATE TABLE538INSERT 0 3539 id | order_number | status 540----+--------------+--------541 1 | ORD-001 | active542(1 row)543544UPDATE 1545 id | order_number | status 546----+--------------+----------547 2 | ORD-002 | inactive548(1 row)549550ALTER TYPE551INSERT 0 1552 enum_range 553-------------------------------------554 {active,inactive,pending,cancelled}555(1 row)556557 id | order_number | status 558----+--------------+-----------559 4 | ORD-004 | cancelled560(1 row)561562CREATE TYPE563CREATE TABLE564INSERT 0 3565 id | title | priority 566----+----------------+----------567 3 | Security audit | critical568(1 row)569570UPDATE 1571 id | title | priority 572----+-------------+----------573 2 | Update docs | medium574(1 row)575576ALTER TYPE577INSERT 0 1578 enum_range 579-----------------------------------580 {low,medium,high,critical,urgent}581(1 row)582583 id | title | priority 584----+--------------------+----------585 4 | Server maintenance | urgent586(1 row)587588DROP TABLE589DROP TABLE590DROP TABLE591DROP TYPE592DROP TYPE593DROP TYPE5942026-11-13 15:01:46 [INFO] Running pgtap test: docs-full-text-search.sql595$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-full-text-search.sql596CREATE TABLE597INSERT 0 5598 to_tsvector 599---------------------------600 'egg':2 'green':1 'ham':4601(1 row)602603 to_tsvector 604---------------------------605 'egg':2 'green':1 'ham':4606(1 row)607608 id | title | author | description 609----+-------+--------+-------------610(0 rows)611612 id | title | author | description 613----+-------------------------------------+--------------+-------------------------------------------------614 5 | Harry Potter and the Goblet of Fire | J.K. Rowling | Fourth year of school starts, big drama ensues.615(1 row)616617 id | title | author | description 618----+-------------------------------------+-------------------+-------------------------------------------------619 3 | Tootle | Gertrude Crampton | Little toy train has big dreams.620 5 | Harry Potter and the Goblet of Fire | J.K. Rowling | Fourth year of school starts, big drama ensues.621(2 rows)622623 id | title | author | description 624----+-----------------------+------------------------+---------------------------------------------625 1 | The Poky Little Puppy | Janette Sebring Lowrey | Puppy is slower than other, bigger animals.626 3 | Tootle | Gertrude Crampton | Little toy train has big dreams.627(2 rows)628629CREATE FUNCTION630 id | title | author | description 631----+-----------------------+------------------------+---------------------------------------------632 1 | The Poky Little Puppy | Janette Sebring Lowrey | Puppy is slower than other, bigger animals.633 3 | Tootle | Gertrude Crampton | Little toy train has big dreams.634(2 rows)635636 id | title | author | description 637----+--------+-------------------+----------------------------------638 3 | Tootle | Gertrude Crampton | Little toy train has big dreams.639(1 row)640641 id | title | author | description 642----+-------------------------------------+-------------------+-------------------------------------------------643 3 | Tootle | Gertrude Crampton | Little toy train has big dreams.644 5 | Harry Potter and the Goblet of Fire | J.K. Rowling | Fourth year of school starts, big drama ensues.645(2 rows)646647 title 648-----------------------649 The Poky Little Puppy650(1 row)651652CREATE FUNCTION653 id | title | author | description 654----+-----------------------+------------------------+---------------------------------------------655 1 | The Poky Little Puppy | Janette Sebring Lowrey | Puppy is slower than other, bigger animals.656(1 row)657658 id | title | author | description 659----+-----------------------+------------------------+---------------------------------------------660 1 | The Poky Little Puppy | Janette Sebring Lowrey | Puppy is slower than other, bigger animals.661(1 row)662663ALTER TABLE664CREATE INDEX665 id | fts 666----+-----------------------------------------------------------------------------------------------------------------667 1 | 'anim':7 'bigger':6 'littl':10 'poki':9 'puppi':1,11 'slower':3668 2 | 'eat':2 'peter':8 'rabbit':1,9 'tale':6 'veget':4669 3 | 'big':5 'dream':6 'littl':1 'tootl':7 'toy':2 'train':3670 4 | 'chang':3 'color':9 'eat':7 'egg':12 'food':4,10 'green':11 'ham':14 'prefer':5 'sam':1 'unusu':8671 5 | 'big':6 'drama':7 'ensu':8 'fire':15 'fourth':1 'goblet':13 'harri':9 'potter':10 'school':4 'start':5 'year':2672(5 rows)673674 id | title | author | description | fts 675----+--------+-------------------+----------------------------------+---------------------------------------------------------676 3 | Tootle | Gertrude Crampton | Little toy train has big dreams. | 'big':5 'dream':6 'littl':1 'tootl':7 'toy':2 'train':3677(1 row)678679 id | title | author | description | fts 680----+--------+-------------------+----------------------------------+---------------------------------------------------------681 3 | Tootle | Gertrude Crampton | Little toy train has big dreams. | 'big':5 'dream':6 'littl':1 'tootl':7 'toy':2 'train':3682(1 row)683684 id | title | author | description | fts 685----+-------------------------------------+--------------+-------------------------------------------------+-----------------------------------------------------------------------------------------------------------------686 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':2687(1 row)688689 id | title | author | description | fts 690----+-------------------------------------+--------------+-------------------------------------------------+-----------------------------------------------------------------------------------------------------------------691 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':2692(1 row)693694 id | title | author | description | fts 695----+-------------------------------------+--------------+-------------------------------------------------+-----------------------------------------------------------------------------------------------------------------696 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':2697(1 row)698699 id | title | author | description | fts 700----+--------------------+-----------+--------------------------------------------------------------------+---------------------------------------------------------------------------------------------------701 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':8702(1 row)703704 id | title | author | description | fts 705----+--------+-------------------+----------------------------------+---------------------------------------------------------706 3 | Tootle | Gertrude Crampton | Little toy train has big dreams. | 'big':5 'dream':6 'littl':1 'tootl':7 'toy':2 'train':3707(1 row)708709 id | title | author | description | fts 710----+-------+--------+-------------+-----711(0 rows)712713 id | title | author | description | fts 714----+--------------------------+----------------+------------------------------+---------------------------------------------------715 2 | The Tale of Peter Rabbit | Beatrix Potter | Rabbit eats some vegetables. | 'eat':2 'peter':8 'rabbit':1,9 'tale':6 'veget':4716(1 row)717718 id | title | author | description | fts 719----+-------------------------------------+--------------+-------------------------------------------------+-----------------------------------------------------------------------------------------------------------------720 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':2721(1 row)722723 id | title | author | description | fts 724----+-------+--------+-------------+-----725(0 rows)726727 id | title | author | description | fts 728----+--------+-------------------+----------------------------------+---------------------------------------------------------729 3 | Tootle | Gertrude Crampton | Little toy train has big dreams. | 'big':5 'dream':6 'littl':1 'tootl':7 'toy':2 'train':3730(1 row)731732DROP FUNCTION733DROP FUNCTION734DROP TABLE7352026-11-13 15:01:46 [INFO] Running pgtap test: docs-functions.sql736$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-functions.sql737CREATE FUNCTION738 hello_world 739-------------740 hello world741(1 row)742743CREATE TABLE744INSERT 0 3745CREATE TABLE746INSERT 0 4747CREATE FUNCTION748 id | name 749----+----------750 1 | Tattoine751(1 row)752753CREATE FUNCTION754psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-functions.sql:64: ERROR: duplicate key value violates unique constraint "planets_pkey"755DETAIL: Key (id)=(1) already exists.756CONTEXT: SQL statement "insert into planets(name)757 values (add_planet.name)758 returning id"759PL/pgSQL function add_planet(text) line 5 at SQL statement760CREATE FUNCTION761 hello_world_definer 762---------------------763 hello world764(1 row)765766REVOKE767psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-functions.sql:79: ERROR: role "anon" does not exist768psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-functions.sql:81: ERROR: role "authenticated" does not exist769REVOKE770psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-functions.sql:84: ERROR: role "anon" does not exist771ALTER DEFAULT PRIVILEGES772psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-functions.sql:87: ERROR: role "anon" does not exist773psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-functions.sql:89: ERROR: role "authenticated" does not exist774CREATE FUNCTION775psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-functions.sql:106: WARNING: logging warning: WARNING MESSAGE776psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-functions.sql:106: ERROR: logging error: ERROR MESSAGE777CONTEXT: PL/pgSQL function logging_example(text,text,text) line 5 at RAISE778CREATE FUNCTION779 error_if_null 780---------------781 not null782(1 row)783784CREATE TABLE785INSERT 0 1786CREATE FUNCTION787 assert_example 788--------------------------------------789 123e4567-e89b-12d3-a456-426614174000790(1 row)791792CREATE FUNCTION793psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-functions.sql:162: ERROR: An error occurred in function <function name>: relation "table_that_does_not_exist" does not exist794CONTEXT: PL/pgSQL function error_example() line 7 at RAISE795CREATE TABLE796INSERT 0 1797CREATE FUNCTION798 advanced_example 799------------------800 42,new val801(1 row)802803DROP FUNCTION804DROP FUNCTION805DROP FUNCTION806DROP FUNCTION807DROP FUNCTION808DROP FUNCTION809DROP FUNCTION810DROP FUNCTION811DROP FUNCTION812DROP TABLE813DROP TABLE814DROP TABLE815DROP TABLE816GRANT817psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-functions.sql:221: ERROR: role "anon" does not exist818ALTER DEFAULT PRIVILEGES819psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-functions.sql:224: ERROR: role "anon" does not exist8202026-11-13 15:01:46 [INFO] Running pgtap test: docs-indexes.sql821$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-indexes.sql822CREATE TABLE823INSERT 0 1824 name 825----------826 John Doe827(1 row)828829CREATE INDEX830CREATE INDEX831CREATE INDEX832REINDEX833REINDEX834DROP TABLE8352026-11-13 15:01:46 [INFO] Running pgtap test: docs-json.sql836$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-json.sql837CREATE TABLE838INSERT 0 5839 title | description | price | low_age | high_age 840-------------------------------------+--------------------------------------------------------------------+-------+---------+----------841 The Poky Little Puppy | Puppy is slower than other, bigger animals. | 5.95 | 3 | 6842 The Tale of Peter Rabbit | Rabbit eats some vegetables. | 4.49 | 2 | 5843 Tootle | Little toy train has big dreams. | 3.99 | 2 | 5844 Green Eggs and Ham | Sam has changing food preferences and eats unusually colored food. | 7.49 | 4 | 8845 Harry Potter and the Goblet of Fire | Fourth year of school starts, big drama ensues. | 24.95 | 10 | 99846(5 rows)847848DROP TABLE8492026-11-13 15:01:46 [INFO] Running pgtap test: docs-partitioning.sql850$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-partitioning.sql851CREATE TABLE852CREATE TABLE853CREATE TABLE854INSERT 0 4855 id | order_date | customer_id | amount 856----+------------+-------------+--------857 1 | 2000-01-15 | 1 | 100858 2 | 2000-01-20 | 2 | 200859 3 | 2000-02-10 | 3 | 150860 4 | 2000-02-25 | 4 | 300861(4 rows)862863 id | order_date | customer_id | amount 864----+------------+-------------+--------865 3 | 2000-02-10 | 3 | 150866 4 | 2000-02-25 | 4 | 300867(2 rows)868869DROP TABLE870CREATE TABLE871CREATE TABLE872CREATE TABLE873INSERT 0 5874 id | name | country 875----+------------+---------876 1 | John Doe | US877 2 | Jane Smith | CANADA878(2 rows)879880 id | name | country 881----+-------------+---------882 3 | Li Wei | CHINA883 4 | Priya Patel | INDIA884 5 | Yuki Tanaka | JAPAN885(3 rows)886887DROP TABLE888CREATE TABLE889CREATE TABLE890CREATE TABLE891INSERT 0 4892 id | name | category | price 893----+--------+-------------+-------894 1 | Laptop | Electronics | 999895 2 | Phone | Electronics | 599896(2 rows)897898 count 899-------900 2901(1 row)902903 count 904-------905 2906(1 row)907908DROP TABLE9092026-11-13 15:01:46 [INFO] Running pgtap test: docs-tables-and-data.sql910$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-tables-and-data.sql911CREATE TABLE912 table_name | column_name | data_type | is_nullable | column_default 913------------+-------------+-----------+-------------+----------------914 movies | id | bigint | NO | 915 movies | name | text | YES | 916 movies | description | text | YES | 917(3 rows)918919DROP TABLE920CREATE TABLE921 column_name | data_type | is_nullable | column_default | is_identity | identity_generation 922-------------+-----------+-------------+----------------+-------------+---------------------923 id | bigint | NO | | YES | ALWAYS924(1 row)925926DROP TABLE927CREATE TABLE928 column_name | data_type | is_nullable | column_default | is_identity | identity_generation 929-------------+-----------+-------------+----------------+-------------+---------------------930 id | bigint | NO | | YES | BY DEFAULT931(1 row)932933DROP TABLE934CREATE TABLE935INSERT 0 2936 id | name | description 937----+-------------------------+--------------------------------------------------------------------------------------------------------------------------------938 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.939 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.940(2 rows)941942DROP TABLE943psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-tables-and-data.sql:57: NOTICE: table "categories" does not exist, skipping944DROP TABLE945CREATE TABLE946CREATE TABLE947ALTER TABLE948 table_name | column_name | foreign_table_name | foreign_column_name 949------------+-------------+--------------------+---------------------950 movies | category_id | categories | id951(1 row)952953psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-tables-and-data.sql:89: NOTICE: table "performances" does not exist, skipping954DROP TABLE955psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-tables-and-data.sql:90: NOTICE: table "actors" does not exist, skipping956DROP TABLE957DROP TABLE958CREATE TABLE959CREATE TABLE960CREATE TABLE961 table_name 962--------------963 actors964 movies965 performances966(3 rows)967968CREATE SCHEMA969 schema_name 970-------------971 private972(1 row)973974psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-tables-and-data.sql:120: NOTICE: table "salaries" does not exist, skipping975DROP TABLE976psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-tables-and-data.sql:121: NOTICE: drop cascades to constraint performances_actor_id_fkey on table performances977DROP TABLE978CREATE TABLE979CREATE TABLE980 table_schema | table_name 981--------------+------------982 private | salaries983(1 row)984985psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-tables-and-data.sql:137: NOTICE: table "grades" does not exist, skipping986DROP TABLE987psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-tables-and-data.sql:138: NOTICE: table "courses" does not exist, skipping988DROP TABLE989psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-tables-and-data.sql:139: NOTICE: table "students" does not exist, skipping990DROP TABLE991psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-tables-and-data.sql:140: NOTICE: view "transcripts" does not exist, skipping992DROP VIEW993CREATE TABLE994CREATE TABLE995CREATE TABLE996INSERT 0 3997INSERT 0 3998INSERT 0 6999CREATE VIEW1000psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-tables-and-data.sql:192: ERROR: role "authenticated" does not exist1001 name | type | title | code | result 1002------------------+---------------+--------------------------+---------+--------1003 Anakin Skywalker | graduate | Authentication Theories | AUTH205 | A1004 Anakin Skywalker | graduate | Introduction to Postgres | PG101 | A-1005 Anakin Skywalker | graduate | Fundamentals of Supabase | SUP412 | B-1006 Princess Leia | undergraduate | Introduction to Postgres | PG101 | B+1007 Princess Leia | undergraduate | Fundamentals of Supabase | SUP412 | A+1008 Yoda | graduate | Authentication Theories | AUTH205 | A1009(6 rows)10101011psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-tables-and-data.sql:196: NOTICE: materialized view "transcripts_materialized" does not exist, skipping1012DROP MATERIALIZED VIEW1013SELECT 61014 name | type | title | code | result 1015------------------+---------------+--------------------------+---------+--------1016 Anakin Skywalker | graduate | Authentication Theories | AUTH205 | A1017 Anakin Skywalker | graduate | Introduction to Postgres | PG101 | A-1018 Anakin Skywalker | graduate | Fundamentals of Supabase | SUP412 | B-1019 Princess Leia | undergraduate | Introduction to Postgres | PG101 | B+1020 Princess Leia | undergraduate | Fundamentals of Supabase | SUP412 | A+1021 Yoda | graduate | Authentication Theories | AUTH205 | A1022(6 rows)10231024REFRESH MATERIALIZED VIEW1025 count 1026-------1027 61028(1 row)10291030psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-tables-and-data.sql:217: NOTICE: view "secure_transcripts" does not exist, skipping1031DROP VIEW1032CREATE VIEW1033 schemaname | viewname 1034------------+--------------------1035 public | secure_transcripts1036(1 row)10371038psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-tables-and-data.sql:228: NOTICE: view "test_view" does not exist, skipping1039DROP VIEW1040CREATE VIEW1041ALTER VIEW1042 schemaname | viewname 1043------------+-----------1044 public | test_view1045(1 row)10461047DROP MATERIALIZED VIEW1048DROP VIEW1049DROP VIEW1050DROP VIEW1051DROP TABLE1052DROP TABLE1053DROP TABLE1054DROP TABLE1055DROP TABLE1056DROP TABLE1057DROP TABLE1058DROP TABLE1059DROP SCHEMA10602026-11-13 15:01:46 [INFO] Running pgtap test: docs-triggers.sql1061$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-triggers.sql1062CREATE TABLE1063CREATE TABLE1064CREATE FUNCTION1065CREATE TRIGGER1066INSERT 0 11067INSERT 0 11068UPDATE 11069 id | employee_id | old_salary | new_salary 1070----+-------------+------------+------------1071 1 | 1 | 50000 | 550001072(1 row)10731074CREATE TABLE1075CREATE TABLE1076CREATE FUNCTION1077CREATE TRIGGER1078CREATE TABLE1079CREATE FUNCTION1080CREATE TRIGGER1081INSERT 0 11082INSERT 0 11083INSERT 0 11084INSERT 0 11085DELETE 11086 id | customer_id | action | customer_name 1087----+-------------+--------+---------------1088 1 | 1 | DELETE | Alice Johnson1089(1 row)10901091CREATE TABLE1092CREATE FUNCTION1093CREATE TRIGGER1094INSERT 0 11095 id | trigger_name | operation | table_name 1096----+-------------------------+-----------+------------1097 1 | statement_level_trigger | INSERT | orders1098(1 row)10991100CREATE TABLE1101CREATE FUNCTION1102CREATE TRIGGER1103INSERT 0 11104UPDATE 11105DELETE 11106 id | trigger_name | trigger_when | operation | table_name | table_schema | row_id 1107----+-------------------+--------------+-----------+------------+--------------+--------1108 1 | variables_trigger | AFTER | INSERT | employees | public | 31109 2 | variables_trigger | AFTER | UPDATE | employees | public | 31110 3 | variables_trigger | AFTER | DELETE | employees | public | 31111(3 rows)11121113CREATE TABLE1114CREATE FUNCTION1115CREATE TRIGGER1116INSERT 0 11117INSERT 0 11118 id | employee_name | salary 1119----+---------------+--------1120 1 | Executive | 1500001121(1 row)11221123DROP TRIGGER1124DROP TRIGGER1125DROP TRIGGER1126DROP TRIGGER1127DROP TRIGGER1128DROP TRIGGER1129DROP FUNCTION1130DROP FUNCTION1131DROP FUNCTION1132DROP FUNCTION1133DROP FUNCTION1134DROP FUNCTION1135DROP TABLE1136DROP TABLE1137DROP TABLE1138DROP TABLE1139DROP TABLE1140DROP TABLE1141DROP TABLE1142DROP TABLE11432026-11-13 15:01:47 [INFO] Running pgtap test: docs-webhooks.sql1144$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/docs-webhooks.sql1145CREATE TABLE1146CREATE TABLE1147CREATE FUNCTION1148CREATE TRIGGER1149CREATE TRIGGER1150CREATE TRIGGER1151INSERT 0 11152INSERT 0 11153 id | webhook_name | event_type | table_name | schema_name | ?column? 1154----+----------------+------------+------------+-------------+--------------------------------------------------------------1155 1 | insert_webhook | INSERT | profiles | public | {"id": 1, "name": "John Doe", "email": "john@example.com"}1156 2 | insert_webhook | INSERT | profiles | public | {"id": 2, "name": "Jane Smith", "email": "jane@example.com"}1157(2 rows)11581159UPDATE 11160 id | webhook_name | event_type | table_name | schema_name | ?column? | ?column? 1161----+----------------+------------+------------+-------------+----------------------------------------------------------------+------------------------------------------------------------1162 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"}1163(1 row)11641165DELETE 11166 id | webhook_name | event_type | table_name | schema_name | ?column? 1167----+----------------+------------+------------+-------------+--------------------------------------------------------------1168 4 | delete_webhook | DELETE | profiles | public | {"id": 2, "name": "Jane Smith", "email": "jane@example.com"}1169(1 row)11701171CREATE TABLE1172CREATE TABLE1173CREATE FUNCTION1174CREATE FUNCTION1175CREATE TRIGGER1176INSERT 0 11177INSERT 0 11178 id | webhook_name | url | method | response_status | response_data 1179----+----------------+----------------------------------+--------+-----------------+------------------------------------------------------------------------------------------1180 1 | orders_webhook | https://dummyjson.com/products/1 | GET | 200 | {"id": 1, "price": 9.99, "title": "Essence Mascara Lash Princess", "category": "beauty"}1181 2 | orders_webhook | https://dummyjson.com/products/1 | GET | 200 | {"id": 1, "price": 9.99, "title": "Essence Mascara Lash Princess", "category": "beauty"}1182(2 rows)11831184CREATE TABLE1185INSERT 0 11186CREATE FUNCTION1187CREATE TRIGGER1188INSERT 0 11189 id | webhook_name | url | method | response_status | response_data 1190----+-----------------+----------------------------------+--------+-----------------+-------------------------------------------------------------------------------------------1191 3 | product_webhook | https://dummyjson.com/products/2 | GET | 200 | {"id": 2, "price": 19.99, "title": "Eyeshadow Palette with Mirror", "category": "beauty"}1192(1 row)11931194CREATE FUNCTION1195 webhook_name | event_type | table_name | record_count 1196----------------+------------+------------+--------------1197 delete_webhook | DELETE | profiles | 11198 insert_webhook | INSERT | profiles | 31199 update_webhook | UPDATE | profiles | 11200(3 rows)12011202DROP TRIGGER1203DROP TRIGGER1204DROP TRIGGER1205DROP TRIGGER1206DROP TRIGGER1207DROP FUNCTION1208DROP FUNCTION1209DROP FUNCTION1210DROP FUNCTION1211DROP FUNCTION1212DROP TABLE1213DROP TABLE1214DROP TABLE1215DROP TABLE1216DROP TABLE12172026-11-13 15:01:47 [INFO] Running pgtap test: drop_owned_rls_policy.sql1218$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/drop_owned_rls_policy.sql1219BEGIN1220CREATE ROLE1221CREATE TABLE1222ALTER TABLE1223CREATE POLICY1224SET1225psql:/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"1226DROP OWNED1227RESET1228 polname | polroles 1229--------------+--------------------1230 dob_restrict | {regress_dob_role}1231(1 row)12321233ROLLBACK12342026-11-13 15:01:47 [INFO] Running pgtap test: enable_tracking.sql1235$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/enable_tracking.sql1236psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/enable_tracking.sql:1: ERROR: role "postgres" does not exist1237psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/enable_tracking.sql:2: ERROR: role "postgres" does not exist1238psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/enable_tracking.sql:4: ERROR: role "postgres" does not exist1239psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/enable_tracking.sql:5: ERROR: role "postgres" does not exist12402026-11-13 15:01:47 [INFO] Running pgtap test: event_trigger_search_path.sql1241$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/event_trigger_search_path.sql1242DO12432026-11-13 15:01:47 [INFO] Running pgtap test: function_def_target_alias.sql1244$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/function_def_target_alias.sql1245BEGIN1246CREATE TABLE1247CREATE FUNCTION1248 pg_get_functiondef 1249-----------------------------------------------1250 CREATE OR REPLACE FUNCTION public.fdta_func()+1251 RETURNS void +1252 LANGUAGE sql +1253 BEGIN ATOMIC +1254 UPDATE fdta_tbl AS t SET val = (t.val + 1) +1255 WHERE (t.id = 1); +1256 DELETE FROM fdta_tbl AS d +1257 WHERE (d.id = 2); +1258 END +1259 1260(1 row)12611262ROLLBACK12632026-11-13 15:01:47 [INFO] Running pgtap test: intarray_ltree_query.sql1264$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/intarray_ltree_query.sql1265BEGIN1266SET1267CREATE EXTENSION1268CREATE EXTENSION1269 q_and 1270-------1271 f1272(1 row)12731274 q_or 1275------1276 t1277(1 row)12781279 lquery_match 1280--------------1281 t1282(1 row)12831284 ltxtquery_match 1285-----------------1286 t1287(1 row)12881289psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/intarray_ltree_query.sql:38: ERROR: query_int expression is too complex1290psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/intarray_ltree_query.sql:42: ERROR: current transaction is aborted, commands ignored until end of transaction block1291psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/intarray_ltree_query.sql:45: ERROR: current transaction is aborted, commands ignored until end of transaction block1292psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/intarray_ltree_query.sql:47: ERROR: current transaction is aborted, commands ignored until end of transaction block1293ROLLBACK12942026-11-13 15:01:47 [INFO] Running pgtap test: jsonpath_gin_lookup.sql1295$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/jsonpath_gin_lookup.sql1296BEGIN1297CREATE TABLE1298INSERT 0 71299CREATE INDEX1300SET1301 count 1302-------1303 11304(1 row)13051306 count 1307-------1308 21309(1 row)13101311 count 1312-------1313 61314(1 row)13151316SET1317SET1318 count 1319-------1320 11321(1 row)13221323 count 1324-------1325 21326(1 row)13271328 count 1329-------1330 61331(1 row)13321333ROLLBACK13342026-11-13 15:01:47 [INFO] Running pgtap test: ltree_label_overflow.sql1335$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/ltree_label_overflow.sql1336BEGIN1337SET1338CREATE EXTENSION1339 na | nb | a_gt_b | a_lt_b | b_lt_a | a_eq_a 1340-------+----+--------+--------+--------+--------1341 20001 | 1 | t | f | t | t1342(1 row)13431344ROLLBACK13452026-11-13 15:01:48 [INFO] Running pgtap test: multirange_create_priv.sql1346$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/multirange_create_priv.sql1347BEGIN1348CREATE SCHEMA1349CREATE SCHEMA1350psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/multirange_create_priv.sql:16: ERROR: role "postgres" does not exist1351psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/multirange_create_priv.sql:18: ERROR: current transaction is aborted, commands ignored until end of transaction block1352psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/multirange_create_priv.sql:24: ERROR: current transaction is aborted, commands ignored until end of transaction block1353psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/multirange_create_priv.sql:28: ERROR: current transaction is aborted, commands ignored until end of transaction block1354psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/multirange_create_priv.sql:32: ERROR: current transaction is aborted, commands ignored until end of transaction block1355psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/multirange_create_priv.sql:33: ERROR: savepoint "no_priv" does not exist1356psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/multirange_create_priv.sql:35: ERROR: current transaction is aborted, commands ignored until end of transaction block1357ROLLBACK13582026-11-13 15:01:48 [INFO] Running pgtap test: operator_breaking_change.sql1359$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/operator_breaking_change.sql1360BEGIN1361SET1362CREATE EXTENSION1363CREATE SCHEMA1364psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/operator_breaking_change.sql:22: ERROR: role "postgres" does not exist1365psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/operator_breaking_change.sql:26: ERROR: current transaction is aborted, commands ignored until end of transaction block1366psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/operator_breaking_change.sql:29: ERROR: current transaction is aborted, commands ignored until end of transaction block1367psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/operator_breaking_change.sql:32: ERROR: current transaction is aborted, commands ignored until end of transaction block1368psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/operator_breaking_change.sql:37: ERROR: current transaction is aborted, commands ignored until end of transaction block1369psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/operator_breaking_change.sql:38: ERROR: savepoint "before_restrict" does not exist1370psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/operator_breaking_change.sql:41: ERROR: current transaction is aborted, commands ignored until end of transaction block1371psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/operator_breaking_change.sql:46: ERROR: current transaction is aborted, commands ignored until end of transaction block1372psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/operator_breaking_change.sql:47: ERROR: savepoint "before_join" does not exist1373psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/operator_breaking_change.sql:55: ERROR: current transaction is aborted, commands ignored until end of transaction block1374psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/operator_breaking_change.sql:56: ERROR: current transaction is aborted, commands ignored until end of transaction block1375psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/operator_breaking_change.sql:58: ERROR: current transaction is aborted, commands ignored until end of transaction block1376psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/operator_breaking_change.sql:60: ERROR: current transaction is aborted, commands ignored until end of transaction block1377ROLLBACK13782026-11-13 15:01:48 [INFO] Running pgtap test: partition_prune_range.sql1379$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/partition_prune_range.sql1380BEGIN1381CREATE TABLE1382CREATE TABLE1383CREATE TABLE1384CREATE TABLE1385CREATE TABLE1386INSERT 0 51387CREATE TABLE1388CREATE TABLE1389CREATE TABLE1390INSERT 0 31391CREATE TABLE1392CREATE TABLE1393CREATE TABLE1394INSERT 0 31395 count 1396-------1397 31398(1 row)13991400 count 1401-------1402 11403(1 row)14041405 count 1406-------1407 21408(1 row)14091410 count 1411-------1412 11413(1 row)14141415SET1416 count 1417-------1418 31419(1 row)14201421 count 1422-------1423 11424(1 row)14251426 count 1427-------1428 21429(1 row)14301431 count 1432-------1433 11434(1 row)14351436ROLLBACK14372026-11-13 15:01:48 [INFO] Running pgtap test: pg-safeupdate.sql1438$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pg-safeupdate.sql1439LOAD1440SET1441CREATE SCHEMA1442CREATE TABLE1443psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pg-safeupdate.sql:13: ERROR: UPDATE requires a WHERE clause1444psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pg-safeupdate.sql:15: NOTICE: drop cascades to table v.foo1445DROP SCHEMA14462026-11-13 15:01:48 [INFO] Running pgtap test: pg_graphql.sql1447$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pg_graphql.sql1448BEGIN1449COMMENT1450CREATE TABLE1451CREATE TABLE1452COMMENT1453CREATE FUNCTION1454 resolve 1455----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------1456 {"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}}}1457(1 row)14581459 resolve 1460--------------------------------------------------------------------------------------1461 {"data": {"insertIntoBlogCollection": {"records": [{"id": 1, "owner": {"id": 1}}]}}}1462(1 row)14631464 resolve 1465------------------------------------------------------------------------------------------------------------------------1466 {"data": {"insertIntoAccountCollection": {"records": [{"email": "baz@baz.com", "status": null}], "affectedCount": 1}}}1467(1 row)14681469 resolve 1470--------------------------------------------------------------------------------------------------------------------------------1471 {"data": {"xyz": {"records": [{"id": 4, "email": "foo@bar.com"}, {"id": 5, "email": "other@email.com"}], "affectedCount": 2}}}1472(1 row)14731474 resolve 1475------------------------------------------------------------------------------------------------1476 {"data": {"xyz": {"records": [{"email": "1@email.com", "status": null}], "affectedCount": 1}}}1477(1 row)14781479 resolve 1480------------------------------------------------------------------------------------------------1481 {"data": {"xyz": {"records": [{"email": "x@y.com", "status": "active"}], "affectedCount": 1}}}1482(1 row)14831484 resolve 1485-----------------------------------------------------------------------------------------------------------------1486 {"data": {"insertIntoAccountCollection": {"records": [{"id": 8, "email": "bar@foo.com"}], "affectedCount": 1}}}1487(1 row)14881489 resolve 1490-----------------------------------------------------------------------------------------------------------------1491 {"data": {"insertIntoAccountCollection": {"records": [{"id": 9, "email": "bar@foo.com"}], "affectedCount": 1}}}1492(1 row)14931494 resolve 1495--------------------------------------------------------------1496 {"data": {"insertIntoBlogCollection": {"affectedCount": 1}}}1497(1 row)14981499 resolve 1500---------------------------------------------------------------------------------------------------------------------1501 {"data": null, "errors": [{"message": "Input for type AccountInsertInput contains extra keys [\"doesNotExist\"]"}]}1502(1 row)15031504 resolve 1505-----------------------------------------------------------------------------------1506 {"data": null, "errors": [{"message": "Invalid input for BlogInsertInput type"}]}1507(1 row)15081509 resolve 1510---------------------------------------------------------------------------1511 {"data": null, "errors": [{"message": "Invalid input for NonNull type"}]}1512(1 row)15131514 resolve 1515--------------------------------------------------------------------------------------------1516 {"data": null, "errors": [{"message": "At least one record must be provided to objects"}]}1517(1 row)15181519ROLLBACK15202026-11-13 15:01:48 [INFO] Running pgtap test: pg_net.sql1521$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pg_net.sql1522 request_id 1523------------1524 11525(1 row)152615272026-11-13 15:01:48 [INFO] Running pgtap test: pg_plan_filter.sql1528$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pg_plan_filter.sql1529BEGIN1530psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pg_plan_filter.sql:2: ERROR: could not access file "plan_filter": No such file or directory1531psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pg_plan_filter.sql:4: ERROR: current transaction is aborted, commands ignored until end of transaction block1532psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pg_plan_filter.sql:10: ERROR: current transaction is aborted, commands ignored until end of transaction block1533psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pg_plan_filter.sql:14: ERROR: current transaction is aborted, commands ignored until end of transaction block1534psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pg_plan_filter.sql:16: ERROR: current transaction is aborted, commands ignored until end of transaction block1535psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pg_plan_filter.sql:18: ERROR: current transaction is aborted, commands ignored until end of transaction block1536ROLLBACK15372026-11-13 15:01:48 [INFO] Running pgtap test: pgaudit.sql1538$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pgaudit.sql1539SET1540SET1541SET1542CREATE SCHEMA1543CREATE TABLE1544INSERT 0 11545 id | name | password | description 1546----+-------+----------+-------------1547 1 | user1 | HASH1 | blah, blah1548(1 row)15491550psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pgaudit.sql:23: NOTICE: drop cascades to table v.account1551DROP SCHEMA15522026-11-13 15:01:48 [INFO] Running pgtap test: pgbouncer.sql1553$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pgbouncer.sql1554 schema_name | owner 1555-------------+-------1556(0 rows)15571558 schema_name | function_name | owner 1559-------------+---------------+-------1560(0 rows)15611562 schema | object_name | grantee | privilege_type 1563--------+-------------+---------+----------------1564(0 rows)15651566CREATE ROLE1567CREATE ROLE1568UPDATE 11569Null display is "<null>".1570psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pgbouncer.sql:62: ERROR: schema "pgbouncer" does not exist1571LINE 1: select * from pgbouncer.get_auth('test_expired_user_password...1572 ^1573psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pgbouncer.sql:64: ERROR: schema "pgbouncer" does not exist1574LINE 1: select pgbouncer.get_auth('test_valid_user_password');1575 ^1576psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pgbouncer.sql:67: ERROR: role "pgbouncer" does not exist1577psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pgbouncer.sql:68: ERROR: schema "pgbouncer" does not exist1578LINE 1: select pgbouncer.get_auth('test_valid_user_password');1579 ^1580RESET1581psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pgbouncer.sql:72: ERROR: role "postgres" does not exist1582psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pgbouncer.sql:73: ERROR: schema "pgbouncer" does not exist1583LINE 1: select pgbouncer.get_auth('test_valid_user_password');1584 ^1585RESET1586DROP ROLE1587DROP ROLE15882026-11-13 15:01:48 [INFO] Running pgtap test: pgcrypto_cipher_matrix.sql1589$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pgcrypto_cipher_matrix.sql1590BEGIN1591CREATE EXTENSION1592SAVEPOINT1593psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pgcrypto_cipher_matrix.sql:26: ERROR: encrypt error: Cipher cannot be initialized1594ROLLBACK1595SAVEPOINT1596psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pgcrypto_cipher_matrix.sql:30: ERROR: encrypt error: Cipher cannot be initialized1597ROLLBACK1598SAVEPOINT1599psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pgcrypto_cipher_matrix.sql:34: ERROR: encrypt error: Cipher cannot be initialized1600ROLLBACK1601 aes128_rt 1602-----------1603 secret1604(1 row)16051606 aes192_rt 1607-----------1608 secret1609(1 row)16101611 aes256_rt 1612-----------1613 secret1614(1 row)16151616 des3_rt 1617---------1618 secret1619(1 row)16201621SAVEPOINT1622psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pgcrypto_cipher_matrix.sql:45: ERROR: Wrong key or corrupt data1623ROLLBACK1624SAVEPOINT1625psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pgcrypto_cipher_matrix.sql:49: ERROR: Wrong key or corrupt data1626ROLLBACK1627 post_error_ok 1628---------------1629 still-here1630(1 row)16311632ROLLBACK16332026-11-13 15:01:48 [INFO] Running pgtap test: pgsodium.sql1634$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/pgsodium.sql1635 status 1636--------1637 valid1638(1 row)163916402026-11-13 15:01:48 [INFO] Running pgtap test: realtime.sql1641$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/realtime.sql1642 publication_name | owner | puballtables | pubinsert | pubupdate | pubdelete | pubtruncate 1643------------------+-------+--------------+-----------+-----------+-----------+-------------1644(0 rows)164516462026-11-13 15:01:48 [INFO] Running pgtap test: replica_identity_upsert.sql1647$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/replica_identity_upsert.sql1648BEGIN1649CREATE TABLE1650CREATE PUBLICATION1651INSERT 0 11652SAVEPOINT1653psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/replica_identity_upsert.sql:17: ERROR: cannot update table "ri" because it does not have a replica identity and publishes updates1654HINT: To enable updating the table, set REPLICA IDENTITY using ALTER TABLE.1655ROLLBACK1656SAVEPOINT1657psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/replica_identity_upsert.sql:22: ERROR: cannot update table "ri" because it does not have a replica identity and publishes updates1658HINT: To enable updating the table, set REPLICA IDENTITY using ALTER TABLE.1659ROLLBACK1660ALTER TABLE1661INSERT 0 11662MERGE 11663 v 1664----1665 301666(1 row)16671668ROLLBACK16692026-11-13 15:01:48 [INFO] Running pgtap test: storage.sql1670$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/storage.sql1671 schema_name | owner 1672-------------+-------1673(0 rows)16741675 schema_name | table_name | owner | rls_enabled | rls_policies 1676-------------+------------+-------+-------------+--------------1677(0 rows)16781679 schema_name | table_name | role_name | privilege_type | is_grantable 1680-------------+------------+-----------+----------------+--------------1681(0 rows)16821683 table_schema | table_name | index_name | index_owner 1684--------------+------------+------------+-------------1685(0 rows)16861687 schema_name | function_name | owner 1688-------------+---------------+-------1689(0 rows)16901691CREATE ROLE1692psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/storage.sql:98: ERROR: role "postgres" does not exist1693psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/storage.sql:100: ERROR: role "postgres" does not exist1694psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/storage.sql:101: ERROR: schema "storage" does not exist1695psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/storage.sql:102: ERROR: schema "storage" does not exist1696psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/storage.sql:104: ERROR: role "postgres" does not exist1697DROP OWNED1698DROP ROLE1699RESET17002026-11-13 15:01:49 [INFO] Running pgtap test: supautils_reserved_memberships.sql1701$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_memberships.sql1702psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_memberships.sql:1: ERROR: role "postgres" does not exist1703psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_memberships.sql:3: ERROR: role "postgres" does not exist1704psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_memberships.sql:4: ERROR: role "postgres" does not exist1705psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_memberships.sql:5: ERROR: role "postgres" does not exist1706psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_memberships.sql:6: ERROR: role "postgres" does not exist1707psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_memberships.sql:7: ERROR: role "postgres" does not exist1708psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_memberships.sql:8: ERROR: role "postgres" does not exist1709psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_memberships.sql:9: ERROR: role "postgres" does not exist1710psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_memberships.sql:10: ERROR: role "postgres" does not exist1711psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_memberships.sql:11: ERROR: role "postgres" does not exist1712psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_memberships.sql:12: ERROR: role "postgres" does not exist1713psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_memberships.sql:13: ERROR: role "postgres" does not exist1714psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_memberships.sql:14: ERROR: role "postgres" does not exist1715psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_memberships.sql:15: ERROR: role "postgres" does not exist1716psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_memberships.sql:16: ERROR: role "postgres" does not exist1717RESET17182026-11-13 15:01:49 [INFO] Running pgtap test: supautils_reserved_roles.sql1719$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_roles.sql1720BEGIN1721psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_roles.sql:5: ERROR: role "postgres" does not exist1722psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_roles.sql:8: ERROR: current transaction is aborted, commands ignored until end of transaction block1723psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_roles.sql:9: ERROR: current transaction is aborted, commands ignored until end of transaction block1724psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_roles.sql:10: ERROR: savepoint "before_drop" does not exist1725psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_roles.sql:12: ERROR: current transaction is aborted, commands ignored until end of transaction block1726psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/supautils_reserved_roles.sql:14: ERROR: current transaction is aborted, commands ignored until end of transaction block1727ROLLBACK17282026-11-13 15:01:49 [INFO] Running pgtap test: to_char_v_overflow.sql1729$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/to_char_v_overflow.sql1730 to_char 1731-------------1732 20000000001733(1 row)17341735 to_char 1736-------------1737 21474836401738(1 row)17391740 to_char 1741-------------1742 -20000000001743(1 row)17441745psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/to_char_v_overflow.sql:19: ERROR: integer out of range1746psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/to_char_v_overflow.sql:20: ERROR: integer out of range1747psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/to_char_v_overflow.sql:21: ERROR: integer out of range17482026-11-13 15:01:49 [INFO] Running pgtap test: upsert_rls_conflict_where.sql1749$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/upsert_rls_conflict_where.sql1750BEGIN1751CREATE TABLE1752INSERT 0 11753ALTER TABLE1754CREATE POLICY1755psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/upsert_rls_conflict_where.sql:19: ERROR: role "postgres" does not exist1756psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/upsert_rls_conflict_where.sql:23: ERROR: current transaction is aborted, commands ignored until end of transaction block1757psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/upsert_rls_conflict_where.sql:25: ERROR: current transaction is aborted, commands ignored until end of transaction block1758psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/upsert_rls_conflict_where.sql:28: ERROR: current transaction is aborted, commands ignored until end of transaction block1759psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/upsert_rls_conflict_where.sql:31: ERROR: current transaction is aborted, commands ignored until end of transaction block1760psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/upsert_rls_conflict_where.sql:32: ERROR: savepoint "s" does not exist1761psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/upsert_rls_conflict_where.sql:34: ERROR: current transaction is aborted, commands ignored until end of transaction block1762ROLLBACK17632026-11-13 15:01:49 [INFO] Running pgtap test: upsert_view_visibility.sql1764$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/upsert_view_visibility.sql1765BEGIN1766CREATE TABLE1767INSERT 0 21768CREATE VIEW1769SAVEPOINT1770psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/upsert_view_visibility.sql:24: ERROR: conflicting row is not visible through view "uv_upsert_view"1771ROLLBACK1772 id | secret | vis 1773----+--------+-----1774 2 | 0 | t1775(1 row)17761777INSERT 0 11778ROLLBACK17792026-11-13 15:01:49 [INFO] Running pgtap test: vault.sql1780$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/vault.sql1781 schema | object_name | grantee | privilege_type 1782--------+---------------------------+----------------+----------------1783 vault | _crypto_aead_det_decrypt | supabase_admin | EXECUTE1784 vault | _crypto_aead_det_encrypt | supabase_admin | EXECUTE1785 vault | _crypto_aead_det_noncegen | supabase_admin | EXECUTE1786 vault | create_secret | supabase_admin | EXECUTE1787 vault | update_secret | supabase_admin | EXECUTE1788(5 rows)17891790 schema | table | index_name | index_owner | index_type 1791--------+---------+------------------+----------------+------------1792 vault | secrets | secrets_name_idx | supabase_admin | Unique1793 vault | secrets | secrets_pkey | supabase_admin | Unique1794(2 rows)17951796 search_path 1797-----------------1798 "$user", public1799(1 row)18001801SET1802DROP EXTENSION1803CREATE TABLE1804psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/vault.sql:65: ERROR: role "postgres" does not exist1805LINE 1: ...g_extension values (0, 'supabase_vault', '0.2.8', 'postgres'...1806 ^1807CREATE EXTENSION1808DROP TABLE1809RESET1810 function_name | grantee | privilege_type 1811---------------+---------+----------------1812(0 rows)18131814psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/vault.sql:83: ERROR: role "postgres" does not exist1815 search_path 1816-----------------1817 "$user", public1818(1 row)181918202026-11-13 15:01:49 [INFO] Running pgtap test: wal2json.sql1821$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/wal2json.sql1822CREATE SCHEMA1823CREATE TABLE1824psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/wal2json.sql:10: ERROR: could not access file "wal2json": No such file or directory1825INSERT 0 11826psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/wal2json.sql:28: ERROR: replication slot "reg_test" does not exist1827psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/wal2json.sql:31: ERROR: replication slot "reg_test" does not exist1828psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/wal2json.sql:33: NOTICE: drop cascades to table v.foo1829DROP SCHEMA18302026-11-13 15:01:49 [INFO] Running pgtap test: z_17_intarray_ltree_query.sql1831$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/z_17_intarray_ltree_query.sql1832BEGIN1833SET1834CREATE EXTENSION1835psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/z_17_intarray_ltree_query.sql:7: ERROR: lquery level is too large1836DETAIL: Total size of level exceeds the maximum allowed (65535 bytes).1837psql:/nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/z_17_intarray_ltree_query.sql:9: ERROR: current transaction is aborted, commands ignored until end of transaction block1838ROLLBACK18392026-11-13 15:01:49 [INFO] Running pgtap test: z_17_wal_summarize.sql1840$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/vflip83fb3ap1cawg7laqf328dwrr4lk-sql/z_17_wal_summarize.sql1841 summarize_wal_default_ok 1842--------------------------1843 f1844(1 row)18451846$ pg_ctl -D /build/tmp.hNMG3EquQG stop1847waiting for server to shut down.... done1848server stopped18492026-11-13 15:01:50 [INFO] Starting PostgreSQL server for pg_regress tests1850$ /nix/store/v27x11khdqj67y0wnjpdqp98lnjmlm9y-start-postgres-server-test/bin/start-postgres-server 17 --daemonize1851Starting server for PSQL 171852/nix/store/v27x11khdqj67y0wnjpdqp98lnjmlm9y-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 directory1853KEY_FILE: /build/tmp.F7x7v6XYSa/pgsodium.key1854KEY_FILE contents:1855cat: /build/tmp.F7x7v6XYSa/pgsodium.key: No such file or directory1856PGSODIUM_GETKEY_SCRIPT: /nix/store/1pwkb9dqp63rk9xi9f2vr1s4vd57z0yr-pgsodium-getkey/bin/pgsodium-getkey1857NOTE: using port 5541 for server1858NOTE: using temporary directory /build/tmp.F7x7v6XYSa for data1859NOTE: you are free to re-use this data directory at will1860The files belonging to this database system will be owned by user "nixbld".1861This user must also own the server process.18621863The database cluster will be initialized with locale "en_US.UTF-8".1864The default database encoding has accordingly been set to "UTF8".1865The default text search configuration will be set to "english".18661867Data page checksums are disabled.18681869fixing permissions on existing directory /build/tmp.F7x7v6XYSa ... ok1870creating subdirectories ... ok1871selecting dynamic shared memory implementation ... posix1872selecting default "max_connections" ... 1001873selecting default "shared_buffers" ... 128MB1874selecting default time zone ... UTC1875creating configuration files ... ok1876running bootstrap script ... ok1877performing post-bootstrap initialization ... ok1878syncing data to disk ... ok18791880initdb: warning: enabling "trust" authentication for local connections1881initdb: 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.18821883Success. You can now start the database server using:18841885 /nix/store/2i98gv8zmq2gq8j4n8ccwn5yhh5vx03z-postgresql-and-plugins-17.12/bin/pg_ctl -D /build/tmp.F7x7v6XYSa -l logfile start18861887NOTE: patching postgresql.conf files1888non-macos pg 17 conf1889waiting for server to start.... done1890server started1891pg_ctl: server is running (PID: 1423)1892/nix/store/2i98gv8zmq2gq8j4n8ccwn5yhh5vx03z-postgresql-and-plugins-17.12/bin/postgres "-D" "/build/tmp.F7x7v6XYSa" "--config-file=/build/tmp.F7x7v6XYSa/postgresql.conf" "-p" "5541" "-k" "/build/tmp.F7x7v6XYSa/tmp"1893PostgreSQL is ready1894NOTICE: empty string is not a valid password, clearing password1895CREATE ROLE1896ALTER DATABASE1897Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/init-scripts/00000000000000-initial-schema.sql1898CREATE PUBLICATION1899ALTER ROLE1900CREATE ROLE1901CREATE ROLE1902GRANT ROLE1903GRANT1904CREATE ROLE1905GRANT ROLE1906CREATE SCHEMA1907CREATE EXTENSION1908CREATE EXTENSION1909CREATE ROLE1910CREATE ROLE1911CREATE ROLE1912CREATE ROLE1913GRANT ROLE1914GRANT ROLE1915GRANT ROLE1916GRANT ROLE1917GRANT1918ALTER DEFAULT PRIVILEGES1919ALTER DEFAULT PRIVILEGES1920ALTER DEFAULT PRIVILEGES1921GRANT1922ALTER ROLE1923ALTER DEFAULT PRIVILEGES1924ALTER DEFAULT PRIVILEGES1925ALTER DEFAULT PRIVILEGES1926ALTER ROLE1927ALTER ROLE1928Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/init-scripts/00000000000001-auth-schema.sql1929CREATE SCHEMA1930CREATE TABLE1931CREATE INDEX1932CREATE INDEX1933COMMENT1934CREATE TABLE1935CREATE INDEX1936CREATE INDEX1937CREATE INDEX1938COMMENT1939CREATE TABLE1940COMMENT1941CREATE TABLE1942CREATE INDEX1943COMMENT1944CREATE TABLE1945COMMENT1946INSERT 0 71947CREATE FUNCTION1948CREATE FUNCTION1949CREATE FUNCTION1950GRANT1951CREATE ROLE1952GRANT1953GRANT1954GRANT1955ALTER ROLE1956ALTER TABLE1957ALTER TABLE1958ALTER TABLE1959ALTER TABLE1960ALTER TABLE1961Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/init-scripts/00000000000002-storage-schema.sql1962CREATE SCHEMA1963CREATE ROLE1964ALTER ROLE1965GRANT1966DO1967Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/init-scripts/00000000000003-post-setup.sql1968ALTER ROLE1969ALTER ROLE1970CREATE FUNCTION1971CREATE EVENT TRIGGER1972COMMENT1973CREATE FUNCTION1974COMMENT1975DO1976CREATE ROLE1977GRANT1978GRANT1979GRANT1980GRANT1981GRANT1982GRANT1983GRANT1984GRANT1985GRANT1986DO1987NOTICE: empty string is not a valid password, clearing password1988ALTER ROLE1989CREATE ROLE1990REVOKE1991CREATE SCHEMA1992CREATE FUNCTION1993REVOKE1994GRANT1995psql:/nix/store/0s4wf39csywl7iy2bchhiaqzcinrk17w-stat-extension:1: NOTICE: schema "extensions" already exists, skipping1996CREATE SCHEMA1997CREATE EXTENSION1998Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/10000000000000_demote-postgres.sql1999GRANT2000GRANT2001GRANT2002GRANT2003GRANT2004GRANT2005GRANT2006GRANT2007GRANT2008DO2009ALTER ROLE2010Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20211115181400_update-auth-permissions.sql2011GRANT2012GRANT2013GRANT2014ALTER TABLE2015ALTER TABLE2016ALTER TABLE2017ALTER TABLE2018ALTER TABLE2019GRANT2020GRANT2021GRANT2022GRANT2023ALTER DEFAULT PRIVILEGES2024ALTER DEFAULT PRIVILEGES2025ALTER DEFAULT PRIVILEGES2026Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20211118015519_create-realtime-schema.sql2027CREATE SCHEMA2028Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20211122051245_update-realtime-permissions.sql2029GRANT2030GRANT2031GRANT2032GRANT2033Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20211124212715_update-auth-owner.sql2034DO2035DO2036DO2037Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20211130151719_update-realtime-permissions.sql2038ALTER DEFAULT PRIVILEGES2039ALTER DEFAULT PRIVILEGES2040ALTER DEFAULT PRIVILEGES2041Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20220118070449_enable-safeupdate-postgrest.sql2042ALTER ROLE2043Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20220126121436_finer-postgrest-triggers.sql2044psql:/nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20220126121436_finer-postgrest-triggers.sql:3: NOTICE: event trigger "api_restart" does not exist, skipping2045DROP EVENT TRIGGER2046psql:/nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20220126121436_finer-postgrest-triggers.sql:4: NOTICE: function extensions.notify_api_restart() does not exist, skipping2047DROP FUNCTION2048CREATE FUNCTION2049CREATE FUNCTION2050psql:/nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20220126121436_finer-postgrest-triggers.sql:59: NOTICE: event trigger "pgrst_ddl_watch" does not exist, skipping2051DROP EVENT TRIGGER2052CREATE EVENT TRIGGER2053psql:/nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20220126121436_finer-postgrest-triggers.sql:64: NOTICE: event trigger "pgrst_drop_watch" does not exist, skipping2054DROP EVENT TRIGGER2055CREATE EVENT TRIGGER2056Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20220224211803_fix-postgrest-supautils.sql2057DO2058Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20220317095840_pg_graphql.sql2059CREATE SCHEMA2060psql:/nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20220317095840_pg_graphql.sql:5: NOTICE: function graphql_public.graphql(text,text,jsonb) does not exist, skipping2061DROP FUNCTION2062CREATE FUNCTION2063GRANT2064ALTER DEFAULT PRIVILEGES2065ALTER DEFAULT PRIVILEGES2066ALTER DEFAULT PRIVILEGES2067ALTER DEFAULT PRIVILEGES2068ALTER DEFAULT PRIVILEGES2069ALTER DEFAULT PRIVILEGES2070CREATE FUNCTION2071psql:/nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20220317095840_pg_graphql.sql:90: NOTICE: event trigger "issue_pg_graphql_access" does not exist, skipping2072DROP EVENT TRIGGER2073CREATE EVENT TRIGGER2074COMMENT2075CREATE FUNCTION2076psql:/nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20220317095840_pg_graphql.sql:143: NOTICE: event trigger "issue_graphql_placeholder" does not exist, skipping2077DROP EVENT TRIGGER2078CREATE EVENT TRIGGER2079COMMENT2080Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20220321174452_fix-postgrest-alter-type-event-trigger.sql2081psql:/nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20220321174452_fix-postgrest-alter-type-event-trigger.sql:3: NOTICE: event trigger "api_restart" does not exist, skipping2082DROP EVENT TRIGGER2083psql:/nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20220321174452_fix-postgrest-alter-type-event-trigger.sql:4: NOTICE: function extensions.notify_api_restart() does not exist, skipping2084DROP FUNCTION2085CREATE FUNCTION2086CREATE FUNCTION2087DROP EVENT TRIGGER2088CREATE EVENT TRIGGER2089DROP EVENT TRIGGER2090CREATE EVENT TRIGGER2091Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20220322085208_gotrue-session-limit.sql2092ALTER ROLE2093Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20220404205710_pg_graphql-on-by-default.sql2094CREATE FUNCTION2095CREATE FUNCTION2096CREATE FUNCTION2097psql:/nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20220404205710_pg_graphql-on-by-default.sql:142: NOTICE: extension "pg_graphql" does not exist, skipping2098DROP EXTENSION2099DO2100Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20220609081115_grant-supabase-auth-admin-and-supabase-storage-admin-to-postgres.sql2101GRANT ROLE2102Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20220613123923_pg_graphql-pg-dump-perms.sql2103CREATE FUNCTION2104DROP EXTENSION2105DO2106Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20220713082019_pg_cron-pg_net-temp-perms-fix.sql2107DO2108DO2109Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20221028101028_set_authenticator_timeout.sql2110ALTER ROLE2111Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20221103090837_revoke_admin.sql2112REVOKE ROLE2113Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20221207154255_create_pgsodium_and_vault.sql2114DO2115Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20230201083204_grant_auth_roles_to_postgres.sql2116GRANT ROLE2117Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20230224042246_grant_extensions_perms_for_postgres.sql2118GRANT2119GRANT2120GRANT2121ALTER DEFAULT PRIVILEGES2122ALTER DEFAULT PRIVILEGES2123ALTER DEFAULT PRIVILEGES2124Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20230306081037_grant_pg_monitor_to_postgres.sql2125GRANT ROLE2126Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20230327032006_grant_auth_roles_to_supabase_storage_admin.sql2127GRANT ROLE2128Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20230529180330_alter_api_roles_for_inherit.sql2129ALTER ROLE2130ALTER ROLE2131ALTER ROLE2132DO2133Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20231013070755_grant_authenticator_to_supabase_storage_admin.sql2134GRANT ROLE2135REVOKE ROLE2136Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20231017062225_grant_pg_graphql_permissions_for_custom_roles.sql2137CREATE FUNCTION2138DROP EXTENSION2139DO2140Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20231020085357_revoke_writes_on_cron_job_from_postgres.sql2141DO2142CREATE FUNCTION2143DROP EVENT TRIGGER2144ALTER FUNCTION2145CREATE EVENT TRIGGER2146Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20231130133139_set_lock_timeout_to_authenticator_role.sql2147ALTER ROLE2148Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20240124080435_alter_lo_export_lo_import_owner.sql2149ALTER FUNCTION2150ALTER FUNCTION2151ALTER FUNCTION2152Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20240606060239_grant_predefined_roles_to_postgres.sql2153GRANT ROLE2154Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20241031003909_create_orioledb.sql2155DO2156Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20241215003910_backfill_pgmq_metadata.sql2157DO2158DO2159Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20250205060043_disable_log_statement_on_internal_roles.sql2160ALTER ROLE2161ALTER ROLE2162ALTER ROLE2163Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20250205144616_move_orioledb_to_extensions_schema.sql2164DO2165Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20250218031949_pgsodium_mask_role.sql2166DO2167Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20250220051611_pg_net_perms_fix.sql2168CREATE FUNCTION2169DO2170Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20250312095419_pgbouncer_ownership.sql2171ALTER FUNCTION2172GRANT2173Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20250402065937_alter_internal_event_triggers_owner_to_supabase_admin.sql2174DROP EVENT TRIGGER2175ALTER FUNCTION2176CREATE EVENT TRIGGER2177Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20250402093753_grant_subscription_to_postgres_16_and_above.sql2178DO2179Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20250417190610_update_pgbouncer_get_auth.sql2180CREATE FUNCTION2181GRANT2182Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20250421084701_revoke_admin_roles_from_postgres.sql2183REVOKE ROLE2184DO2185DO2186REVOKE ROLE2187REVOKE2188DO2189Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20250605172253_grant_with_admin_to_postgres_16_and_above.sql2190DO2191Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20250623125453_tmp_grant_storage_tables_to_postgres_with_grant_option.sql2192DO2193Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20250709135250_grant_storage_schema_to_postgres_with_grant_option.sql2194DO2195Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20250710151649_supabase_read_only_user_default_transaction_read_only.sql2196ALTER ROLE2197Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20251001204436_predefined_role_grants.sql2198GRANT ROLE2199DO2200Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20251105172723_grant_pg_reload_conf_to_postgres.sql2201GRANT2202Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20251121132723_correct_search_path_pgbouncer.sql2203CREATE FUNCTION2204REVOKE2205REVOKE2206GRANT2207Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20260211120934_supabase_privileged_role.sql2208DO2209Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20260413000000_fix-authenticator-session-preload-libraries.sql2210ALTER ROLE2211Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20260421000000_pg_graphql-off-by-default.sql2212DROP EXTENSION2213Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20260421000001_rescope_pg_graphql_access_trigger.sql2214CREATE FUNCTION2215DROP EVENT TRIGGER2216CREATE EVENT TRIGGER2217Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20260730000000_revoke_trigger_on_cron_tables_from_postgres.sql2218DO2219CREATE FUNCTION2220Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20260923021047_update_pgrst_watch_triggers.sql2221CREATE FUNCTION2222CREATE FUNCTION2223Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20261016000001_search_path_for_supa_functions.sql2224CREATE FUNCTION2225CREATE FUNCTION2226CREATE FUNCTION2227CREATE FUNCTION2228CREATE FUNCTION2229CREATE FUNCTION2230Running /nix/store/jsh5scbddqv00516d42cnydafj5h14mr-migrations/migrations/20261023000000_pgmq_drop_queue_search_path.sql2231DO2232ALTER DATABASE2233ALTER DATABASE2234ALTER ROLE2235ALTER ROLE2236ALTER ROLE2237ALTER ROLE2238ALTER ROLE2239ALTER ROLE2240ALTER ROLE2241ALTER ROLE2242ALTER ROLE2243ALTER ROLE2244Shutting down PostgreSQL...2245PostgreSQL is running in daemon mode. Please stop it using pg_ctl.2246pg_ctl: another server might be running; trying to start server anyway2247waiting for server to start.... stopped waiting2248pg_ctl: could not start server2249Examine the log output.2250pg_ctl: server is running (PID: 1423)2251/nix/store/2i98gv8zmq2gq8j4n8ccwn5yhh5vx03z-postgresql-and-plugins-17.12/bin/postgres "-D" "/build/tmp.F7x7v6XYSa" "--config-file=/build/tmp.F7x7v6XYSa/postgresql.conf" "-p" "5541" "-k" "/build/tmp.F7x7v6XYSa/tmp"2252$ pg_isready -h localhost -p 5541 -U supabase_admin -q22532026-11-13 15:01:55 [INFO] PostgreSQL is ready22542026-11-13 15:01:55 [INFO] CLI variant detected - loading CLI prime SQL file2255$ psql -p 5541 -h localhost --no-password --username=supabase_admin -d postgres -v ON_ERROR_STOP=1 -Xf /nix/store/ib75j74vyc0w374jcz7mqcg6njf21yx3-prime-cli.sql2256SET2257CREATE EXTENSION2258CREATE EXTENSION2259CREATE EXTENSION2260CREATE EXTENSION22612026-11-13 15:01:55 [INFO] Creating test_config table for pg_regress tests2262$ psql -p 5541 -h localhost --no-password --username=supabase_admin -d postgres -c 2263 CREATE TABLE IF NOT EXISTS test_config (key TEXT PRIMARY KEY, value TEXT);2264 INSERT INTO test_config (key, value) VALUES ('http_mock_port', '8880')2265 ON CONFLICT (key) DO UPDATE SET value = EXCLUDED.value;2266 INSERT INTO test_config (key, value) VALUES ('http_mock_host', 'localhost')2267 ON CONFLICT (key) DO UPDATE SET value = EXCLUDED.value;22682269CREATE TABLE2270INSERT 0 12271INSERT 0 122722026-11-13 15:01:55 [INFO] CLI variant detected - running subset of pg_regress tests (47 tests)2273$ pg_regress --use-existing --dbname=postgres --inputdir=/nix/store/0ks4kdffckw2wy32jh6bhyl9zam1xhw6-tests --outputdir=/nix/store/shkqd39h2wcy2rm3w8pc594c3g8sirzh-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_summarize2274(using postmaster on localhost, port 5541)2275============== running regression test queries ==============2276test alter_column_type_rowtype_deps ... ok 16 ms2277test auth ... ok 18 ms2278test cast_function_execute_privilege ... FAILED 14 ms2279test create_statistics_priv ... ok 16 ms2280test dblink ... ok 61 ms2281test docs-array-test ... ok 20 ms2282test docs-cascades-deletes ... ok 196 ms2283test docs-connections ... ok 13 ms2284test docs-enums ... ok 83 ms2285test docs-full-text-search ... ok 52 ms2286test docs-functions ... ok 133 ms2287test docs-indexes ... ok 53 ms2288test docs-json ... ok 23 ms2289test docs-partitioning ... ok 53 ms2290test docs-tables-and-data ... ok 254 ms2291test docs-triggers ... ok 151 ms2292test docs-webhooks ... ok 107 ms2293test drop_owned_rls_policy ... ok 16 ms2294test enable_tracking ... ok 15 ms2295test event_trigger_search_path ... ok 13 ms2296test function_def_target_alias ... ok 15 ms2297test intarray_ltree_query ... ok 96 ms2298test jsonpath_gin_lookup ... ok 16 ms2299test ltree_label_overflow ... ok 69 ms2300test multirange_create_priv ... ok 14 ms2301test operator_breaking_change ... ok 44 ms2302test partition_prune_range ... ok 22 ms2303test pg-safeupdate ... ok 23 ms2304test pg_graphql ... ok 90 ms2305test pg_net ... ok 12 ms2306test pg_plan_filter ... ok 16 ms2307test pgaudit ... ok 24 ms2308test pgbouncer ... ok 37 ms2309test pgcrypto_cipher_matrix ... ok 32 ms2310test pgsodium ... ok 15 ms2311test realtime ... ok 14 ms2312test replica_identity_upsert ... ok 17 ms2313test storage ... ok 34 ms2314test supautils_reserved_memberships ... ok 10 ms2315test supautils_reserved_roles ... ok 11 ms2316test to_char_v_overflow ... ok 10 ms2317test upsert_rls_conflict_where ... FAILED 18 ms2318test upsert_view_visibility ... ok 15 ms2319test vault ... ok 43 ms2320test wal2json ... ok 81 ms2321test z_17_intarray_ltree_query ... ok 66 ms2322test z_17_wal_summarize ... ok 12 ms23232324=======================2325 2 of 47 tests failed. 2326=======================23272328The differences that caused some tests to fail can be viewed in the2329file "/nix/store/shkqd39h2wcy2rm3w8pc594c3g8sirzh-run-check-harness-psql-17-cli/regression_output/regression.diffs". A copy of the test summary that you see2330above is saved in the file "/nix/store/shkqd39h2wcy2rm3w8pc594c3g8sirzh-run-check-harness-psql-17-cli/regression_output/regression.out".233123322026-11-13 15:01:57 [ERROR] pg_regress tests failed23332026-11-13 15:01:57 [ERROR] An error occurred. Exit code: 123342026-11-13 15:01:57 [ERROR] Debug logs: