run-check-harness-psql-17-cli
checks.aarch64-linux.psql_17_cli
· build #677
· raw
12026-11-12 08:56:00 [INFO] Starting HTTP mock server (will find free port)...22026-11-12 08:56:01 [INFO] HTTP mock server started on port 888032026-11-12 08:56:01 [INFO] Creating temporary PostgreSQL cluster at /build/tmp.46TA9YzZm842026-11-12 08:56:01 [INFO] Generated preload libraries: pg_cron, pg_net, pgsodium, supabase_vault52026-11-12 08:56:01 [INFO] Checking shared_preload_libraries setting:62026-11-12 08:56:01 [INFO] 721:shared_preload_libraries = 'pg_cron, pg_net, pgsodium, supabase_vault' # (change requires restart)72026-11-12 08:56:01 [INFO] Configuring local auth82026-11-12 08:56:02 [INFO] Waiting for PostgreSQL to be ready...92026-11-12 08:56:02 [INFO] PostgreSQL is ready102026-11-12 08:56:02 [INFO] Creating test database112026-11-12 08:56:02 [INFO] CLI variant detected - loading CLI prime SQL file122026-11-12 08:56:02 [INFO] Creating test_config table132026-11-12 08:56:02 [INFO] Running pgtap test: auth.sql142026-11-12 08:56:02 [INFO] Running pgtap test: create_statistics_priv.sql152026-11-12 08:56:02 [INFO] Running pgtap test: dblink.sql162026-11-12 08:56:02 [INFO] Running pgtap test: docs-array-test.sql172026-11-12 08:56:02 [INFO] Running pgtap test: docs-cascades-deletes.sql182026-11-12 08:56:02 [INFO] Running pgtap test: docs-connections.sql192026-11-12 08:56:02 [INFO] Running pgtap test: docs-enums.sql202026-11-12 08:56:03 [INFO] Running pgtap test: docs-full-text-search.sql212026-11-12 08:56:03 [INFO] Running pgtap test: docs-functions.sql222026-11-12 08:56:03 [INFO] Running pgtap test: docs-indexes.sql232026-11-12 08:56:03 [INFO] Running pgtap test: docs-json.sql242026-11-12 08:56:03 [INFO] Running pgtap test: docs-partitioning.sql252026-11-12 08:56:03 [INFO] Running pgtap test: docs-tables-and-data.sql262026-11-12 08:56:03 [INFO] Running pgtap test: docs-triggers.sql272026-11-12 08:56:03 [INFO] Running pgtap test: docs-webhooks.sql282026-11-12 08:56:04 [INFO] Running pgtap test: enable_tracking.sql292026-11-12 08:56:04 [INFO] Running pgtap test: event_trigger_search_path.sql302026-11-12 08:56:04 [INFO] Running pgtap test: intarray_ltree_query.sql312026-11-12 08:56:04 [INFO] Running pgtap test: ltree_label_overflow.sql322026-11-12 08:56:04 [INFO] Running pgtap test: multirange_create_priv.sql332026-11-12 08:56:04 [INFO] Running pgtap test: operator_breaking_change.sql342026-11-12 08:56:04 [INFO] Running pgtap test: pg-safeupdate.sql352026-11-12 08:56:04 [INFO] Running pgtap test: pg_graphql.sql362026-11-12 08:56:04 [INFO] Running pgtap test: pg_net.sql372026-11-12 08:56:04 [INFO] Running pgtap test: pg_plan_filter.sql382026-11-12 08:56:04 [INFO] Running pgtap test: pgaudit.sql392026-11-12 08:56:04 [INFO] Running pgtap test: pgbouncer.sql402026-11-12 08:56:04 [INFO] Running pgtap test: pgcrypto_cipher_matrix.sql412026-11-12 08:56:04 [INFO] Running pgtap test: pgsodium.sql422026-11-12 08:56:04 [INFO] Running pgtap test: realtime.sql432026-11-12 08:56:05 [INFO] Running pgtap test: replica_identity_upsert.sql442026-11-12 08:56:05 [INFO] Running pgtap test: storage.sql452026-11-12 08:56:05 [INFO] Running pgtap test: supautils_reserved_memberships.sql462026-11-12 08:56:05 [INFO] Running pgtap test: supautils_reserved_roles.sql472026-11-12 08:56:05 [INFO] Running pgtap test: vault.sql482026-11-12 08:56:05 [INFO] Running pgtap test: wal2json.sql492026-11-12 08:56:05 [INFO] Running pgtap test: z_17_intarray_ltree_query.sql502026-11-12 08:56:05 [INFO] Running pgtap test: z_17_supabase_monitor_admin.sql512026-11-12 08:56:05 [INFO] Running pgtap test: z_17_wal_summarize.sql522026-11-12 08:56:05 [INFO] Starting PostgreSQL server for pg_regress tests532026-11-12 08:56:10 [INFO] PostgreSQL is ready542026-11-12 08:56:10 [INFO] CLI variant detected - loading CLI prime SQL file552026-11-12 08:56:10 [INFO] Creating test_config table for pg_regress tests562026-11-12 08:56:10 [INFO] CLI variant detected - running subset of pg_regress tests (39 tests)572026-11-12 08:56:12 [ERROR] pg_regress tests failed58diff -U3 /nix/store/8xc1cmaljps5lxpfv66ik0v4vay4dsq5-tests/expected/z_17_supabase_monitor_admin.out /nix/store/0s9wba6r6n9b4lyzqb0r8j40lwvc057c-run-check-harness-psql-17-cli/regression_output/results/z_17_supabase_monitor_admin.out59--- /nix/store/8xc1cmaljps5lxpfv66ik0v4vay4dsq5-tests/expected/z_17_supabase_monitor_admin.out 1970-01-01 00:00:01.000000000 +000060+++ /nix/store/0s9wba6r6n9b4lyzqb0r8j40lwvc057c-run-check-harness-psql-17-cli/regression_output/results/z_17_supabase_monitor_admin.out 2026-11-12 08:56:12.453959953 +000061@@ -1,5 +1,4 @@62--- supabase_monitor_admin: passwordless, read-only63--- monitoring role (quick_explainer.md,64+-- supabase_monitor_admin: passwordless, read-only, for monitoring from localhost65 -- migrations/db/init-scripts/00000000000000-initial-schema.sql)66 -- attributes: login, no password, bypassrls, nothing else67 -- only accessible via localhost682026-11-12 08:56:12 [ERROR] An error occurred. Exit code: 1692026-11-12 08:56:12 [ERROR] Debug logs:702026-11-12 08:56:00 [INFO] Starting HTTP mock server (will find free port)...71$ /nix/store/a1mjjnpfivsx5gi4rxbcr54vl6gyjfzj-python3-3.13.11/bin/python3 /nix/store/sfl1mnhcw0ccky7m2crn0hda79clq4mk-http-mock-server.py722026-11-12 08:56:01 [INFO] HTTP mock server started on port 8880732026-11-12 08:56:01 [INFO] Creating temporary PostgreSQL cluster at /build/tmp.46TA9YzZm874$ initdb --locale=C --username=supabase_admin -D /build/tmp.46TA9YzZm875The files belonging to this database system will be owned by user "nixbld".76This user must also own the server process.7778The database cluster will be initialized with locale "C".79The default database encoding has accordingly been set to "SQL_ASCII".80The default text search configuration will be set to "english".8182Data page checksums are disabled.8384fixing permissions on existing directory /build/tmp.46TA9YzZm8 ... ok85creating subdirectories ... ok86selecting dynamic shared memory implementation ... posix87selecting default "max_connections" ... 10088selecting default "shared_buffers" ... 128MB89selecting default time zone ... UTC90creating configuration files ... ok91running bootstrap script ... ok92performing post-bootstrap initialization ... ok93syncing data to disk ... ok9495initdb: warning: enabling "trust" authentication for local connections96initdb: 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.9798Success. You can now start the database server using:99100 pg_ctl -D /build/tmp.46TA9YzZm8 -l logfile start1011022026-11-12 08:56:01 [INFO] Generated preload libraries: pg_cron, pg_net, pgsodium, supabase_vault1032026-11-12 08:56:01 [INFO] Checking shared_preload_libraries setting:1042026-11-12 08:56:01 [INFO] 721:shared_preload_libraries = 'pg_cron, pg_net, pgsodium, supabase_vault' # (change requires restart)1052026-11-12 08:56:01 [INFO] Configuring local auth106$ pg_ctl -D /build/tmp.46TA9YzZm8 -l /build/tmp.46TA9YzZm8/postgresql.log -o -k /build/tmp.46TA9YzZm8/sockets -p 5541 -d 5 start107waiting for server to start.... done108server started1092026-11-12 08:56:02 [INFO] Waiting for PostgreSQL to be ready...110$ pg_isready -h localhost -p 5541 -U supabase_admin -q1112026-11-12 08:56:02 [INFO] PostgreSQL is ready1122026-11-12 08:56:02 [INFO] Creating test database113$ createdb -p 5541 -h localhost --username=supabase_admin testing1142026-11-12 08:56:02 [INFO] CLI variant detected - loading CLI prime SQL file115$ psql -p 5541 -h localhost --username=supabase_admin -d testing -v ON_ERROR_STOP=1 -Xf /nix/store/ib75j74vyc0w374jcz7mqcg6njf21yx3-prime-cli.sql116SET117CREATE EXTENSION118CREATE EXTENSION119CREATE EXTENSION120CREATE EXTENSION1212026-11-12 08:56:02 [INFO] Creating test_config table122$ psql -p 5541 -h localhost --username=supabase_admin -d testing -c 123 CREATE TABLE IF NOT EXISTS test_config (key TEXT PRIMARY KEY, value TEXT);124 INSERT INTO test_config (key, value) VALUES ('http_mock_port', '8880')125 ON CONFLICT (key) DO UPDATE SET value = EXCLUDED.value;126 INSERT INTO test_config (key, value) VALUES ('http_mock_host', 'localhost')127 ON CONFLICT (key) DO UPDATE SET value = EXCLUDED.value;128129CREATE TABLE130INSERT 0 1131INSERT 0 11322026-11-12 08:56:02 [INFO] Running pgtap test: auth.sql133$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/auth.sql134 schema_name | owner 135-------------+-------136(0 rows)137138 schema_name | table_name | owner | rls_enabled | rls_policies 139-------------+------------+-------+-------------+--------------140(0 rows)141142 schema_name | table_name | role_name | privilege_type | is_grantable 143-------------+------------+-----------+----------------+--------------144(0 rows)145146 table_schema | table_name | index_name | index_owner 147--------------+------------+------------+-------------148(0 rows)149150 schema_name | function_name | owner 151-------------+---------------+-------152(0 rows)153154psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/auth.sql:97: ERROR: relation "auth.schema_migrations" does not exist155LINE 1: select * from auth.schema_migrations;156 ^1572026-11-12 08:56:02 [INFO] Running pgtap test: create_statistics_priv.sql158$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/create_statistics_priv.sql159BEGIN160CREATE SCHEMA161CREATE SCHEMA162psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/create_statistics_priv.sql:15: ERROR: role "postgres" does not exist163psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/create_statistics_priv.sql:17: ERROR: current transaction is aborted, commands ignored until end of transaction block164psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/create_statistics_priv.sql:20: ERROR: current transaction is aborted, commands ignored until end of transaction block165psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/create_statistics_priv.sql:21: ERROR: current transaction is aborted, commands ignored until end of transaction block166psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/create_statistics_priv.sql:24: ERROR: current transaction is aborted, commands ignored until end of transaction block167psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/create_statistics_priv.sql:27: ERROR: current transaction is aborted, commands ignored until end of transaction block168psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/create_statistics_priv.sql:28: ERROR: current transaction is aborted, commands ignored until end of transaction block169psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/create_statistics_priv.sql:29: ERROR: savepoint "no_priv" does not exist170psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/create_statistics_priv.sql:31: ERROR: current transaction is aborted, commands ignored until end of transaction block171ROLLBACK1722026-11-12 08:56:02 [INFO] Running pgtap test: dblink.sql173$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/dblink.sql174SET175DROP EXTENSION176psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/dblink.sql:10: ERROR: role "postgres" does not exist177CREATE TABLE178CREATE EXTENSION179DROP TABLE180RESET181 function_name | grantee | privilege_type 182-----------------------------+----------------+----------------183 dblink_connect_u(text) | supabase_admin | EXECUTE184 dblink_connect_u(text,text) | supabase_admin | EXECUTE185(2 rows)186187psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/dblink.sql:28: ERROR: role "postgres" does not exist188 search_path 189-----------------190 "$user", public191(1 row)192193DROP EXTENSION194CREATE EXTENSION1952026-11-12 08:56:02 [INFO] Running pgtap test: docs-array-test.sql196$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-array-test.sql197CREATE TABLE198INSERT 0 1199 id | textarray 200----+-------------------201 1 | {Harry,Larry,Moe}202(1 row)203204 textarray | array_length 205-----------+--------------206 Harry | 3207(1 row)208209DROP TABLE2102026-11-12 08:56:02 [INFO] Running pgtap test: docs-cascades-deletes.sql211$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-cascades-deletes.sql212CREATE TABLE213CREATE TABLE214CREATE TABLE215INSERT 0 1216INSERT 0 1217INSERT 0 1218INSERT 0 1219 count 220-------221 1222(1 row)223224 count 225-------226 2227(1 row)228229 count 230-------231 1232(1 row)233234psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-cascades-deletes.sql:47: ERROR: update or delete on table "parent" violates foreign key constraint "child_father_fkey" on table "child"235DETAIL: Key (id)=(1) is still referenced from table "child".236 count 237-------238 1239(1 row)240241 count 242-------243 2244(1 row)245246 count 247-------248 1249(1 row)250251psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-cascades-deletes.sql:56: ERROR: duplicate key value violates unique constraint "grandparent_pkey"252DETAIL: Key (id)=(1) already exists.253psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-cascades-deletes.sql:61: ERROR: duplicate key value violates unique constraint "parent_pkey"254DETAIL: Key (id)=(1) already exists.255psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-cascades-deletes.sql:66: ERROR: duplicate key value violates unique constraint "parent_pkey"256DETAIL: Key (id)=(2) already exists.257psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-cascades-deletes.sql:71: ERROR: duplicate key value violates unique constraint "child_pkey"258DETAIL: Key (id)=(1) already exists.259ALTER TABLE260ALTER TABLE261psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-cascades-deletes.sql:80: ERROR: update or delete on table "parent" violates foreign key constraint "child_father_fkey" on table "child"262DETAIL: Key (id)=(1) is still referenced from table "child".263 count 264-------265 1266(1 row)267268 count 269-------270 2271(1 row)272273 count 274-------275 1276(1 row)277278psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-cascades-deletes.sql:89: ERROR: duplicate key value violates unique constraint "grandparent_pkey"279DETAIL: Key (id)=(1) already exists.280psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-cascades-deletes.sql:94: ERROR: duplicate key value violates unique constraint "parent_pkey"281DETAIL: Key (id)=(1) already exists.282psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-cascades-deletes.sql:99: ERROR: duplicate key value violates unique constraint "parent_pkey"283DETAIL: Key (id)=(2) already exists.284psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-cascades-deletes.sql:104: ERROR: duplicate key value violates unique constraint "child_pkey"285DETAIL: Key (id)=(1) already exists.286ALTER TABLE287ALTER TABLE288psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-cascades-deletes.sql:113: ERROR: update or delete on table "parent" violates foreign key constraint "child_father_fkey" on table "child"289DETAIL: Key (id)=(1) is still referenced from table "child".290 count 291-------292 1293(1 row)294295 count 296-------297 2298(1 row)299300 count 301-------302 1303(1 row)304305psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-cascades-deletes.sql:122: ERROR: duplicate key value violates unique constraint "grandparent_pkey"306DETAIL: Key (id)=(1) already exists.307psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-cascades-deletes.sql:127: ERROR: duplicate key value violates unique constraint "parent_pkey"308DETAIL: Key (id)=(1) already exists.309psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-cascades-deletes.sql:132: ERROR: duplicate key value violates unique constraint "parent_pkey"310DETAIL: Key (id)=(2) already exists.311psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-cascades-deletes.sql:137: ERROR: duplicate key value violates unique constraint "child_pkey"312DETAIL: Key (id)=(1) already exists.313ALTER TABLE314UPDATE 1315DELETE 1316 count 317-------318 0319(1 row)320321 count 322-------323 0324(1 row)325326 count 327-------328 0329(1 row)330331CREATE TABLE332CREATE TABLE333INSERT 0 1334INSERT 0 1335DELETE 1336 count 337-------338 0339(1 row)340341 count 342-------343 0344(1 row)345346CREATE TABLE347CREATE TABLE348INSERT 0 1349INSERT 0 1350psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-cascades-deletes.sql:186: ERROR: update or delete on table "test_restrict" violates foreign key constraint "test_restrict_child_parent_id_fkey" on table "test_restrict_child"351DETAIL: Key (id)=(1) is still referenced from table "test_restrict_child".352 count 353-------354 1355(1 row)356357 count 358-------359 1360(1 row)361362CREATE TABLE363CREATE TABLE364INSERT 0 1365INSERT 0 1366DELETE 1367 count 368-------369 0370(1 row)371372 count 373-------374 1375(1 row)376377 parent_id 378-----------379 380(1 row)381382CREATE TABLE383CREATE TABLE384INSERT 0 1385INSERT 0 1386psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-cascades-deletes.sql:225: ERROR: insert or update on table "test_set_default_child" violates foreign key constraint "test_set_default_child_parent_id_fkey"387DETAIL: Key (parent_id)=(999) is not present in table "test_set_default".388 count 389-------390 1391(1 row)392393 count 394-------395 1396(1 row)397398 parent_id 399-----------400 1401(1 row)402403CREATE TABLE404CREATE TABLE405INSERT 0 1406INSERT 0 1407psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-cascades-deletes.sql:245: ERROR: update or delete on table "test_no_action" violates foreign key constraint "test_no_action_child_parent_id_fkey" on table "test_no_action_child"408DETAIL: Key (id)=(1) is still referenced from table "test_no_action_child".409 count 410-------411 1412(1 row)413414 count 415-------416 1417(1 row)418419DROP TABLE420DROP TABLE421DROP TABLE422DROP TABLE423DROP TABLE424DROP TABLE425DROP TABLE426DROP TABLE427DROP TABLE428DROP TABLE429DROP TABLE430DROP TABLE431DROP TABLE4322026-11-12 08:56:02 [INFO] Running pgtap test: docs-connections.sql433$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-connections.sql434 ssl | database | connected_role | application_name | query | state 435-----+----------+----------------+------------------+--------------------------------------------+--------436 f | testing | supabase_admin | psql | select +| active437 | | | | ssl, +| 438 | | | | datname as database, +| 439 | | | | usename as connected_role, +| 440 | | | | application_name, +| 441 | | | | query, +| 442 | | | | state +| 443 | | | | from pg_stat_ssl +| 444 | | | | join pg_stat_activity +| 445 | | | | on pg_stat_ssl.pid = pg_stat_activity.pid; | 446(1 row)4474482026-11-12 08:56:02 [INFO] Running pgtap test: docs-enums.sql449$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-enums.sql450CREATE TYPE451CREATE TABLE452INSERT 0 1453INSERT 0 1454INSERT 0 1455 id | name | current_mood 456----+------+--------------457 2 | Bob | sad458(1 row)459460 id | name | current_mood 461----+-------+--------------462 1 | Alice | happy463(1 row)464465UPDATE 1466 id | name | current_mood 467----+-------+--------------468 1 | Alice | excited469(1 row)470471ALTER TYPE472INSERT 0 1473 enum_range 474----------------------------------475 {happy,sad,excited,calm,content}476(1 row)477478 id | name | current_mood 479----+-------+--------------480 4 | David | content481(1 row)482483CREATE TYPE484CREATE TABLE485INSERT 0 3486 id | order_number | status 487----+--------------+--------488 1 | ORD-001 | active489(1 row)490491UPDATE 1492 id | order_number | status 493----+--------------+----------494 2 | ORD-002 | inactive495(1 row)496497ALTER TYPE498INSERT 0 1499 enum_range 500-------------------------------------501 {active,inactive,pending,cancelled}502(1 row)503504 id | order_number | status 505----+--------------+-----------506 4 | ORD-004 | cancelled507(1 row)508509CREATE TYPE510CREATE TABLE511INSERT 0 3512 id | title | priority 513----+----------------+----------514 3 | Security audit | critical515(1 row)516517UPDATE 1518 id | title | priority 519----+-------------+----------520 2 | Update docs | medium521(1 row)522523ALTER TYPE524INSERT 0 1525 enum_range 526-----------------------------------527 {low,medium,high,critical,urgent}528(1 row)529530 id | title | priority 531----+--------------------+----------532 4 | Server maintenance | urgent533(1 row)534535DROP TABLE536DROP TABLE537DROP TABLE538DROP TYPE539DROP TYPE540DROP TYPE5412026-11-12 08:56:03 [INFO] Running pgtap test: docs-full-text-search.sql542$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-full-text-search.sql543CREATE TABLE544INSERT 0 5545 to_tsvector 546---------------------------547 'egg':2 'green':1 'ham':4548(1 row)549550 to_tsvector 551---------------------------552 'egg':2 'green':1 'ham':4553(1 row)554555 id | title | author | description 556----+-------+--------+-------------557(0 rows)558559 id | title | author | description 560----+-------------------------------------+--------------+-------------------------------------------------561 5 | Harry Potter and the Goblet of Fire | J.K. Rowling | Fourth year of school starts, big drama ensues.562(1 row)563564 id | title | author | description 565----+-------------------------------------+-------------------+-------------------------------------------------566 3 | Tootle | Gertrude Crampton | Little toy train has big dreams.567 5 | Harry Potter and the Goblet of Fire | J.K. Rowling | Fourth year of school starts, big drama ensues.568(2 rows)569570 id | title | author | description 571----+-----------------------+------------------------+---------------------------------------------572 1 | The Poky Little Puppy | Janette Sebring Lowrey | Puppy is slower than other, bigger animals.573 3 | Tootle | Gertrude Crampton | Little toy train has big dreams.574(2 rows)575576CREATE FUNCTION577 id | title | author | description 578----+-----------------------+------------------------+---------------------------------------------579 1 | The Poky Little Puppy | Janette Sebring Lowrey | Puppy is slower than other, bigger animals.580 3 | Tootle | Gertrude Crampton | Little toy train has big dreams.581(2 rows)582583 id | title | author | description 584----+--------+-------------------+----------------------------------585 3 | Tootle | Gertrude Crampton | Little toy train has big dreams.586(1 row)587588 id | title | author | description 589----+-------------------------------------+-------------------+-------------------------------------------------590 3 | Tootle | Gertrude Crampton | Little toy train has big dreams.591 5 | Harry Potter and the Goblet of Fire | J.K. Rowling | Fourth year of school starts, big drama ensues.592(2 rows)593594 title 595-----------------------596 The Poky Little Puppy597(1 row)598599CREATE FUNCTION600 id | title | author | description 601----+-----------------------+------------------------+---------------------------------------------602 1 | The Poky Little Puppy | Janette Sebring Lowrey | Puppy is slower than other, bigger animals.603(1 row)604605 id | title | author | description 606----+-----------------------+------------------------+---------------------------------------------607 1 | The Poky Little Puppy | Janette Sebring Lowrey | Puppy is slower than other, bigger animals.608(1 row)609610ALTER TABLE611CREATE INDEX612 id | fts 613----+-----------------------------------------------------------------------------------------------------------------614 1 | 'anim':7 'bigger':6 'littl':10 'poki':9 'puppi':1,11 'slower':3615 2 | 'eat':2 'peter':8 'rabbit':1,9 'tale':6 'veget':4616 3 | 'big':5 'dream':6 'littl':1 'tootl':7 'toy':2 'train':3617 4 | 'chang':3 'color':9 'eat':7 'egg':12 'food':4,10 'green':11 'ham':14 'prefer':5 'sam':1 'unusu':8618 5 | 'big':6 'drama':7 'ensu':8 'fire':15 'fourth':1 'goblet':13 'harri':9 'potter':10 'school':4 'start':5 'year':2619(5 rows)620621 id | title | author | description | fts 622----+--------+-------------------+----------------------------------+---------------------------------------------------------623 3 | Tootle | Gertrude Crampton | Little toy train has big dreams. | 'big':5 'dream':6 'littl':1 'tootl':7 'toy':2 'train':3624(1 row)625626 id | title | author | description | fts 627----+--------+-------------------+----------------------------------+---------------------------------------------------------628 3 | Tootle | Gertrude Crampton | Little toy train has big dreams. | 'big':5 'dream':6 'littl':1 'tootl':7 'toy':2 'train':3629(1 row)630631 id | title | author | description | fts 632----+-------------------------------------+--------------+-------------------------------------------------+-----------------------------------------------------------------------------------------------------------------633 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':2634(1 row)635636 id | title | author | description | fts 637----+-------------------------------------+--------------+-------------------------------------------------+-----------------------------------------------------------------------------------------------------------------638 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':2639(1 row)640641 id | title | author | description | fts 642----+-------------------------------------+--------------+-------------------------------------------------+-----------------------------------------------------------------------------------------------------------------643 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':2644(1 row)645646 id | title | author | description | fts 647----+--------------------+-----------+--------------------------------------------------------------------+---------------------------------------------------------------------------------------------------648 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':8649(1 row)650651 id | title | author | description | fts 652----+--------+-------------------+----------------------------------+---------------------------------------------------------653 3 | Tootle | Gertrude Crampton | Little toy train has big dreams. | 'big':5 'dream':6 'littl':1 'tootl':7 'toy':2 'train':3654(1 row)655656 id | title | author | description | fts 657----+-------+--------+-------------+-----658(0 rows)659660 id | title | author | description | fts 661----+--------------------------+----------------+------------------------------+---------------------------------------------------662 2 | The Tale of Peter Rabbit | Beatrix Potter | Rabbit eats some vegetables. | 'eat':2 'peter':8 'rabbit':1,9 'tale':6 'veget':4663(1 row)664665 id | title | author | description | fts 666----+-------------------------------------+--------------+-------------------------------------------------+-----------------------------------------------------------------------------------------------------------------667 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':2668(1 row)669670 id | title | author | description | fts 671----+-------+--------+-------------+-----672(0 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)678679DROP FUNCTION680DROP FUNCTION681DROP TABLE6822026-11-12 08:56:03 [INFO] Running pgtap test: docs-functions.sql683$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-functions.sql684CREATE FUNCTION685 hello_world 686-------------687 hello world688(1 row)689690CREATE TABLE691INSERT 0 3692CREATE TABLE693INSERT 0 4694CREATE FUNCTION695 id | name 696----+----------697 1 | Tattoine698(1 row)699700CREATE FUNCTION701psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-functions.sql:64: ERROR: duplicate key value violates unique constraint "planets_pkey"702DETAIL: Key (id)=(1) already exists.703CONTEXT: SQL statement "insert into planets(name)704 values (add_planet.name)705 returning id"706PL/pgSQL function add_planet(text) line 5 at SQL statement707CREATE FUNCTION708 hello_world_definer 709---------------------710 hello world711(1 row)712713REVOKE714psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-functions.sql:79: ERROR: role "anon" does not exist715psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-functions.sql:81: ERROR: role "authenticated" does not exist716REVOKE717psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-functions.sql:84: ERROR: role "anon" does not exist718ALTER DEFAULT PRIVILEGES719psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-functions.sql:87: ERROR: role "anon" does not exist720psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-functions.sql:89: ERROR: role "authenticated" does not exist721CREATE FUNCTION722psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-functions.sql:106: WARNING: logging warning: WARNING MESSAGE723psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-functions.sql:106: ERROR: logging error: ERROR MESSAGE724CONTEXT: PL/pgSQL function logging_example(text,text,text) line 5 at RAISE725CREATE FUNCTION726 error_if_null 727---------------728 not null729(1 row)730731CREATE TABLE732INSERT 0 1733CREATE FUNCTION734 assert_example 735--------------------------------------736 123e4567-e89b-12d3-a456-426614174000737(1 row)738739CREATE FUNCTION740psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-functions.sql:162: ERROR: An error occurred in function <function name>: relation "table_that_does_not_exist" does not exist741CONTEXT: PL/pgSQL function error_example() line 7 at RAISE742CREATE TABLE743INSERT 0 1744CREATE FUNCTION745 advanced_example 746------------------747 42,new val748(1 row)749750DROP FUNCTION751DROP FUNCTION752DROP FUNCTION753DROP FUNCTION754DROP FUNCTION755DROP FUNCTION756DROP FUNCTION757DROP FUNCTION758DROP FUNCTION759DROP TABLE760DROP TABLE761DROP TABLE762DROP TABLE763GRANT764psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-functions.sql:221: ERROR: role "anon" does not exist765ALTER DEFAULT PRIVILEGES766psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-functions.sql:224: ERROR: role "anon" does not exist7672026-11-12 08:56:03 [INFO] Running pgtap test: docs-indexes.sql768$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-indexes.sql769CREATE TABLE770INSERT 0 1771 name 772----------773 John Doe774(1 row)775776CREATE INDEX777CREATE INDEX778CREATE INDEX779REINDEX780REINDEX781DROP TABLE7822026-11-12 08:56:03 [INFO] Running pgtap test: docs-json.sql783$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-json.sql784CREATE TABLE785INSERT 0 5786 title | description | price | low_age | high_age 787-------------------------------------+--------------------------------------------------------------------+-------+---------+----------788 The Poky Little Puppy | Puppy is slower than other, bigger animals. | 5.95 | 3 | 6789 The Tale of Peter Rabbit | Rabbit eats some vegetables. | 4.49 | 2 | 5790 Tootle | Little toy train has big dreams. | 3.99 | 2 | 5791 Green Eggs and Ham | Sam has changing food preferences and eats unusually colored food. | 7.49 | 4 | 8792 Harry Potter and the Goblet of Fire | Fourth year of school starts, big drama ensues. | 24.95 | 10 | 99793(5 rows)794795DROP TABLE7962026-11-12 08:56:03 [INFO] Running pgtap test: docs-partitioning.sql797$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-partitioning.sql798CREATE TABLE799CREATE TABLE800CREATE TABLE801INSERT 0 4802 id | order_date | customer_id | amount 803----+------------+-------------+--------804 1 | 2000-01-15 | 1 | 100805 2 | 2000-01-20 | 2 | 200806 3 | 2000-02-10 | 3 | 150807 4 | 2000-02-25 | 4 | 300808(4 rows)809810 id | order_date | customer_id | amount 811----+------------+-------------+--------812 3 | 2000-02-10 | 3 | 150813 4 | 2000-02-25 | 4 | 300814(2 rows)815816DROP TABLE817CREATE TABLE818CREATE TABLE819CREATE TABLE820INSERT 0 5821 id | name | country 822----+------------+---------823 1 | John Doe | US824 2 | Jane Smith | CANADA825(2 rows)826827 id | name | country 828----+-------------+---------829 3 | Li Wei | CHINA830 4 | Priya Patel | INDIA831 5 | Yuki Tanaka | JAPAN832(3 rows)833834DROP TABLE835CREATE TABLE836CREATE TABLE837CREATE TABLE838INSERT 0 4839 id | name | category | price 840----+--------+-------------+-------841 1 | Laptop | Electronics | 999842 2 | Phone | Electronics | 599843(2 rows)844845 count 846-------847 2848(1 row)849850 count 851-------852 2853(1 row)854855DROP TABLE8562026-11-12 08:56:03 [INFO] Running pgtap test: docs-tables-and-data.sql857$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-tables-and-data.sql858CREATE TABLE859 table_name | column_name | data_type | is_nullable | column_default 860------------+-------------+-----------+-------------+----------------861 movies | id | bigint | NO | 862 movies | name | text | YES | 863 movies | description | text | YES | 864(3 rows)865866DROP TABLE867CREATE TABLE868 column_name | data_type | is_nullable | column_default | is_identity | identity_generation 869-------------+-----------+-------------+----------------+-------------+---------------------870 id | bigint | NO | | YES | ALWAYS871(1 row)872873DROP TABLE874CREATE TABLE875 column_name | data_type | is_nullable | column_default | is_identity | identity_generation 876-------------+-----------+-------------+----------------+-------------+---------------------877 id | bigint | NO | | YES | BY DEFAULT878(1 row)879880DROP TABLE881CREATE TABLE882INSERT 0 2883 id | name | description 884----+-------------------------+--------------------------------------------------------------------------------------------------------------------------------885 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.886 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.887(2 rows)888889DROP TABLE890psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-tables-and-data.sql:57: NOTICE: table "categories" does not exist, skipping891DROP TABLE892CREATE TABLE893CREATE TABLE894ALTER TABLE895 table_name | column_name | foreign_table_name | foreign_column_name 896------------+-------------+--------------------+---------------------897 movies | category_id | categories | id898(1 row)899900psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-tables-and-data.sql:89: NOTICE: table "performances" does not exist, skipping901DROP TABLE902psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-tables-and-data.sql:90: NOTICE: table "actors" does not exist, skipping903DROP TABLE904DROP TABLE905CREATE TABLE906CREATE TABLE907CREATE TABLE908 table_name 909--------------910 actors911 movies912 performances913(3 rows)914915CREATE SCHEMA916 schema_name 917-------------918 private919(1 row)920921psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-tables-and-data.sql:120: NOTICE: table "salaries" does not exist, skipping922DROP TABLE923psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-tables-and-data.sql:121: NOTICE: drop cascades to constraint performances_actor_id_fkey on table performances924DROP TABLE925CREATE TABLE926CREATE TABLE927 table_schema | table_name 928--------------+------------929 private | salaries930(1 row)931932psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-tables-and-data.sql:137: NOTICE: table "grades" does not exist, skipping933DROP TABLE934psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-tables-and-data.sql:138: NOTICE: table "courses" does not exist, skipping935DROP TABLE936psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-tables-and-data.sql:139: NOTICE: table "students" does not exist, skipping937DROP TABLE938psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-tables-and-data.sql:140: NOTICE: view "transcripts" does not exist, skipping939DROP VIEW940CREATE TABLE941CREATE TABLE942CREATE TABLE943INSERT 0 3944INSERT 0 3945INSERT 0 6946CREATE VIEW947psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-tables-and-data.sql:192: ERROR: role "authenticated" does not exist948 name | type | title | code | result 949------------------+---------------+--------------------------+---------+--------950 Anakin Skywalker | graduate | Authentication Theories | AUTH205 | A951 Anakin Skywalker | graduate | Introduction to Postgres | PG101 | A-952 Anakin Skywalker | graduate | Fundamentals of Supabase | SUP412 | B-953 Princess Leia | undergraduate | Introduction to Postgres | PG101 | B+954 Princess Leia | undergraduate | Fundamentals of Supabase | SUP412 | A+955 Yoda | graduate | Authentication Theories | AUTH205 | A956(6 rows)957958psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-tables-and-data.sql:196: NOTICE: materialized view "transcripts_materialized" does not exist, skipping959DROP MATERIALIZED VIEW960SELECT 6961 name | type | title | code | result 962------------------+---------------+--------------------------+---------+--------963 Anakin Skywalker | graduate | Authentication Theories | AUTH205 | A964 Anakin Skywalker | graduate | Introduction to Postgres | PG101 | A-965 Anakin Skywalker | graduate | Fundamentals of Supabase | SUP412 | B-966 Princess Leia | undergraduate | Introduction to Postgres | PG101 | B+967 Princess Leia | undergraduate | Fundamentals of Supabase | SUP412 | A+968 Yoda | graduate | Authentication Theories | AUTH205 | A969(6 rows)970971REFRESH MATERIALIZED VIEW972 count 973-------974 6975(1 row)976977psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-tables-and-data.sql:217: NOTICE: view "secure_transcripts" does not exist, skipping978DROP VIEW979CREATE VIEW980 schemaname | viewname 981------------+--------------------982 public | secure_transcripts983(1 row)984985psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-tables-and-data.sql:228: NOTICE: view "test_view" does not exist, skipping986DROP VIEW987CREATE VIEW988ALTER VIEW989 schemaname | viewname 990------------+-----------991 public | test_view992(1 row)993994DROP MATERIALIZED VIEW995DROP VIEW996DROP VIEW997DROP VIEW998DROP TABLE999DROP TABLE1000DROP TABLE1001DROP TABLE1002DROP TABLE1003DROP TABLE1004DROP TABLE1005DROP TABLE1006DROP SCHEMA10072026-11-12 08:56:03 [INFO] Running pgtap test: docs-triggers.sql1008$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-triggers.sql1009CREATE TABLE1010CREATE TABLE1011CREATE FUNCTION1012CREATE TRIGGER1013INSERT 0 11014INSERT 0 11015UPDATE 11016 id | employee_id | old_salary | new_salary 1017----+-------------+------------+------------1018 1 | 1 | 50000 | 550001019(1 row)10201021CREATE TABLE1022CREATE TABLE1023CREATE FUNCTION1024CREATE TRIGGER1025CREATE TABLE1026CREATE FUNCTION1027CREATE TRIGGER1028INSERT 0 11029INSERT 0 11030INSERT 0 11031INSERT 0 11032DELETE 11033 id | customer_id | action | customer_name 1034----+-------------+--------+---------------1035 1 | 1 | DELETE | Alice Johnson1036(1 row)10371038CREATE TABLE1039CREATE FUNCTION1040CREATE TRIGGER1041INSERT 0 11042 id | trigger_name | operation | table_name 1043----+-------------------------+-----------+------------1044 1 | statement_level_trigger | INSERT | orders1045(1 row)10461047CREATE TABLE1048CREATE FUNCTION1049CREATE TRIGGER1050INSERT 0 11051UPDATE 11052DELETE 11053 id | trigger_name | trigger_when | operation | table_name | table_schema | row_id 1054----+-------------------+--------------+-----------+------------+--------------+--------1055 1 | variables_trigger | AFTER | INSERT | employees | public | 31056 2 | variables_trigger | AFTER | UPDATE | employees | public | 31057 3 | variables_trigger | AFTER | DELETE | employees | public | 31058(3 rows)10591060CREATE TABLE1061CREATE FUNCTION1062CREATE TRIGGER1063INSERT 0 11064INSERT 0 11065 id | employee_name | salary 1066----+---------------+--------1067 1 | Executive | 1500001068(1 row)10691070DROP TRIGGER1071DROP TRIGGER1072DROP TRIGGER1073DROP TRIGGER1074DROP TRIGGER1075DROP TRIGGER1076DROP FUNCTION1077DROP FUNCTION1078DROP FUNCTION1079DROP FUNCTION1080DROP FUNCTION1081DROP FUNCTION1082DROP TABLE1083DROP TABLE1084DROP TABLE1085DROP TABLE1086DROP TABLE1087DROP TABLE1088DROP TABLE1089DROP TABLE10902026-11-12 08:56:03 [INFO] Running pgtap test: docs-webhooks.sql1091$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/docs-webhooks.sql1092CREATE TABLE1093CREATE TABLE1094CREATE FUNCTION1095CREATE TRIGGER1096CREATE TRIGGER1097CREATE TRIGGER1098INSERT 0 11099INSERT 0 11100 id | webhook_name | event_type | table_name | schema_name | ?column? 1101----+----------------+------------+------------+-------------+--------------------------------------------------------------1102 1 | insert_webhook | INSERT | profiles | public | {"id": 1, "name": "John Doe", "email": "john@example.com"}1103 2 | insert_webhook | INSERT | profiles | public | {"id": 2, "name": "Jane Smith", "email": "jane@example.com"}1104(2 rows)11051106UPDATE 11107 id | webhook_name | event_type | table_name | schema_name | ?column? | ?column? 1108----+----------------+------------+------------+-------------+----------------------------------------------------------------+------------------------------------------------------------1109 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"}1110(1 row)11111112DELETE 11113 id | webhook_name | event_type | table_name | schema_name | ?column? 1114----+----------------+------------+------------+-------------+--------------------------------------------------------------1115 4 | delete_webhook | DELETE | profiles | public | {"id": 2, "name": "Jane Smith", "email": "jane@example.com"}1116(1 row)11171118CREATE TABLE1119CREATE TABLE1120CREATE FUNCTION1121CREATE FUNCTION1122CREATE TRIGGER1123INSERT 0 11124INSERT 0 11125 id | webhook_name | url | method | response_status | response_data 1126----+----------------+----------------------------------+--------+-----------------+------------------------------------------------------------------------------------------1127 1 | orders_webhook | https://dummyjson.com/products/1 | GET | 200 | {"id": 1, "price": 9.99, "title": "Essence Mascara Lash Princess", "category": "beauty"}1128 2 | orders_webhook | https://dummyjson.com/products/1 | GET | 200 | {"id": 1, "price": 9.99, "title": "Essence Mascara Lash Princess", "category": "beauty"}1129(2 rows)11301131CREATE TABLE1132INSERT 0 11133CREATE FUNCTION1134CREATE TRIGGER1135INSERT 0 11136 id | webhook_name | url | method | response_status | response_data 1137----+-----------------+----------------------------------+--------+-----------------+-------------------------------------------------------------------------------------------1138 3 | product_webhook | https://dummyjson.com/products/2 | GET | 200 | {"id": 2, "price": 19.99, "title": "Eyeshadow Palette with Mirror", "category": "beauty"}1139(1 row)11401141CREATE FUNCTION1142 webhook_name | event_type | table_name | record_count 1143----------------+------------+------------+--------------1144 delete_webhook | DELETE | profiles | 11145 insert_webhook | INSERT | profiles | 31146 update_webhook | UPDATE | profiles | 11147(3 rows)11481149DROP TRIGGER1150DROP TRIGGER1151DROP TRIGGER1152DROP TRIGGER1153DROP TRIGGER1154DROP FUNCTION1155DROP FUNCTION1156DROP FUNCTION1157DROP FUNCTION1158DROP FUNCTION1159DROP TABLE1160DROP TABLE1161DROP TABLE1162DROP TABLE1163DROP TABLE11642026-11-12 08:56:04 [INFO] Running pgtap test: enable_tracking.sql1165$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/enable_tracking.sql1166psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/enable_tracking.sql:1: ERROR: role "postgres" does not exist1167psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/enable_tracking.sql:2: ERROR: role "postgres" does not exist1168psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/enable_tracking.sql:4: ERROR: role "postgres" does not exist1169psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/enable_tracking.sql:5: ERROR: role "postgres" does not exist11702026-11-12 08:56:04 [INFO] Running pgtap test: event_trigger_search_path.sql1171$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/event_trigger_search_path.sql1172DO11732026-11-12 08:56:04 [INFO] Running pgtap test: intarray_ltree_query.sql1174$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/intarray_ltree_query.sql1175BEGIN1176SET1177CREATE EXTENSION1178CREATE EXTENSION1179 q_and 1180-------1181 f1182(1 row)11831184 q_or 1185------1186 t1187(1 row)11881189 lquery_match 1190--------------1191 t1192(1 row)11931194 ltxtquery_match 1195-----------------1196 t1197(1 row)11981199psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/intarray_ltree_query.sql:38: ERROR: query_int expression is too complex1200psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/intarray_ltree_query.sql:42: ERROR: current transaction is aborted, commands ignored until end of transaction block1201psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/intarray_ltree_query.sql:45: ERROR: current transaction is aborted, commands ignored until end of transaction block1202psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/intarray_ltree_query.sql:47: ERROR: current transaction is aborted, commands ignored until end of transaction block1203ROLLBACK12042026-11-12 08:56:04 [INFO] Running pgtap test: ltree_label_overflow.sql1205$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/ltree_label_overflow.sql1206BEGIN1207SET1208CREATE EXTENSION1209 na | nb | a_gt_b | a_lt_b | b_lt_a | a_eq_a 1210-------+----+--------+--------+--------+--------1211 20001 | 1 | t | f | t | t1212(1 row)12131214ROLLBACK12152026-11-12 08:56:04 [INFO] Running pgtap test: multirange_create_priv.sql1216$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/multirange_create_priv.sql1217BEGIN1218CREATE SCHEMA1219CREATE SCHEMA1220psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/multirange_create_priv.sql:16: ERROR: role "postgres" does not exist1221psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/multirange_create_priv.sql:18: ERROR: current transaction is aborted, commands ignored until end of transaction block1222psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/multirange_create_priv.sql:24: ERROR: current transaction is aborted, commands ignored until end of transaction block1223psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/multirange_create_priv.sql:28: ERROR: current transaction is aborted, commands ignored until end of transaction block1224psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/multirange_create_priv.sql:32: ERROR: current transaction is aborted, commands ignored until end of transaction block1225psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/multirange_create_priv.sql:33: ERROR: savepoint "no_priv" does not exist1226psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/multirange_create_priv.sql:35: ERROR: current transaction is aborted, commands ignored until end of transaction block1227ROLLBACK12282026-11-12 08:56:04 [INFO] Running pgtap test: operator_breaking_change.sql1229$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/operator_breaking_change.sql1230BEGIN1231SET1232CREATE EXTENSION1233CREATE SCHEMA1234psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/operator_breaking_change.sql:22: ERROR: role "postgres" does not exist1235psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/operator_breaking_change.sql:26: ERROR: current transaction is aborted, commands ignored until end of transaction block1236psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/operator_breaking_change.sql:29: ERROR: current transaction is aborted, commands ignored until end of transaction block1237psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/operator_breaking_change.sql:32: ERROR: current transaction is aborted, commands ignored until end of transaction block1238psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/operator_breaking_change.sql:37: ERROR: current transaction is aborted, commands ignored until end of transaction block1239psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/operator_breaking_change.sql:38: ERROR: savepoint "before_restrict" does not exist1240psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/operator_breaking_change.sql:41: ERROR: current transaction is aborted, commands ignored until end of transaction block1241psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/operator_breaking_change.sql:46: ERROR: current transaction is aborted, commands ignored until end of transaction block1242psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/operator_breaking_change.sql:47: ERROR: savepoint "before_join" does not exist1243psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/operator_breaking_change.sql:55: ERROR: current transaction is aborted, commands ignored until end of transaction block1244psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/operator_breaking_change.sql:56: ERROR: current transaction is aborted, commands ignored until end of transaction block1245psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/operator_breaking_change.sql:58: ERROR: current transaction is aborted, commands ignored until end of transaction block1246psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/operator_breaking_change.sql:60: ERROR: current transaction is aborted, commands ignored until end of transaction block1247ROLLBACK12482026-11-12 08:56:04 [INFO] Running pgtap test: pg-safeupdate.sql1249$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pg-safeupdate.sql1250LOAD1251SET1252CREATE SCHEMA1253CREATE TABLE1254psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pg-safeupdate.sql:13: ERROR: UPDATE requires a WHERE clause1255psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pg-safeupdate.sql:15: NOTICE: drop cascades to table v.foo1256DROP SCHEMA12572026-11-12 08:56:04 [INFO] Running pgtap test: pg_graphql.sql1258$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pg_graphql.sql1259BEGIN1260COMMENT1261CREATE TABLE1262CREATE TABLE1263COMMENT1264CREATE FUNCTION1265 resolve 1266----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------1267 {"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}}}1268(1 row)12691270 resolve 1271--------------------------------------------------------------------------------------1272 {"data": {"insertIntoBlogCollection": {"records": [{"id": 1, "owner": {"id": 1}}]}}}1273(1 row)12741275 resolve 1276------------------------------------------------------------------------------------------------------------------------1277 {"data": {"insertIntoAccountCollection": {"records": [{"email": "baz@baz.com", "status": null}], "affectedCount": 1}}}1278(1 row)12791280 resolve 1281--------------------------------------------------------------------------------------------------------------------------------1282 {"data": {"xyz": {"records": [{"id": 4, "email": "foo@bar.com"}, {"id": 5, "email": "other@email.com"}], "affectedCount": 2}}}1283(1 row)12841285 resolve 1286------------------------------------------------------------------------------------------------1287 {"data": {"xyz": {"records": [{"email": "1@email.com", "status": null}], "affectedCount": 1}}}1288(1 row)12891290 resolve 1291------------------------------------------------------------------------------------------------1292 {"data": {"xyz": {"records": [{"email": "x@y.com", "status": "active"}], "affectedCount": 1}}}1293(1 row)12941295 resolve 1296-----------------------------------------------------------------------------------------------------------------1297 {"data": {"insertIntoAccountCollection": {"records": [{"id": 8, "email": "bar@foo.com"}], "affectedCount": 1}}}1298(1 row)12991300 resolve 1301-----------------------------------------------------------------------------------------------------------------1302 {"data": {"insertIntoAccountCollection": {"records": [{"id": 9, "email": "bar@foo.com"}], "affectedCount": 1}}}1303(1 row)13041305 resolve 1306--------------------------------------------------------------1307 {"data": {"insertIntoBlogCollection": {"affectedCount": 1}}}1308(1 row)13091310 resolve 1311---------------------------------------------------------------------------------------------------------------------1312 {"data": null, "errors": [{"message": "Input for type AccountInsertInput contains extra keys [\"doesNotExist\"]"}]}1313(1 row)13141315 resolve 1316-----------------------------------------------------------------------------------1317 {"data": null, "errors": [{"message": "Invalid input for BlogInsertInput type"}]}1318(1 row)13191320 resolve 1321---------------------------------------------------------------------------1322 {"data": null, "errors": [{"message": "Invalid input for NonNull type"}]}1323(1 row)13241325 resolve 1326--------------------------------------------------------------------------------------------1327 {"data": null, "errors": [{"message": "At least one record must be provided to objects"}]}1328(1 row)13291330ROLLBACK13312026-11-12 08:56:04 [INFO] Running pgtap test: pg_net.sql1332$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pg_net.sql1333 request_id 1334------------1335 11336(1 row)133713382026-11-12 08:56:04 [INFO] Running pgtap test: pg_plan_filter.sql1339$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pg_plan_filter.sql1340BEGIN1341psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pg_plan_filter.sql:2: ERROR: could not access file "plan_filter": No such file or directory1342psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pg_plan_filter.sql:4: ERROR: current transaction is aborted, commands ignored until end of transaction block1343psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pg_plan_filter.sql:10: ERROR: current transaction is aborted, commands ignored until end of transaction block1344psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pg_plan_filter.sql:14: ERROR: current transaction is aborted, commands ignored until end of transaction block1345psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pg_plan_filter.sql:16: ERROR: current transaction is aborted, commands ignored until end of transaction block1346psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pg_plan_filter.sql:18: ERROR: current transaction is aborted, commands ignored until end of transaction block1347ROLLBACK13482026-11-12 08:56:04 [INFO] Running pgtap test: pgaudit.sql1349$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pgaudit.sql1350SET1351SET1352SET1353CREATE SCHEMA1354CREATE TABLE1355INSERT 0 11356 id | name | password | description 1357----+-------+----------+-------------1358 1 | user1 | HASH1 | blah, blah1359(1 row)13601361psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pgaudit.sql:23: NOTICE: drop cascades to table v.account1362DROP SCHEMA13632026-11-12 08:56:04 [INFO] Running pgtap test: pgbouncer.sql1364$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pgbouncer.sql1365 schema_name | owner 1366-------------+-------1367(0 rows)13681369 schema_name | function_name | owner 1370-------------+---------------+-------1371(0 rows)13721373 schema | object_name | grantee | privilege_type 1374--------+-------------+---------+----------------1375(0 rows)13761377CREATE ROLE1378CREATE ROLE1379UPDATE 11380Null display is "<null>".1381psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pgbouncer.sql:62: ERROR: schema "pgbouncer" does not exist1382LINE 1: select * from pgbouncer.get_auth('test_expired_user_password...1383 ^1384psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pgbouncer.sql:64: ERROR: schema "pgbouncer" does not exist1385LINE 1: select pgbouncer.get_auth('test_valid_user_password');1386 ^1387psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pgbouncer.sql:67: ERROR: role "pgbouncer" does not exist1388psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pgbouncer.sql:68: ERROR: schema "pgbouncer" does not exist1389LINE 1: select pgbouncer.get_auth('test_valid_user_password');1390 ^1391RESET1392psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pgbouncer.sql:72: ERROR: role "postgres" does not exist1393psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pgbouncer.sql:73: ERROR: schema "pgbouncer" does not exist1394LINE 1: select pgbouncer.get_auth('test_valid_user_password');1395 ^1396RESET1397DROP ROLE1398DROP ROLE13992026-11-12 08:56:04 [INFO] Running pgtap test: pgcrypto_cipher_matrix.sql1400$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pgcrypto_cipher_matrix.sql1401BEGIN1402CREATE EXTENSION1403SAVEPOINT1404psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pgcrypto_cipher_matrix.sql:26: ERROR: encrypt error: Cipher cannot be initialized1405ROLLBACK1406SAVEPOINT1407psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pgcrypto_cipher_matrix.sql:30: ERROR: encrypt error: Cipher cannot be initialized1408ROLLBACK1409SAVEPOINT1410psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pgcrypto_cipher_matrix.sql:34: ERROR: encrypt error: Cipher cannot be initialized1411ROLLBACK1412 aes128_rt 1413-----------1414 secret1415(1 row)14161417 aes192_rt 1418-----------1419 secret1420(1 row)14211422 aes256_rt 1423-----------1424 secret1425(1 row)14261427 des3_rt 1428---------1429 secret1430(1 row)14311432SAVEPOINT1433psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pgcrypto_cipher_matrix.sql:45: ERROR: Wrong key or corrupt data1434ROLLBACK1435SAVEPOINT1436psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pgcrypto_cipher_matrix.sql:49: ERROR: Wrong key or corrupt data1437ROLLBACK1438 post_error_ok 1439---------------1440 still-here1441(1 row)14421443ROLLBACK14442026-11-12 08:56:04 [INFO] Running pgtap test: pgsodium.sql1445$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/pgsodium.sql1446 status 1447--------1448 valid1449(1 row)145014512026-11-12 08:56:04 [INFO] Running pgtap test: realtime.sql1452$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/realtime.sql1453 publication_name | owner | puballtables | pubinsert | pubupdate | pubdelete | pubtruncate 1454------------------+-------+--------------+-----------+-----------+-----------+-------------1455(0 rows)145614572026-11-12 08:56:05 [INFO] Running pgtap test: replica_identity_upsert.sql1458$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/replica_identity_upsert.sql1459BEGIN1460CREATE TABLE1461CREATE PUBLICATION1462INSERT 0 11463SAVEPOINT1464psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/replica_identity_upsert.sql:17: ERROR: cannot update table "ri" because it does not have a replica identity and publishes updates1465HINT: To enable updating the table, set REPLICA IDENTITY using ALTER TABLE.1466ROLLBACK1467SAVEPOINT1468psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/replica_identity_upsert.sql:22: ERROR: cannot update table "ri" because it does not have a replica identity and publishes updates1469HINT: To enable updating the table, set REPLICA IDENTITY using ALTER TABLE.1470ROLLBACK1471ALTER TABLE1472INSERT 0 11473MERGE 11474 v 1475----1476 301477(1 row)14781479ROLLBACK14802026-11-12 08:56:05 [INFO] Running pgtap test: storage.sql1481$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/storage.sql1482 schema_name | owner 1483-------------+-------1484(0 rows)14851486 schema_name | table_name | owner | rls_enabled | rls_policies 1487-------------+------------+-------+-------------+--------------1488(0 rows)14891490 schema_name | table_name | role_name | privilege_type | is_grantable 1491-------------+------------+-----------+----------------+--------------1492(0 rows)14931494 table_schema | table_name | index_name | index_owner 1495--------------+------------+------------+-------------1496(0 rows)14971498 schema_name | function_name | owner 1499-------------+---------------+-------1500(0 rows)15011502CREATE ROLE1503psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/storage.sql:98: ERROR: role "postgres" does not exist1504psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/storage.sql:100: ERROR: role "postgres" does not exist1505psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/storage.sql:101: ERROR: schema "storage" does not exist1506psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/storage.sql:102: ERROR: schema "storage" does not exist1507psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/storage.sql:104: ERROR: role "postgres" does not exist1508DROP OWNED1509DROP ROLE1510RESET15112026-11-12 08:56:05 [INFO] Running pgtap test: supautils_reserved_memberships.sql1512$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_memberships.sql1513psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_memberships.sql:1: ERROR: role "postgres" does not exist1514psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_memberships.sql:3: ERROR: role "postgres" does not exist1515psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_memberships.sql:4: ERROR: role "postgres" does not exist1516psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_memberships.sql:5: ERROR: role "postgres" does not exist1517psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_memberships.sql:6: ERROR: role "postgres" does not exist1518psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_memberships.sql:7: ERROR: role "postgres" does not exist1519psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_memberships.sql:8: ERROR: role "postgres" does not exist1520psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_memberships.sql:9: ERROR: role "postgres" does not exist1521psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_memberships.sql:10: ERROR: role "postgres" does not exist1522psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_memberships.sql:11: ERROR: role "postgres" does not exist1523psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_memberships.sql:12: ERROR: role "postgres" does not exist1524psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_memberships.sql:13: ERROR: role "postgres" does not exist1525psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_memberships.sql:14: ERROR: role "postgres" does not exist1526psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_memberships.sql:15: ERROR: role "postgres" does not exist1527psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_memberships.sql:16: ERROR: role "postgres" does not exist1528RESET15292026-11-12 08:56:05 [INFO] Running pgtap test: supautils_reserved_roles.sql1530$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_roles.sql1531BEGIN1532psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_roles.sql:5: ERROR: role "postgres" does not exist1533psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_roles.sql:8: ERROR: current transaction is aborted, commands ignored until end of transaction block1534psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_roles.sql:9: ERROR: current transaction is aborted, commands ignored until end of transaction block1535psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_roles.sql:10: ERROR: savepoint "before_drop" does not exist1536psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_roles.sql:12: ERROR: current transaction is aborted, commands ignored until end of transaction block1537psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/supautils_reserved_roles.sql:14: ERROR: current transaction is aborted, commands ignored until end of transaction block1538ROLLBACK15392026-11-12 08:56:05 [INFO] Running pgtap test: vault.sql1540$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/vault.sql1541 schema | object_name | grantee | privilege_type 1542--------+---------------------------+----------------+----------------1543 vault | _crypto_aead_det_decrypt | supabase_admin | EXECUTE1544 vault | _crypto_aead_det_encrypt | supabase_admin | EXECUTE1545 vault | _crypto_aead_det_noncegen | supabase_admin | EXECUTE1546 vault | create_secret | supabase_admin | EXECUTE1547 vault | update_secret | supabase_admin | EXECUTE1548(5 rows)15491550 schema | table | index_name | index_owner | index_type 1551--------+---------+------------------+----------------+------------1552 vault | secrets | secrets_name_idx | supabase_admin | Unique1553 vault | secrets | secrets_pkey | supabase_admin | Unique1554(2 rows)15551556 search_path 1557-----------------1558 "$user", public1559(1 row)15601561SET1562DROP EXTENSION1563CREATE TABLE1564psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/vault.sql:65: ERROR: role "postgres" does not exist1565LINE 1: ...g_extension values (0, 'supabase_vault', '0.2.8', 'postgres'...1566 ^1567CREATE EXTENSION1568DROP TABLE1569RESET1570 function_name | grantee | privilege_type 1571---------------+---------+----------------1572(0 rows)15731574psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/vault.sql:83: ERROR: role "postgres" does not exist1575 search_path 1576-----------------1577 "$user", public1578(1 row)157915802026-11-12 08:56:05 [INFO] Running pgtap test: wal2json.sql1581$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/wal2json.sql1582CREATE SCHEMA1583CREATE TABLE1584psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/wal2json.sql:10: ERROR: could not access file "wal2json": No such file or directory1585INSERT 0 11586psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/wal2json.sql:28: ERROR: replication slot "reg_test" does not exist1587psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/wal2json.sql:31: ERROR: replication slot "reg_test" does not exist1588psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/wal2json.sql:33: NOTICE: drop cascades to table v.foo1589DROP SCHEMA15902026-11-12 08:56:05 [INFO] Running pgtap test: z_17_intarray_ltree_query.sql1591$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_intarray_ltree_query.sql1592BEGIN1593SET1594CREATE EXTENSION1595psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_intarray_ltree_query.sql:7: ERROR: lquery level is too large1596DETAIL: Total size of level exceeds the maximum allowed (65535 bytes).1597psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_intarray_ltree_query.sql:9: ERROR: current transaction is aborted, commands ignored until end of transaction block1598ROLLBACK15992026-11-12 08:56:05 [INFO] Running pgtap test: z_17_supabase_monitor_admin.sql1600$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_supabase_monitor_admin.sql1601 rolsuper | rolinherit | rolcreaterole | rolcreatedb | rolcanlogin | rolreplication | rolbypassrls | rolconnlimit | no_password 1602----------+------------+---------------+-------------+-------------+----------------+--------------+--------------+-------------1603(0 rows)16041605 setting 1606---------1607(0 rows)16081609psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_supabase_monitor_admin.sql:16: ERROR: role "supabase_monitor_admin" does not exist1610LINE 2: from pg_auth_members where member = 'supabase_monitor_admin'...1611 ^1612psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_supabase_monitor_admin.sql:19: ERROR: role "supabase_monitor_admin" does not exist1613LINE 1: ...lect count(*) from pg_auth_members where roleid = 'supabase_...1614 ^1615psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_supabase_monitor_admin.sql:26: ERROR: role "supabase_monitor_admin" does not exist1616LINE 3: and refobjid = 'supabase_monitor_admin'::regrole1617 ^1618psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_supabase_monitor_admin.sql:29: ERROR: role "supabase_monitor_admin" does not exist1619CREATE TABLE1620INSERT 0 21621ALTER TABLE1622ALTER TABLE1623psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_supabase_monitor_admin.sql:39: ERROR: role "postgres" does not exist1624psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_supabase_monitor_admin.sql:40: ERROR: role "supabase_monitor_admin" does not exist1625 count 1626-------1627 21628(1 row)16291630INSERT 0 11631SET1632 count 1633-------1634 01635(1 row)16361637RESET1638DROP TABLE1639BEGIN1640psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_supabase_monitor_admin.sql:52: ERROR: role "postgres" does not exist1641psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_supabase_monitor_admin.sql:53: ERROR: current transaction is aborted, commands ignored until end of transaction block1642psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_supabase_monitor_admin.sql:54: ERROR: current transaction is aborted, commands ignored until end of transaction block1643psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_supabase_monitor_admin.sql:55: ERROR: savepoint "s" does not exist1644psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_supabase_monitor_admin.sql:56: ERROR: current transaction is aborted, commands ignored until end of transaction block1645psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_supabase_monitor_admin.sql:57: ERROR: savepoint "s" does not exist1646psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_supabase_monitor_admin.sql:58: ERROR: current transaction is aborted, commands ignored until end of transaction block1647psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_supabase_monitor_admin.sql:59: ERROR: savepoint "s" does not exist1648psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_supabase_monitor_admin.sql:60: ERROR: current transaction is aborted, commands ignored until end of transaction block1649psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_supabase_monitor_admin.sql:61: ERROR: savepoint "s" does not exist1650psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_supabase_monitor_admin.sql:62: ERROR: current transaction is aborted, commands ignored until end of transaction block1651psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_supabase_monitor_admin.sql:63: ERROR: savepoint "s" does not exist1652psql:/nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_supabase_monitor_admin.sql:64: ERROR: current transaction is aborted, commands ignored until end of transaction block1653ROLLBACK16542026-11-12 08:56:05 [INFO] Running pgtap test: z_17_wal_summarize.sql1655$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/ms7ip94l24bna36m00yzm09c352qnv8g-sql/z_17_wal_summarize.sql1656 summarize_wal_default_ok 1657--------------------------1658 f1659(1 row)16601661$ pg_ctl -D /build/tmp.46TA9YzZm8 stop1662waiting for server to shut down.... done1663server stopped16642026-11-12 08:56:05 [INFO] Starting PostgreSQL server for pg_regress tests1665$ /nix/store/rs68rvm264lkb78g8vc27m8p4nz2m9nx-start-postgres-server-test/bin/start-postgres-server 17 --daemonize1666Starting server for PSQL 171667/nix/store/rs68rvm264lkb78g8vc27m8p4nz2m9nx-start-postgres-server-test/bin/start-postgres-server: line 191: warning: setlocale: LC_ALL: cannot change locale (en_US.UTF-8): No such file or directory1668KEY_FILE: /build/tmp.S6954zssuf/pgsodium.key1669KEY_FILE contents:1670cat: /build/tmp.S6954zssuf/pgsodium.key: No such file or directory1671PGSODIUM_GETKEY_SCRIPT: /nix/store/1pwkb9dqp63rk9xi9f2vr1s4vd57z0yr-pgsodium-getkey/bin/pgsodium-getkey1672NOTE: using port 5541 for server1673NOTE: using temporary directory /build/tmp.S6954zssuf for data1674NOTE: you are free to re-use this data directory at will1675The files belonging to this database system will be owned by user "nixbld".1676This user must also own the server process.16771678The database cluster will be initialized with locale "en_US.UTF-8".1679The default database encoding has accordingly been set to "UTF8".1680The default text search configuration will be set to "english".16811682Data page checksums are disabled.16831684fixing permissions on existing directory /build/tmp.S6954zssuf ... ok1685creating subdirectories ... ok1686selecting dynamic shared memory implementation ... posix1687selecting default "max_connections" ... 1001688selecting default "shared_buffers" ... 128MB1689selecting default time zone ... UTC1690creating configuration files ... ok1691running bootstrap script ... ok1692performing post-bootstrap initialization ... ok1693syncing data to disk ... ok16941695initdb: warning: enabling "trust" authentication for local connections1696initdb: 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.16971698Success. You can now start the database server using:16991700 /nix/store/9cgb3iwg25krw3rchysinlgn6bvh36kc-postgresql-and-plugins-17.11/bin/pg_ctl -D /build/tmp.S6954zssuf -l logfile start17011702NOTE: patching postgresql.conf files1703non-macos pg 17 conf1704waiting for server to start.... done1705server started1706pg_ctl: server is running (PID: 1236)1707/nix/store/9cgb3iwg25krw3rchysinlgn6bvh36kc-postgresql-and-plugins-17.11/bin/postgres "-D" "/build/tmp.S6954zssuf" "--config-file=/build/tmp.S6954zssuf/postgresql.conf" "-p" "5541" "-k" "/build/tmp.S6954zssuf/tmp"1708PostgreSQL is ready1709NOTICE: empty string is not a valid password, clearing password1710CREATE ROLE1711ALTER DATABASE1712Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/init-scripts/00000000000000-initial-schema.sql1713CREATE PUBLICATION1714ALTER ROLE1715CREATE ROLE1716CREATE ROLE1717GRANT ROLE1718GRANT1719CREATE ROLE1720GRANT ROLE1721CREATE ROLE1722GRANT ROLE1723ALTER ROLE1724ALTER ROLE1725ALTER ROLE1726ALTER ROLE1727ALTER ROLE1728ALTER ROLE1729CREATE SCHEMA1730CREATE EXTENSION1731CREATE EXTENSION1732CREATE ROLE1733CREATE ROLE1734CREATE ROLE1735CREATE ROLE1736GRANT ROLE1737GRANT ROLE1738GRANT ROLE1739GRANT ROLE1740GRANT1741ALTER DEFAULT PRIVILEGES1742ALTER DEFAULT PRIVILEGES1743ALTER DEFAULT PRIVILEGES1744GRANT1745ALTER ROLE1746ALTER DEFAULT PRIVILEGES1747ALTER DEFAULT PRIVILEGES1748ALTER DEFAULT PRIVILEGES1749ALTER ROLE1750ALTER ROLE1751Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/init-scripts/00000000000001-auth-schema.sql1752CREATE SCHEMA1753CREATE TABLE1754CREATE INDEX1755CREATE INDEX1756COMMENT1757CREATE TABLE1758CREATE INDEX1759CREATE INDEX1760CREATE INDEX1761COMMENT1762CREATE TABLE1763COMMENT1764CREATE TABLE1765CREATE INDEX1766COMMENT1767CREATE TABLE1768COMMENT1769INSERT 0 71770CREATE FUNCTION1771CREATE FUNCTION1772CREATE FUNCTION1773GRANT1774CREATE ROLE1775GRANT1776GRANT1777GRANT1778ALTER ROLE1779ALTER TABLE1780ALTER TABLE1781ALTER TABLE1782ALTER TABLE1783ALTER TABLE1784Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/init-scripts/00000000000002-storage-schema.sql1785CREATE SCHEMA1786CREATE ROLE1787ALTER ROLE1788GRANT1789DO1790Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/init-scripts/00000000000003-post-setup.sql1791ALTER ROLE1792ALTER ROLE1793CREATE FUNCTION1794CREATE EVENT TRIGGER1795COMMENT1796CREATE FUNCTION1797COMMENT1798DO1799CREATE ROLE1800GRANT1801GRANT1802GRANT1803GRANT1804GRANT1805GRANT1806GRANT1807GRANT1808GRANT1809DO1810NOTICE: empty string is not a valid password, clearing password1811ALTER ROLE1812CREATE ROLE1813REVOKE1814CREATE SCHEMA1815CREATE FUNCTION1816REVOKE1817GRANT1818psql:/nix/store/0s4wf39csywl7iy2bchhiaqzcinrk17w-stat-extension:1: NOTICE: schema "extensions" already exists, skipping1819CREATE SCHEMA1820CREATE EXTENSION1821Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/10000000000000_demote-postgres.sql1822GRANT1823GRANT1824GRANT1825GRANT1826GRANT1827GRANT1828GRANT1829GRANT1830GRANT1831DO1832ALTER ROLE1833Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20211115181400_update-auth-permissions.sql1834GRANT1835GRANT1836GRANT1837ALTER TABLE1838ALTER TABLE1839ALTER TABLE1840ALTER TABLE1841ALTER TABLE1842GRANT1843GRANT1844GRANT1845GRANT1846ALTER DEFAULT PRIVILEGES1847ALTER DEFAULT PRIVILEGES1848ALTER DEFAULT PRIVILEGES1849Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20211118015519_create-realtime-schema.sql1850CREATE SCHEMA1851Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20211122051245_update-realtime-permissions.sql1852GRANT1853GRANT1854GRANT1855GRANT1856Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20211124212715_update-auth-owner.sql1857DO1858DO1859DO1860Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20211130151719_update-realtime-permissions.sql1861ALTER DEFAULT PRIVILEGES1862ALTER DEFAULT PRIVILEGES1863ALTER DEFAULT PRIVILEGES1864Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220118070449_enable-safeupdate-postgrest.sql1865ALTER ROLE1866Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220126121436_finer-postgrest-triggers.sql1867psql:/nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220126121436_finer-postgrest-triggers.sql:3: NOTICE: event trigger "api_restart" does not exist, skipping1868DROP EVENT TRIGGER1869psql:/nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220126121436_finer-postgrest-triggers.sql:4: NOTICE: function extensions.notify_api_restart() does not exist, skipping1870DROP FUNCTION1871CREATE FUNCTION1872CREATE FUNCTION1873psql:/nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220126121436_finer-postgrest-triggers.sql:59: NOTICE: event trigger "pgrst_ddl_watch" does not exist, skipping1874DROP EVENT TRIGGER1875CREATE EVENT TRIGGER1876psql:/nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220126121436_finer-postgrest-triggers.sql:64: NOTICE: event trigger "pgrst_drop_watch" does not exist, skipping1877DROP EVENT TRIGGER1878CREATE EVENT TRIGGER1879Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220224211803_fix-postgrest-supautils.sql1880DO1881Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220317095840_pg_graphql.sql1882CREATE SCHEMA1883psql:/nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220317095840_pg_graphql.sql:5: NOTICE: function graphql_public.graphql(text,text,jsonb) does not exist, skipping1884DROP FUNCTION1885CREATE FUNCTION1886GRANT1887ALTER DEFAULT PRIVILEGES1888ALTER DEFAULT PRIVILEGES1889ALTER DEFAULT PRIVILEGES1890ALTER DEFAULT PRIVILEGES1891ALTER DEFAULT PRIVILEGES1892ALTER DEFAULT PRIVILEGES1893CREATE FUNCTION1894psql:/nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220317095840_pg_graphql.sql:90: NOTICE: event trigger "issue_pg_graphql_access" does not exist, skipping1895DROP EVENT TRIGGER1896CREATE EVENT TRIGGER1897COMMENT1898CREATE FUNCTION1899psql:/nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220317095840_pg_graphql.sql:143: NOTICE: event trigger "issue_graphql_placeholder" does not exist, skipping1900DROP EVENT TRIGGER1901CREATE EVENT TRIGGER1902COMMENT1903Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220321174452_fix-postgrest-alter-type-event-trigger.sql1904psql:/nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220321174452_fix-postgrest-alter-type-event-trigger.sql:3: NOTICE: event trigger "api_restart" does not exist, skipping1905DROP EVENT TRIGGER1906psql:/nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220321174452_fix-postgrest-alter-type-event-trigger.sql:4: NOTICE: function extensions.notify_api_restart() does not exist, skipping1907DROP FUNCTION1908CREATE FUNCTION1909CREATE FUNCTION1910DROP EVENT TRIGGER1911CREATE EVENT TRIGGER1912DROP EVENT TRIGGER1913CREATE EVENT TRIGGER1914Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220322085208_gotrue-session-limit.sql1915ALTER ROLE1916Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220404205710_pg_graphql-on-by-default.sql1917CREATE FUNCTION1918CREATE FUNCTION1919CREATE FUNCTION1920psql:/nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220404205710_pg_graphql-on-by-default.sql:142: NOTICE: extension "pg_graphql" does not exist, skipping1921DROP EXTENSION1922DO1923Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220609081115_grant-supabase-auth-admin-and-supabase-storage-admin-to-postgres.sql1924GRANT ROLE1925Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220613123923_pg_graphql-pg-dump-perms.sql1926CREATE FUNCTION1927DROP EXTENSION1928DO1929Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220713082019_pg_cron-pg_net-temp-perms-fix.sql1930DO1931DO1932Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20221028101028_set_authenticator_timeout.sql1933ALTER ROLE1934Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20221103090837_revoke_admin.sql1935REVOKE ROLE1936Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20221207154255_create_pgsodium_and_vault.sql1937DO1938Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20230201083204_grant_auth_roles_to_postgres.sql1939GRANT ROLE1940Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20230224042246_grant_extensions_perms_for_postgres.sql1941GRANT1942GRANT1943GRANT1944ALTER DEFAULT PRIVILEGES1945ALTER DEFAULT PRIVILEGES1946ALTER DEFAULT PRIVILEGES1947Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20230306081037_grant_pg_monitor_to_postgres.sql1948GRANT ROLE1949Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20230327032006_grant_auth_roles_to_supabase_storage_admin.sql1950GRANT ROLE1951Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20230529180330_alter_api_roles_for_inherit.sql1952ALTER ROLE1953ALTER ROLE1954ALTER ROLE1955DO1956Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20231013070755_grant_authenticator_to_supabase_storage_admin.sql1957GRANT ROLE1958REVOKE ROLE1959Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20231017062225_grant_pg_graphql_permissions_for_custom_roles.sql1960CREATE FUNCTION1961DROP EXTENSION1962DO1963Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20231020085357_revoke_writes_on_cron_job_from_postgres.sql1964DO1965CREATE FUNCTION1966DROP EVENT TRIGGER1967ALTER FUNCTION1968CREATE EVENT TRIGGER1969Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20231130133139_set_lock_timeout_to_authenticator_role.sql1970ALTER ROLE1971Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20240124080435_alter_lo_export_lo_import_owner.sql1972ALTER FUNCTION1973ALTER FUNCTION1974ALTER FUNCTION1975Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20240606060239_grant_predefined_roles_to_postgres.sql1976GRANT ROLE1977Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20241031003909_create_orioledb.sql1978DO1979Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20241215003910_backfill_pgmq_metadata.sql1980DO1981DO1982Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20250205060043_disable_log_statement_on_internal_roles.sql1983ALTER ROLE1984ALTER ROLE1985ALTER ROLE1986Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20250205144616_move_orioledb_to_extensions_schema.sql1987DO1988Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20250218031949_pgsodium_mask_role.sql1989DO1990Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20250220051611_pg_net_perms_fix.sql1991CREATE FUNCTION1992DO1993Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20250312095419_pgbouncer_ownership.sql1994ALTER FUNCTION1995GRANT1996Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20250402065937_alter_internal_event_triggers_owner_to_supabase_admin.sql1997DROP EVENT TRIGGER1998ALTER FUNCTION1999CREATE EVENT TRIGGER2000Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20250402093753_grant_subscription_to_postgres_16_and_above.sql2001DO2002Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20250417190610_update_pgbouncer_get_auth.sql2003CREATE FUNCTION2004GRANT2005Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20250421084701_revoke_admin_roles_from_postgres.sql2006REVOKE ROLE2007DO2008DO2009REVOKE ROLE2010REVOKE2011DO2012Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20250605172253_grant_with_admin_to_postgres_16_and_above.sql2013DO2014Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20250623125453_tmp_grant_storage_tables_to_postgres_with_grant_option.sql2015DO2016Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20250709135250_grant_storage_schema_to_postgres_with_grant_option.sql2017DO2018Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20250710151649_supabase_read_only_user_default_transaction_read_only.sql2019ALTER ROLE2020Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20251001204436_predefined_role_grants.sql2021GRANT ROLE2022DO2023Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20251105172723_grant_pg_reload_conf_to_postgres.sql2024GRANT2025Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20251121132723_correct_search_path_pgbouncer.sql2026CREATE FUNCTION2027REVOKE2028REVOKE2029GRANT2030Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20260211120934_supabase_privileged_role.sql2031DO2032Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20260413000000_fix-authenticator-session-preload-libraries.sql2033ALTER ROLE2034Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20260421000000_pg_graphql-off-by-default.sql2035DROP EXTENSION2036Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20260421000001_rescope_pg_graphql_access_trigger.sql2037CREATE FUNCTION2038DROP EVENT TRIGGER2039CREATE EVENT TRIGGER2040Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20260730000000_revoke_trigger_on_cron_tables_from_postgres.sql2041DO2042CREATE FUNCTION2043Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20260923021047_update_pgrst_watch_triggers.sql2044CREATE FUNCTION2045CREATE FUNCTION2046Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20261016000001_search_path_for_supa_functions.sql2047CREATE FUNCTION2048CREATE FUNCTION2049CREATE FUNCTION2050CREATE FUNCTION2051CREATE FUNCTION2052CREATE FUNCTION2053ALTER DATABASE2054ALTER DATABASE2055ALTER ROLE2056ALTER ROLE2057ALTER ROLE2058ALTER ROLE2059ALTER ROLE2060ALTER ROLE2061ALTER ROLE2062ALTER ROLE2063ALTER ROLE2064ALTER ROLE2065Shutting down PostgreSQL...2066PostgreSQL is running in daemon mode. Please stop it using pg_ctl.2067pg_ctl: another server might be running; trying to start server anyway2068waiting for server to start.... stopped waiting2069pg_ctl: could not start server2070Examine the log output.2071pg_ctl: server is running (PID: 1236)2072/nix/store/9cgb3iwg25krw3rchysinlgn6bvh36kc-postgresql-and-plugins-17.11/bin/postgres "-D" "/build/tmp.S6954zssuf" "--config-file=/build/tmp.S6954zssuf/postgresql.conf" "-p" "5541" "-k" "/build/tmp.S6954zssuf/tmp"2073$ pg_isready -h localhost -p 5541 -U supabase_admin -q20742026-11-12 08:56:10 [INFO] PostgreSQL is ready20752026-11-12 08:56:10 [INFO] CLI variant detected - loading CLI prime SQL file2076$ psql -p 5541 -h localhost --no-password --username=supabase_admin -d postgres -v ON_ERROR_STOP=1 -Xf /nix/store/ib75j74vyc0w374jcz7mqcg6njf21yx3-prime-cli.sql2077SET2078CREATE EXTENSION2079CREATE EXTENSION2080CREATE EXTENSION2081CREATE EXTENSION20822026-11-12 08:56:10 [INFO] Creating test_config table for pg_regress tests2083$ psql -p 5541 -h localhost --no-password --username=supabase_admin -d postgres -c 2084 CREATE TABLE IF NOT EXISTS test_config (key TEXT PRIMARY KEY, value TEXT);2085 INSERT INTO test_config (key, value) VALUES ('http_mock_port', '8880')2086 ON CONFLICT (key) DO UPDATE SET value = EXCLUDED.value;2087 INSERT INTO test_config (key, value) VALUES ('http_mock_host', 'localhost')2088 ON CONFLICT (key) DO UPDATE SET value = EXCLUDED.value;20892090CREATE TABLE2091INSERT 0 12092INSERT 0 120932026-11-12 08:56:10 [INFO] CLI variant detected - running subset of pg_regress tests (39 tests)2094$ pg_regress --use-existing --dbname=postgres --inputdir=/nix/store/8xc1cmaljps5lxpfv66ik0v4vay4dsq5-tests --outputdir=/nix/store/0s9wba6r6n9b4lyzqb0r8j40lwvc057c-run-check-harness-psql-17-cli/regression_output --host=localhost --port=5541 --user=supabase_admin auth create_statistics_priv dblink docs-array-test docs-cascades-deletes docs-connections docs-enums docs-full-text-search docs-functions docs-indexes docs-json docs-partitioning docs-tables-and-data docs-triggers docs-webhooks enable_tracking event_trigger_search_path intarray_ltree_query ltree_label_overflow multirange_create_priv operator_breaking_change pg-safeupdate pg_graphql pg_net pg_plan_filter pgaudit pgbouncer pgcrypto_cipher_matrix pgsodium realtime replica_identity_upsert storage supautils_reserved_memberships supautils_reserved_roles vault wal2json z_17_intarray_ltree_query z_17_supabase_monitor_admin z_17_wal_summarize2095(using postmaster on localhost, port 5541)2096============== running regression test queries ==============2097test auth ... ok 18 ms2098test create_statistics_priv ... ok 15 ms2099test dblink ... ok 57 ms2100test docs-array-test ... ok 19 ms2101test docs-cascades-deletes ... ok 154 ms2102test docs-connections ... ok 12 ms2103test docs-enums ... ok 59 ms2104test docs-full-text-search ... ok 43 ms2105test docs-functions ... ok 111 ms2106test docs-indexes ... ok 88 ms2107test docs-json ... ok 20 ms2108test docs-partitioning ... ok 58 ms2109test docs-tables-and-data ... ok 167 ms2110test docs-triggers ... ok 121 ms2111test docs-webhooks ... ok 89 ms2112test enable_tracking ... ok 14 ms2113test event_trigger_search_path ... ok 12 ms2114test intarray_ltree_query ... ok 103 ms2115test ltree_label_overflow ... ok 86 ms2116test multirange_create_priv ... ok 16 ms2117test operator_breaking_change ... ok 43 ms2118test pg-safeupdate ... ok 20 ms2119test pg_graphql ... ok 90 ms2120test pg_net ... ok 13 ms2121test pg_plan_filter ... ok 16 ms2122test pgaudit ... ok 126 ms2123test pgbouncer ... ok 70 ms2124test pgcrypto_cipher_matrix ... ok 32 ms2125test pgsodium ... ok 16 ms2126test realtime ... ok 11 ms2127test replica_identity_upsert ... ok 17 ms2128test storage ... ok 38 ms2129test supautils_reserved_memberships ... ok 10 ms2130test supautils_reserved_roles ... ok 12 ms2131test vault ... ok 51 ms2132test wal2json ... ok 48 ms2133test z_17_intarray_ltree_query ... ok 67 ms2134test z_17_supabase_monitor_admin ... FAILED 30 ms2135test z_17_wal_summarize ... ok 11 ms21362137=======================2138 1 of 39 tests failed. 2139=======================21402141The differences that caused some tests to fail can be viewed in the2142file "/nix/store/0s9wba6r6n9b4lyzqb0r8j40lwvc057c-run-check-harness-psql-17-cli/regression_output/regression.diffs". A copy of the test summary that you see2143above is saved in the file "/nix/store/0s9wba6r6n9b4lyzqb0r8j40lwvc057c-run-check-harness-psql-17-cli/regression_output/regression.out".214421452026-11-12 08:56:12 [ERROR] pg_regress tests failed21462026-11-12 08:56:12 [ERROR] An error occurred. Exit code: 121472026-11-12 08:56:12 [ERROR] Debug logs: