run-check-harness-psql-17-cli
checks.aarch64-linux.psql_17_cli
· build #676
· raw
12026-11-12 08:20:36 [INFO] Starting HTTP mock server (will find free port)...22026-11-12 08:20:37 [INFO] HTTP mock server started on port 888032026-11-12 08:20:37 [INFO] Creating temporary PostgreSQL cluster at /build/tmp.Ah6XDhxXsy42026-11-12 08:20:38 [INFO] Generated preload libraries: pg_cron, pg_net, pgsodium, supabase_vault52026-11-12 08:20:38 [INFO] Checking shared_preload_libraries setting:62026-11-12 08:20:38 [INFO] 721:shared_preload_libraries = 'pg_cron, pg_net, pgsodium, supabase_vault' # (change requires restart)72026-11-12 08:20:38 [INFO] Configuring local auth82026-11-12 08:20:38 [INFO] Waiting for PostgreSQL to be ready...92026-11-12 08:20:39 [INFO] PostgreSQL is ready102026-11-12 08:20:39 [INFO] Creating test database112026-11-12 08:20:39 [INFO] CLI variant detected - loading CLI prime SQL file122026-11-12 08:20:39 [INFO] Creating test_config table132026-11-12 08:20:39 [INFO] Running pgtap test: auth.sql142026-11-12 08:20:39 [INFO] Running pgtap test: create_statistics_priv.sql152026-11-12 08:20:39 [INFO] Running pgtap test: dblink.sql162026-11-12 08:20:39 [INFO] Running pgtap test: docs-array-test.sql172026-11-12 08:20:39 [INFO] Running pgtap test: docs-cascades-deletes.sql182026-11-12 08:20:39 [INFO] Running pgtap test: docs-connections.sql192026-11-12 08:20:39 [INFO] Running pgtap test: docs-enums.sql202026-11-12 08:20:40 [INFO] Running pgtap test: docs-full-text-search.sql212026-11-12 08:20:40 [INFO] Running pgtap test: docs-functions.sql222026-11-12 08:20:40 [INFO] Running pgtap test: docs-indexes.sql232026-11-12 08:20:40 [INFO] Running pgtap test: docs-json.sql242026-11-12 08:20:40 [INFO] Running pgtap test: docs-partitioning.sql252026-11-12 08:20:40 [INFO] Running pgtap test: docs-tables-and-data.sql262026-11-12 08:20:40 [INFO] Running pgtap test: docs-triggers.sql272026-11-12 08:20:40 [INFO] Running pgtap test: docs-webhooks.sql282026-11-12 08:20:41 [INFO] Running pgtap test: enable_tracking.sql292026-11-12 08:20:41 [INFO] Running pgtap test: event_trigger_search_path.sql302026-11-12 08:20:41 [INFO] Running pgtap test: intarray_ltree_query.sql312026-11-12 08:20:41 [INFO] Running pgtap test: ltree_label_overflow.sql322026-11-12 08:20:41 [INFO] Running pgtap test: multirange_create_priv.sql332026-11-12 08:20:41 [INFO] Running pgtap test: operator_breaking_change.sql342026-11-12 08:20:41 [INFO] Running pgtap test: pg-safeupdate.sql352026-11-12 08:20:41 [INFO] Running pgtap test: pg_graphql.sql362026-11-12 08:20:41 [INFO] Running pgtap test: pg_net.sql372026-11-12 08:20:41 [INFO] Running pgtap test: pg_plan_filter.sql382026-11-12 08:20:41 [INFO] Running pgtap test: pgaudit.sql392026-11-12 08:20:41 [INFO] Running pgtap test: pgbouncer.sql402026-11-12 08:20:41 [INFO] Running pgtap test: pgcrypto_cipher_matrix.sql412026-11-12 08:20:41 [INFO] Running pgtap test: pgsodium.sql422026-11-12 08:20:42 [INFO] Running pgtap test: realtime.sql432026-11-12 08:20:42 [INFO] Running pgtap test: replica_identity_upsert.sql442026-11-12 08:20:42 [INFO] Running pgtap test: storage.sql452026-11-12 08:20:42 [INFO] Running pgtap test: supautils_reserved_roles.sql462026-11-12 08:20:42 [INFO] Running pgtap test: vault.sql472026-11-12 08:20:42 [INFO] Running pgtap test: wal2json.sql482026-11-12 08:20:42 [INFO] Running pgtap test: z_17_intarray_ltree_query.sql492026-11-12 08:20:42 [INFO] Running pgtap test: z_17_supabase_monitor_admin.sql502026-11-12 08:20:42 [INFO] Running pgtap test: z_17_wal_summarize.sql512026-11-12 08:20:42 [INFO] Starting PostgreSQL server for pg_regress tests522026-11-12 08:20:48 [INFO] PostgreSQL is ready532026-11-12 08:20:48 [INFO] CLI variant detected - loading CLI prime SQL file542026-11-12 08:20:48 [INFO] Creating test_config table for pg_regress tests552026-11-12 08:20:48 [INFO] CLI variant detected - running subset of pg_regress tests (38 tests)562026-11-12 08:20:50 [ERROR] pg_regress tests failed57diff -U3 /nix/store/2zv8j39hdn149zi4v21mv4y85w1iplvr-tests/expected/z_17_supabase_monitor_admin.out /nix/store/dnq6b8q4il3lyz5pnlji0x3297rlbyyc-run-check-harness-psql-17-cli/regression_output/results/z_17_supabase_monitor_admin.out58--- /nix/store/2zv8j39hdn149zi4v21mv4y85w1iplvr-tests/expected/z_17_supabase_monitor_admin.out 1970-01-01 00:00:01.000000000 +000059+++ /nix/store/dnq6b8q4il3lyz5pnlji0x3297rlbyyc-run-check-harness-psql-17-cli/regression_output/results/z_17_supabase_monitor_admin.out 2026-11-12 08:20:50.587736701 +000060@@ -1,5 +1,4 @@61--- supabase_monitor_admin: passwordless, read-only62--- monitoring role (quick_explainer.md,63+-- supabase_monitor_admin: passwordless, read-only, for monitoring from localhost64 -- migrations/db/init-scripts/00000000000000-initial-schema.sql)65 -- attributes: login, no password, bypassrls, nothing else66 -- only accessible via localhost672026-11-12 08:20:50 [ERROR] An error occurred. Exit code: 1682026-11-12 08:20:50 [ERROR] Debug logs:692026-11-12 08:20:36 [INFO] Starting HTTP mock server (will find free port)...70$ /nix/store/a1mjjnpfivsx5gi4rxbcr54vl6gyjfzj-python3-3.13.11/bin/python3 /nix/store/sfl1mnhcw0ccky7m2crn0hda79clq4mk-http-mock-server.py712026-11-12 08:20:37 [INFO] HTTP mock server started on port 8880722026-11-12 08:20:37 [INFO] Creating temporary PostgreSQL cluster at /build/tmp.Ah6XDhxXsy73$ initdb --locale=C --username=supabase_admin -D /build/tmp.Ah6XDhxXsy74The files belonging to this database system will be owned by user "nixbld".75This user must also own the server process.7677The database cluster will be initialized with locale "C".78The default database encoding has accordingly been set to "SQL_ASCII".79The default text search configuration will be set to "english".8081Data page checksums are disabled.8283fixing permissions on existing directory /build/tmp.Ah6XDhxXsy ... ok84creating subdirectories ... ok85selecting dynamic shared memory implementation ... posix86selecting default "max_connections" ... 10087selecting default "shared_buffers" ... 128MB88selecting default time zone ... UTC89creating configuration files ... ok90running bootstrap script ... ok91performing post-bootstrap initialization ... ok92syncing data to disk ... ok9394initdb: warning: enabling "trust" authentication for local connections95initdb: 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.9697Success. You can now start the database server using:9899 pg_ctl -D /build/tmp.Ah6XDhxXsy -l logfile start1001012026-11-12 08:20:38 [INFO] Generated preload libraries: pg_cron, pg_net, pgsodium, supabase_vault1022026-11-12 08:20:38 [INFO] Checking shared_preload_libraries setting:1032026-11-12 08:20:38 [INFO] 721:shared_preload_libraries = 'pg_cron, pg_net, pgsodium, supabase_vault' # (change requires restart)1042026-11-12 08:20:38 [INFO] Configuring local auth105$ pg_ctl -D /build/tmp.Ah6XDhxXsy -l /build/tmp.Ah6XDhxXsy/postgresql.log -o -k /build/tmp.Ah6XDhxXsy/sockets -p 5541 -d 5 start106waiting for server to start.... done107server started1082026-11-12 08:20:38 [INFO] Waiting for PostgreSQL to be ready...109$ pg_isready -h localhost -p 5541 -U supabase_admin -q1102026-11-12 08:20:39 [INFO] PostgreSQL is ready1112026-11-12 08:20:39 [INFO] Creating test database112$ createdb -p 5541 -h localhost --username=supabase_admin testing1132026-11-12 08:20:39 [INFO] CLI variant detected - loading CLI prime SQL file114$ psql -p 5541 -h localhost --username=supabase_admin -d testing -v ON_ERROR_STOP=1 -Xf /nix/store/ib75j74vyc0w374jcz7mqcg6njf21yx3-prime-cli.sql115SET116CREATE EXTENSION117CREATE EXTENSION118CREATE EXTENSION119CREATE EXTENSION1202026-11-12 08:20:39 [INFO] Creating test_config table121$ psql -p 5541 -h localhost --username=supabase_admin -d testing -c 122 CREATE TABLE IF NOT EXISTS test_config (key TEXT PRIMARY KEY, value TEXT);123 INSERT INTO test_config (key, value) VALUES ('http_mock_port', '8880')124 ON CONFLICT (key) DO UPDATE SET value = EXCLUDED.value;125 INSERT INTO test_config (key, value) VALUES ('http_mock_host', 'localhost')126 ON CONFLICT (key) DO UPDATE SET value = EXCLUDED.value;127128CREATE TABLE129INSERT 0 1130INSERT 0 11312026-11-12 08:20:39 [INFO] Running pgtap test: auth.sql132$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/auth.sql133 schema_name | owner 134-------------+-------135(0 rows)136137 schema_name | table_name | owner | rls_enabled | rls_policies 138-------------+------------+-------+-------------+--------------139(0 rows)140141 schema_name | table_name | role_name | privilege_type | is_grantable 142-------------+------------+-----------+----------------+--------------143(0 rows)144145 table_schema | table_name | index_name | index_owner 146--------------+------------+------------+-------------147(0 rows)148149 schema_name | function_name | owner 150-------------+---------------+-------151(0 rows)152153psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/auth.sql:97: ERROR: relation "auth.schema_migrations" does not exist154LINE 1: select * from auth.schema_migrations;155 ^1562026-11-12 08:20:39 [INFO] Running pgtap test: create_statistics_priv.sql157$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/create_statistics_priv.sql158BEGIN159CREATE SCHEMA160CREATE SCHEMA161psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/create_statistics_priv.sql:15: ERROR: role "postgres" does not exist162psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/create_statistics_priv.sql:17: ERROR: current transaction is aborted, commands ignored until end of transaction block163psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/create_statistics_priv.sql:20: ERROR: current transaction is aborted, commands ignored until end of transaction block164psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/create_statistics_priv.sql:21: ERROR: current transaction is aborted, commands ignored until end of transaction block165psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/create_statistics_priv.sql:24: ERROR: current transaction is aborted, commands ignored until end of transaction block166psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/create_statistics_priv.sql:27: ERROR: current transaction is aborted, commands ignored until end of transaction block167psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/create_statistics_priv.sql:28: ERROR: current transaction is aborted, commands ignored until end of transaction block168psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/create_statistics_priv.sql:29: ERROR: savepoint "no_priv" does not exist169psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/create_statistics_priv.sql:31: ERROR: current transaction is aborted, commands ignored until end of transaction block170ROLLBACK1712026-11-12 08:20:39 [INFO] Running pgtap test: dblink.sql172$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/dblink.sql173SET174DROP EXTENSION175psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/dblink.sql:10: ERROR: role "postgres" does not exist176CREATE TABLE177CREATE EXTENSION178DROP TABLE179RESET180 function_name | grantee | privilege_type 181-----------------------------+----------------+----------------182 dblink_connect_u(text) | supabase_admin | EXECUTE183 dblink_connect_u(text,text) | supabase_admin | EXECUTE184(2 rows)185186psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/dblink.sql:28: ERROR: role "postgres" does not exist187 search_path 188-----------------189 "$user", public190(1 row)191192DROP EXTENSION193CREATE EXTENSION1942026-11-12 08:20:39 [INFO] Running pgtap test: docs-array-test.sql195$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-array-test.sql196CREATE TABLE197INSERT 0 1198 id | textarray 199----+-------------------200 1 | {Harry,Larry,Moe}201(1 row)202203 textarray | array_length 204-----------+--------------205 Harry | 3206(1 row)207208DROP TABLE2092026-11-12 08:20:39 [INFO] Running pgtap test: docs-cascades-deletes.sql210$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-cascades-deletes.sql211CREATE TABLE212CREATE TABLE213CREATE TABLE214INSERT 0 1215INSERT 0 1216INSERT 0 1217INSERT 0 1218 count 219-------220 1221(1 row)222223 count 224-------225 2226(1 row)227228 count 229-------230 1231(1 row)232233psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-cascades-deletes.sql:47: ERROR: update or delete on table "parent" violates foreign key constraint "child_father_fkey" on table "child"234DETAIL: Key (id)=(1) is still referenced from table "child".235 count 236-------237 1238(1 row)239240 count 241-------242 2243(1 row)244245 count 246-------247 1248(1 row)249250psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-cascades-deletes.sql:56: ERROR: duplicate key value violates unique constraint "grandparent_pkey"251DETAIL: Key (id)=(1) already exists.252psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-cascades-deletes.sql:61: ERROR: duplicate key value violates unique constraint "parent_pkey"253DETAIL: Key (id)=(1) already exists.254psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-cascades-deletes.sql:66: ERROR: duplicate key value violates unique constraint "parent_pkey"255DETAIL: Key (id)=(2) already exists.256psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-cascades-deletes.sql:71: ERROR: duplicate key value violates unique constraint "child_pkey"257DETAIL: Key (id)=(1) already exists.258ALTER TABLE259ALTER TABLE260psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-cascades-deletes.sql:80: ERROR: update or delete on table "parent" violates foreign key constraint "child_father_fkey" on table "child"261DETAIL: Key (id)=(1) is still referenced from table "child".262 count 263-------264 1265(1 row)266267 count 268-------269 2270(1 row)271272 count 273-------274 1275(1 row)276277psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-cascades-deletes.sql:89: ERROR: duplicate key value violates unique constraint "grandparent_pkey"278DETAIL: Key (id)=(1) already exists.279psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-cascades-deletes.sql:94: ERROR: duplicate key value violates unique constraint "parent_pkey"280DETAIL: Key (id)=(1) already exists.281psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-cascades-deletes.sql:99: ERROR: duplicate key value violates unique constraint "parent_pkey"282DETAIL: Key (id)=(2) already exists.283psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-cascades-deletes.sql:104: ERROR: duplicate key value violates unique constraint "child_pkey"284DETAIL: Key (id)=(1) already exists.285ALTER TABLE286ALTER TABLE287psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-cascades-deletes.sql:113: ERROR: update or delete on table "parent" violates foreign key constraint "child_father_fkey" on table "child"288DETAIL: Key (id)=(1) is still referenced from table "child".289 count 290-------291 1292(1 row)293294 count 295-------296 2297(1 row)298299 count 300-------301 1302(1 row)303304psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-cascades-deletes.sql:122: ERROR: duplicate key value violates unique constraint "grandparent_pkey"305DETAIL: Key (id)=(1) already exists.306psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-cascades-deletes.sql:127: ERROR: duplicate key value violates unique constraint "parent_pkey"307DETAIL: Key (id)=(1) already exists.308psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-cascades-deletes.sql:132: ERROR: duplicate key value violates unique constraint "parent_pkey"309DETAIL: Key (id)=(2) already exists.310psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-cascades-deletes.sql:137: ERROR: duplicate key value violates unique constraint "child_pkey"311DETAIL: Key (id)=(1) already exists.312ALTER TABLE313UPDATE 1314DELETE 1315 count 316-------317 0318(1 row)319320 count 321-------322 0323(1 row)324325 count 326-------327 0328(1 row)329330CREATE TABLE331CREATE TABLE332INSERT 0 1333INSERT 0 1334DELETE 1335 count 336-------337 0338(1 row)339340 count 341-------342 0343(1 row)344345CREATE TABLE346CREATE TABLE347INSERT 0 1348INSERT 0 1349psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-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"350DETAIL: Key (id)=(1) is still referenced from table "test_restrict_child".351 count 352-------353 1354(1 row)355356 count 357-------358 1359(1 row)360361CREATE TABLE362CREATE TABLE363INSERT 0 1364INSERT 0 1365DELETE 1366 count 367-------368 0369(1 row)370371 count 372-------373 1374(1 row)375376 parent_id 377-----------378 379(1 row)380381CREATE TABLE382CREATE TABLE383INSERT 0 1384INSERT 0 1385psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-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"386DETAIL: Key (parent_id)=(999) is not present in table "test_set_default".387 count 388-------389 1390(1 row)391392 count 393-------394 1395(1 row)396397 parent_id 398-----------399 1400(1 row)401402CREATE TABLE403CREATE TABLE404INSERT 0 1405INSERT 0 1406psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-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"407DETAIL: Key (id)=(1) is still referenced from table "test_no_action_child".408 count 409-------410 1411(1 row)412413 count 414-------415 1416(1 row)417418DROP TABLE419DROP TABLE420DROP TABLE421DROP TABLE422DROP TABLE423DROP TABLE424DROP TABLE425DROP TABLE426DROP TABLE427DROP TABLE428DROP TABLE429DROP TABLE430DROP TABLE4312026-11-12 08:20:39 [INFO] Running pgtap test: docs-connections.sql432$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-connections.sql433 ssl | database | connected_role | application_name | query | state 434-----+----------+----------------+------------------+--------------------------------------------+--------435 f | testing | supabase_admin | psql | select +| active436 | | | | ssl, +| 437 | | | | datname as database, +| 438 | | | | usename as connected_role, +| 439 | | | | application_name, +| 440 | | | | query, +| 441 | | | | state +| 442 | | | | from pg_stat_ssl +| 443 | | | | join pg_stat_activity +| 444 | | | | on pg_stat_ssl.pid = pg_stat_activity.pid; | 445(1 row)4464472026-11-12 08:20:39 [INFO] Running pgtap test: docs-enums.sql448$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-enums.sql449CREATE TYPE450CREATE TABLE451INSERT 0 1452INSERT 0 1453INSERT 0 1454 id | name | current_mood 455----+------+--------------456 2 | Bob | sad457(1 row)458459 id | name | current_mood 460----+-------+--------------461 1 | Alice | happy462(1 row)463464UPDATE 1465 id | name | current_mood 466----+-------+--------------467 1 | Alice | excited468(1 row)469470ALTER TYPE471INSERT 0 1472 enum_range 473----------------------------------474 {happy,sad,excited,calm,content}475(1 row)476477 id | name | current_mood 478----+-------+--------------479 4 | David | content480(1 row)481482CREATE TYPE483CREATE TABLE484INSERT 0 3485 id | order_number | status 486----+--------------+--------487 1 | ORD-001 | active488(1 row)489490UPDATE 1491 id | order_number | status 492----+--------------+----------493 2 | ORD-002 | inactive494(1 row)495496ALTER TYPE497INSERT 0 1498 enum_range 499-------------------------------------500 {active,inactive,pending,cancelled}501(1 row)502503 id | order_number | status 504----+--------------+-----------505 4 | ORD-004 | cancelled506(1 row)507508CREATE TYPE509CREATE TABLE510INSERT 0 3511 id | title | priority 512----+----------------+----------513 3 | Security audit | critical514(1 row)515516UPDATE 1517 id | title | priority 518----+-------------+----------519 2 | Update docs | medium520(1 row)521522ALTER TYPE523INSERT 0 1524 enum_range 525-----------------------------------526 {low,medium,high,critical,urgent}527(1 row)528529 id | title | priority 530----+--------------------+----------531 4 | Server maintenance | urgent532(1 row)533534DROP TABLE535DROP TABLE536DROP TABLE537DROP TYPE538DROP TYPE539DROP TYPE5402026-11-12 08:20:40 [INFO] Running pgtap test: docs-full-text-search.sql541$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-full-text-search.sql542CREATE TABLE543INSERT 0 5544 to_tsvector 545---------------------------546 'egg':2 'green':1 'ham':4547(1 row)548549 to_tsvector 550---------------------------551 'egg':2 'green':1 'ham':4552(1 row)553554 id | title | author | description 555----+-------+--------+-------------556(0 rows)557558 id | title | author | description 559----+-------------------------------------+--------------+-------------------------------------------------560 5 | Harry Potter and the Goblet of Fire | J.K. Rowling | Fourth year of school starts, big drama ensues.561(1 row)562563 id | title | author | description 564----+-------------------------------------+-------------------+-------------------------------------------------565 3 | Tootle | Gertrude Crampton | Little toy train has big dreams.566 5 | Harry Potter and the Goblet of Fire | J.K. Rowling | Fourth year of school starts, big drama ensues.567(2 rows)568569 id | title | author | description 570----+-----------------------+------------------------+---------------------------------------------571 1 | The Poky Little Puppy | Janette Sebring Lowrey | Puppy is slower than other, bigger animals.572 3 | Tootle | Gertrude Crampton | Little toy train has big dreams.573(2 rows)574575CREATE FUNCTION576 id | title | author | description 577----+-----------------------+------------------------+---------------------------------------------578 1 | The Poky Little Puppy | Janette Sebring Lowrey | Puppy is slower than other, bigger animals.579 3 | Tootle | Gertrude Crampton | Little toy train has big dreams.580(2 rows)581582 id | title | author | description 583----+--------+-------------------+----------------------------------584 3 | Tootle | Gertrude Crampton | Little toy train has big dreams.585(1 row)586587 id | title | author | description 588----+-------------------------------------+-------------------+-------------------------------------------------589 3 | Tootle | Gertrude Crampton | Little toy train has big dreams.590 5 | Harry Potter and the Goblet of Fire | J.K. Rowling | Fourth year of school starts, big drama ensues.591(2 rows)592593 title 594-----------------------595 The Poky Little Puppy596(1 row)597598CREATE FUNCTION599 id | title | author | description 600----+-----------------------+------------------------+---------------------------------------------601 1 | The Poky Little Puppy | Janette Sebring Lowrey | Puppy is slower than other, bigger animals.602(1 row)603604 id | title | author | description 605----+-----------------------+------------------------+---------------------------------------------606 1 | The Poky Little Puppy | Janette Sebring Lowrey | Puppy is slower than other, bigger animals.607(1 row)608609ALTER TABLE610CREATE INDEX611 id | fts 612----+-----------------------------------------------------------------------------------------------------------------613 1 | 'anim':7 'bigger':6 'littl':10 'poki':9 'puppi':1,11 'slower':3614 2 | 'eat':2 'peter':8 'rabbit':1,9 'tale':6 'veget':4615 3 | 'big':5 'dream':6 'littl':1 'tootl':7 'toy':2 'train':3616 4 | 'chang':3 'color':9 'eat':7 'egg':12 'food':4,10 'green':11 'ham':14 'prefer':5 'sam':1 'unusu':8617 5 | 'big':6 'drama':7 'ensu':8 'fire':15 'fourth':1 'goblet':13 'harri':9 'potter':10 'school':4 'start':5 'year':2618(5 rows)619620 id | title | author | description | fts 621----+--------+-------------------+----------------------------------+---------------------------------------------------------622 3 | Tootle | Gertrude Crampton | Little toy train has big dreams. | 'big':5 'dream':6 'littl':1 'tootl':7 'toy':2 'train':3623(1 row)624625 id | title | author | description | fts 626----+--------+-------------------+----------------------------------+---------------------------------------------------------627 3 | Tootle | Gertrude Crampton | Little toy train has big dreams. | 'big':5 'dream':6 'littl':1 'tootl':7 'toy':2 'train':3628(1 row)629630 id | title | author | description | fts 631----+-------------------------------------+--------------+-------------------------------------------------+-----------------------------------------------------------------------------------------------------------------632 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':2633(1 row)634635 id | title | author | description | fts 636----+-------------------------------------+--------------+-------------------------------------------------+-----------------------------------------------------------------------------------------------------------------637 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':2638(1 row)639640 id | title | author | description | fts 641----+-------------------------------------+--------------+-------------------------------------------------+-----------------------------------------------------------------------------------------------------------------642 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':2643(1 row)644645 id | title | author | description | fts 646----+--------------------+-----------+--------------------------------------------------------------------+---------------------------------------------------------------------------------------------------647 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':8648(1 row)649650 id | title | author | description | fts 651----+--------+-------------------+----------------------------------+---------------------------------------------------------652 3 | Tootle | Gertrude Crampton | Little toy train has big dreams. | 'big':5 'dream':6 'littl':1 'tootl':7 'toy':2 'train':3653(1 row)654655 id | title | author | description | fts 656----+-------+--------+-------------+-----657(0 rows)658659 id | title | author | description | fts 660----+--------------------------+----------------+------------------------------+---------------------------------------------------661 2 | The Tale of Peter Rabbit | Beatrix Potter | Rabbit eats some vegetables. | 'eat':2 'peter':8 'rabbit':1,9 'tale':6 'veget':4662(1 row)663664 id | title | author | description | fts 665----+-------------------------------------+--------------+-------------------------------------------------+-----------------------------------------------------------------------------------------------------------------666 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':2667(1 row)668669 id | title | author | description | fts 670----+-------+--------+-------------+-----671(0 rows)672673 id | title | author | description | fts 674----+--------+-------------------+----------------------------------+---------------------------------------------------------675 3 | Tootle | Gertrude Crampton | Little toy train has big dreams. | 'big':5 'dream':6 'littl':1 'tootl':7 'toy':2 'train':3676(1 row)677678DROP FUNCTION679DROP FUNCTION680DROP TABLE6812026-11-12 08:20:40 [INFO] Running pgtap test: docs-functions.sql682$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-functions.sql683CREATE FUNCTION684 hello_world 685-------------686 hello world687(1 row)688689CREATE TABLE690INSERT 0 3691CREATE TABLE692INSERT 0 4693CREATE FUNCTION694 id | name 695----+----------696 1 | Tattoine697(1 row)698699CREATE FUNCTION700psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-functions.sql:64: ERROR: duplicate key value violates unique constraint "planets_pkey"701DETAIL: Key (id)=(1) already exists.702CONTEXT: SQL statement "insert into planets(name)703 values (add_planet.name)704 returning id"705PL/pgSQL function add_planet(text) line 5 at SQL statement706CREATE FUNCTION707 hello_world_definer 708---------------------709 hello world710(1 row)711712REVOKE713psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-functions.sql:79: ERROR: role "anon" does not exist714psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-functions.sql:81: ERROR: role "authenticated" does not exist715REVOKE716psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-functions.sql:84: ERROR: role "anon" does not exist717ALTER DEFAULT PRIVILEGES718psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-functions.sql:87: ERROR: role "anon" does not exist719psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-functions.sql:89: ERROR: role "authenticated" does not exist720CREATE FUNCTION721psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-functions.sql:106: WARNING: logging warning: WARNING MESSAGE722psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-functions.sql:106: ERROR: logging error: ERROR MESSAGE723CONTEXT: PL/pgSQL function logging_example(text,text,text) line 5 at RAISE724CREATE FUNCTION725 error_if_null 726---------------727 not null728(1 row)729730CREATE TABLE731INSERT 0 1732CREATE FUNCTION733 assert_example 734--------------------------------------735 123e4567-e89b-12d3-a456-426614174000736(1 row)737738CREATE FUNCTION739psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-functions.sql:162: ERROR: An error occurred in function <function name>: relation "table_that_does_not_exist" does not exist740CONTEXT: PL/pgSQL function error_example() line 7 at RAISE741CREATE TABLE742INSERT 0 1743CREATE FUNCTION744 advanced_example 745------------------746 42,new val747(1 row)748749DROP FUNCTION750DROP FUNCTION751DROP FUNCTION752DROP FUNCTION753DROP FUNCTION754DROP FUNCTION755DROP FUNCTION756DROP FUNCTION757DROP FUNCTION758DROP TABLE759DROP TABLE760DROP TABLE761DROP TABLE762GRANT763psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-functions.sql:221: ERROR: role "anon" does not exist764ALTER DEFAULT PRIVILEGES765psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-functions.sql:224: ERROR: role "anon" does not exist7662026-11-12 08:20:40 [INFO] Running pgtap test: docs-indexes.sql767$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-indexes.sql768CREATE TABLE769INSERT 0 1770 name 771----------772 John Doe773(1 row)774775CREATE INDEX776CREATE INDEX777CREATE INDEX778REINDEX779REINDEX780DROP TABLE7812026-11-12 08:20:40 [INFO] Running pgtap test: docs-json.sql782$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-json.sql783CREATE TABLE784INSERT 0 5785 title | description | price | low_age | high_age 786-------------------------------------+--------------------------------------------------------------------+-------+---------+----------787 The Poky Little Puppy | Puppy is slower than other, bigger animals. | 5.95 | 3 | 6788 The Tale of Peter Rabbit | Rabbit eats some vegetables. | 4.49 | 2 | 5789 Tootle | Little toy train has big dreams. | 3.99 | 2 | 5790 Green Eggs and Ham | Sam has changing food preferences and eats unusually colored food. | 7.49 | 4 | 8791 Harry Potter and the Goblet of Fire | Fourth year of school starts, big drama ensues. | 24.95 | 10 | 99792(5 rows)793794DROP TABLE7952026-11-12 08:20:40 [INFO] Running pgtap test: docs-partitioning.sql796$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-partitioning.sql797CREATE TABLE798CREATE TABLE799CREATE TABLE800INSERT 0 4801 id | order_date | customer_id | amount 802----+------------+-------------+--------803 1 | 2000-01-15 | 1 | 100804 2 | 2000-01-20 | 2 | 200805 3 | 2000-02-10 | 3 | 150806 4 | 2000-02-25 | 4 | 300807(4 rows)808809 id | order_date | customer_id | amount 810----+------------+-------------+--------811 3 | 2000-02-10 | 3 | 150812 4 | 2000-02-25 | 4 | 300813(2 rows)814815DROP TABLE816CREATE TABLE817CREATE TABLE818CREATE TABLE819INSERT 0 5820 id | name | country 821----+------------+---------822 1 | John Doe | US823 2 | Jane Smith | CANADA824(2 rows)825826 id | name | country 827----+-------------+---------828 3 | Li Wei | CHINA829 4 | Priya Patel | INDIA830 5 | Yuki Tanaka | JAPAN831(3 rows)832833DROP TABLE834CREATE TABLE835CREATE TABLE836CREATE TABLE837INSERT 0 4838 id | name | category | price 839----+--------+-------------+-------840 1 | Laptop | Electronics | 999841 2 | Phone | Electronics | 599842(2 rows)843844 count 845-------846 2847(1 row)848849 count 850-------851 2852(1 row)853854DROP TABLE8552026-11-12 08:20:40 [INFO] Running pgtap test: docs-tables-and-data.sql856$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-tables-and-data.sql857CREATE TABLE858 table_name | column_name | data_type | is_nullable | column_default 859------------+-------------+-----------+-------------+----------------860 movies | id | bigint | NO | 861 movies | name | text | YES | 862 movies | description | text | YES | 863(3 rows)864865DROP TABLE866CREATE TABLE867 column_name | data_type | is_nullable | column_default | is_identity | identity_generation 868-------------+-----------+-------------+----------------+-------------+---------------------869 id | bigint | NO | | YES | ALWAYS870(1 row)871872DROP TABLE873CREATE TABLE874 column_name | data_type | is_nullable | column_default | is_identity | identity_generation 875-------------+-----------+-------------+----------------+-------------+---------------------876 id | bigint | NO | | YES | BY DEFAULT877(1 row)878879DROP TABLE880CREATE TABLE881INSERT 0 2882 id | name | description 883----+-------------------------+--------------------------------------------------------------------------------------------------------------------------------884 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.885 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.886(2 rows)887888DROP TABLE889psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-tables-and-data.sql:57: NOTICE: table "categories" does not exist, skipping890DROP TABLE891CREATE TABLE892CREATE TABLE893ALTER TABLE894 table_name | column_name | foreign_table_name | foreign_column_name 895------------+-------------+--------------------+---------------------896 movies | category_id | categories | id897(1 row)898899psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-tables-and-data.sql:89: NOTICE: table "performances" does not exist, skipping900DROP TABLE901psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-tables-and-data.sql:90: NOTICE: table "actors" does not exist, skipping902DROP TABLE903DROP TABLE904CREATE TABLE905CREATE TABLE906CREATE TABLE907 table_name 908--------------909 actors910 movies911 performances912(3 rows)913914CREATE SCHEMA915 schema_name 916-------------917 private918(1 row)919920psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-tables-and-data.sql:120: NOTICE: table "salaries" does not exist, skipping921DROP TABLE922psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-tables-and-data.sql:121: NOTICE: drop cascades to constraint performances_actor_id_fkey on table performances923DROP TABLE924CREATE TABLE925CREATE TABLE926 table_schema | table_name 927--------------+------------928 private | salaries929(1 row)930931psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-tables-and-data.sql:137: NOTICE: table "grades" does not exist, skipping932DROP TABLE933psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-tables-and-data.sql:138: NOTICE: table "courses" does not exist, skipping934DROP TABLE935psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-tables-and-data.sql:139: NOTICE: table "students" does not exist, skipping936DROP TABLE937psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-tables-and-data.sql:140: NOTICE: view "transcripts" does not exist, skipping938DROP VIEW939CREATE TABLE940CREATE TABLE941CREATE TABLE942INSERT 0 3943INSERT 0 3944INSERT 0 6945CREATE VIEW946psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-tables-and-data.sql:192: ERROR: role "authenticated" does not exist947 name | type | title | code | result 948------------------+---------------+--------------------------+---------+--------949 Anakin Skywalker | graduate | Authentication Theories | AUTH205 | A950 Anakin Skywalker | graduate | Introduction to Postgres | PG101 | A-951 Anakin Skywalker | graduate | Fundamentals of Supabase | SUP412 | B-952 Princess Leia | undergraduate | Introduction to Postgres | PG101 | B+953 Princess Leia | undergraduate | Fundamentals of Supabase | SUP412 | A+954 Yoda | graduate | Authentication Theories | AUTH205 | A955(6 rows)956957psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-tables-and-data.sql:196: NOTICE: materialized view "transcripts_materialized" does not exist, skipping958DROP MATERIALIZED VIEW959SELECT 6960 name | type | title | code | result 961------------------+---------------+--------------------------+---------+--------962 Anakin Skywalker | graduate | Authentication Theories | AUTH205 | A963 Anakin Skywalker | graduate | Introduction to Postgres | PG101 | A-964 Anakin Skywalker | graduate | Fundamentals of Supabase | SUP412 | B-965 Princess Leia | undergraduate | Introduction to Postgres | PG101 | B+966 Princess Leia | undergraduate | Fundamentals of Supabase | SUP412 | A+967 Yoda | graduate | Authentication Theories | AUTH205 | A968(6 rows)969970REFRESH MATERIALIZED VIEW971 count 972-------973 6974(1 row)975976psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-tables-and-data.sql:217: NOTICE: view "secure_transcripts" does not exist, skipping977DROP VIEW978CREATE VIEW979 schemaname | viewname 980------------+--------------------981 public | secure_transcripts982(1 row)983984psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-tables-and-data.sql:228: NOTICE: view "test_view" does not exist, skipping985DROP VIEW986CREATE VIEW987ALTER VIEW988 schemaname | viewname 989------------+-----------990 public | test_view991(1 row)992993DROP MATERIALIZED VIEW994DROP VIEW995DROP VIEW996DROP VIEW997DROP TABLE998DROP TABLE999DROP TABLE1000DROP TABLE1001DROP TABLE1002DROP TABLE1003DROP TABLE1004DROP TABLE1005DROP SCHEMA10062026-11-12 08:20:40 [INFO] Running pgtap test: docs-triggers.sql1007$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-triggers.sql1008CREATE TABLE1009CREATE TABLE1010CREATE FUNCTION1011CREATE TRIGGER1012INSERT 0 11013INSERT 0 11014UPDATE 11015 id | employee_id | old_salary | new_salary 1016----+-------------+------------+------------1017 1 | 1 | 50000 | 550001018(1 row)10191020CREATE TABLE1021CREATE TABLE1022CREATE FUNCTION1023CREATE TRIGGER1024CREATE TABLE1025CREATE FUNCTION1026CREATE TRIGGER1027INSERT 0 11028INSERT 0 11029INSERT 0 11030INSERT 0 11031DELETE 11032 id | customer_id | action | customer_name 1033----+-------------+--------+---------------1034 1 | 1 | DELETE | Alice Johnson1035(1 row)10361037CREATE TABLE1038CREATE FUNCTION1039CREATE TRIGGER1040INSERT 0 11041 id | trigger_name | operation | table_name 1042----+-------------------------+-----------+------------1043 1 | statement_level_trigger | INSERT | orders1044(1 row)10451046CREATE TABLE1047CREATE FUNCTION1048CREATE TRIGGER1049INSERT 0 11050UPDATE 11051DELETE 11052 id | trigger_name | trigger_when | operation | table_name | table_schema | row_id 1053----+-------------------+--------------+-----------+------------+--------------+--------1054 1 | variables_trigger | AFTER | INSERT | employees | public | 31055 2 | variables_trigger | AFTER | UPDATE | employees | public | 31056 3 | variables_trigger | AFTER | DELETE | employees | public | 31057(3 rows)10581059CREATE TABLE1060CREATE FUNCTION1061CREATE TRIGGER1062INSERT 0 11063INSERT 0 11064 id | employee_name | salary 1065----+---------------+--------1066 1 | Executive | 1500001067(1 row)10681069DROP TRIGGER1070DROP TRIGGER1071DROP TRIGGER1072DROP TRIGGER1073DROP TRIGGER1074DROP TRIGGER1075DROP FUNCTION1076DROP FUNCTION1077DROP FUNCTION1078DROP FUNCTION1079DROP FUNCTION1080DROP FUNCTION1081DROP TABLE1082DROP TABLE1083DROP TABLE1084DROP TABLE1085DROP TABLE1086DROP TABLE1087DROP TABLE1088DROP TABLE10892026-11-12 08:20:40 [INFO] Running pgtap test: docs-webhooks.sql1090$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/docs-webhooks.sql1091CREATE TABLE1092CREATE TABLE1093CREATE FUNCTION1094CREATE TRIGGER1095CREATE TRIGGER1096CREATE TRIGGER1097INSERT 0 11098INSERT 0 11099 id | webhook_name | event_type | table_name | schema_name | ?column? 1100----+----------------+------------+------------+-------------+--------------------------------------------------------------1101 1 | insert_webhook | INSERT | profiles | public | {"id": 1, "name": "John Doe", "email": "john@example.com"}1102 2 | insert_webhook | INSERT | profiles | public | {"id": 2, "name": "Jane Smith", "email": "jane@example.com"}1103(2 rows)11041105UPDATE 11106 id | webhook_name | event_type | table_name | schema_name | ?column? | ?column? 1107----+----------------+------------+------------+-------------+----------------------------------------------------------------+------------------------------------------------------------1108 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"}1109(1 row)11101111DELETE 11112 id | webhook_name | event_type | table_name | schema_name | ?column? 1113----+----------------+------------+------------+-------------+--------------------------------------------------------------1114 4 | delete_webhook | DELETE | profiles | public | {"id": 2, "name": "Jane Smith", "email": "jane@example.com"}1115(1 row)11161117CREATE TABLE1118CREATE TABLE1119CREATE FUNCTION1120CREATE FUNCTION1121CREATE TRIGGER1122INSERT 0 11123INSERT 0 11124 id | webhook_name | url | method | response_status | response_data 1125----+----------------+----------------------------------+--------+-----------------+------------------------------------------------------------------------------------------1126 1 | orders_webhook | https://dummyjson.com/products/1 | GET | 200 | {"id": 1, "price": 9.99, "title": "Essence Mascara Lash Princess", "category": "beauty"}1127 2 | orders_webhook | https://dummyjson.com/products/1 | GET | 200 | {"id": 1, "price": 9.99, "title": "Essence Mascara Lash Princess", "category": "beauty"}1128(2 rows)11291130CREATE TABLE1131INSERT 0 11132CREATE FUNCTION1133CREATE TRIGGER1134INSERT 0 11135 id | webhook_name | url | method | response_status | response_data 1136----+-----------------+----------------------------------+--------+-----------------+-------------------------------------------------------------------------------------------1137 3 | product_webhook | https://dummyjson.com/products/2 | GET | 200 | {"id": 2, "price": 19.99, "title": "Eyeshadow Palette with Mirror", "category": "beauty"}1138(1 row)11391140CREATE FUNCTION1141 webhook_name | event_type | table_name | record_count 1142----------------+------------+------------+--------------1143 delete_webhook | DELETE | profiles | 11144 insert_webhook | INSERT | profiles | 31145 update_webhook | UPDATE | profiles | 11146(3 rows)11471148DROP TRIGGER1149DROP TRIGGER1150DROP TRIGGER1151DROP TRIGGER1152DROP TRIGGER1153DROP FUNCTION1154DROP FUNCTION1155DROP FUNCTION1156DROP FUNCTION1157DROP FUNCTION1158DROP TABLE1159DROP TABLE1160DROP TABLE1161DROP TABLE1162DROP TABLE11632026-11-12 08:20:41 [INFO] Running pgtap test: enable_tracking.sql1164$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/enable_tracking.sql1165psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/enable_tracking.sql:1: ERROR: role "postgres" does not exist1166psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/enable_tracking.sql:2: ERROR: role "postgres" does not exist1167psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/enable_tracking.sql:4: ERROR: role "postgres" does not exist1168psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/enable_tracking.sql:5: ERROR: role "postgres" does not exist11692026-11-12 08:20:41 [INFO] Running pgtap test: event_trigger_search_path.sql1170$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/event_trigger_search_path.sql1171DO11722026-11-12 08:20:41 [INFO] Running pgtap test: intarray_ltree_query.sql1173$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/intarray_ltree_query.sql1174BEGIN1175SET1176CREATE EXTENSION1177CREATE EXTENSION1178 q_and 1179-------1180 f1181(1 row)11821183 q_or 1184------1185 t1186(1 row)11871188 lquery_match 1189--------------1190 t1191(1 row)11921193 ltxtquery_match 1194-----------------1195 t1196(1 row)11971198psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/intarray_ltree_query.sql:38: ERROR: query_int expression is too complex1199psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/intarray_ltree_query.sql:42: ERROR: current transaction is aborted, commands ignored until end of transaction block1200psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/intarray_ltree_query.sql:45: ERROR: current transaction is aborted, commands ignored until end of transaction block1201psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/intarray_ltree_query.sql:47: ERROR: current transaction is aborted, commands ignored until end of transaction block1202ROLLBACK12032026-11-12 08:20:41 [INFO] Running pgtap test: ltree_label_overflow.sql1204$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/ltree_label_overflow.sql1205BEGIN1206SET1207CREATE EXTENSION1208 na | nb | a_gt_b | a_lt_b | b_lt_a | a_eq_a 1209-------+----+--------+--------+--------+--------1210 20001 | 1 | t | f | t | t1211(1 row)12121213ROLLBACK12142026-11-12 08:20:41 [INFO] Running pgtap test: multirange_create_priv.sql1215$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/multirange_create_priv.sql1216BEGIN1217CREATE SCHEMA1218CREATE SCHEMA1219psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/multirange_create_priv.sql:16: ERROR: role "postgres" does not exist1220psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/multirange_create_priv.sql:18: ERROR: current transaction is aborted, commands ignored until end of transaction block1221psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/multirange_create_priv.sql:24: ERROR: current transaction is aborted, commands ignored until end of transaction block1222psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/multirange_create_priv.sql:28: ERROR: current transaction is aborted, commands ignored until end of transaction block1223psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/multirange_create_priv.sql:32: ERROR: current transaction is aborted, commands ignored until end of transaction block1224psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/multirange_create_priv.sql:33: ERROR: savepoint "no_priv" does not exist1225psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/multirange_create_priv.sql:35: ERROR: current transaction is aborted, commands ignored until end of transaction block1226ROLLBACK12272026-11-12 08:20:41 [INFO] Running pgtap test: operator_breaking_change.sql1228$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/operator_breaking_change.sql1229BEGIN1230SET1231CREATE EXTENSION1232CREATE SCHEMA1233psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/operator_breaking_change.sql:22: ERROR: role "postgres" does not exist1234psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/operator_breaking_change.sql:26: ERROR: current transaction is aborted, commands ignored until end of transaction block1235psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/operator_breaking_change.sql:29: ERROR: current transaction is aborted, commands ignored until end of transaction block1236psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/operator_breaking_change.sql:32: ERROR: current transaction is aborted, commands ignored until end of transaction block1237psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/operator_breaking_change.sql:37: ERROR: current transaction is aborted, commands ignored until end of transaction block1238psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/operator_breaking_change.sql:38: ERROR: savepoint "before_restrict" does not exist1239psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/operator_breaking_change.sql:41: ERROR: current transaction is aborted, commands ignored until end of transaction block1240psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/operator_breaking_change.sql:46: ERROR: current transaction is aborted, commands ignored until end of transaction block1241psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/operator_breaking_change.sql:47: ERROR: savepoint "before_join" does not exist1242psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/operator_breaking_change.sql:55: ERROR: current transaction is aborted, commands ignored until end of transaction block1243psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/operator_breaking_change.sql:56: ERROR: current transaction is aborted, commands ignored until end of transaction block1244psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/operator_breaking_change.sql:58: ERROR: current transaction is aborted, commands ignored until end of transaction block1245psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/operator_breaking_change.sql:60: ERROR: current transaction is aborted, commands ignored until end of transaction block1246ROLLBACK12472026-11-12 08:20:41 [INFO] Running pgtap test: pg-safeupdate.sql1248$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/pg-safeupdate.sql1249LOAD1250SET1251CREATE SCHEMA1252CREATE TABLE1253psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/pg-safeupdate.sql:13: ERROR: UPDATE requires a WHERE clause1254psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/pg-safeupdate.sql:15: NOTICE: drop cascades to table v.foo1255DROP SCHEMA12562026-11-12 08:20:41 [INFO] Running pgtap test: pg_graphql.sql1257$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/pg_graphql.sql1258BEGIN1259COMMENT1260CREATE TABLE1261CREATE TABLE1262COMMENT1263CREATE FUNCTION1264 resolve 1265----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------1266 {"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}}}1267(1 row)12681269 resolve 1270--------------------------------------------------------------------------------------1271 {"data": {"insertIntoBlogCollection": {"records": [{"id": 1, "owner": {"id": 1}}]}}}1272(1 row)12731274 resolve 1275------------------------------------------------------------------------------------------------------------------------1276 {"data": {"insertIntoAccountCollection": {"records": [{"email": "baz@baz.com", "status": null}], "affectedCount": 1}}}1277(1 row)12781279 resolve 1280--------------------------------------------------------------------------------------------------------------------------------1281 {"data": {"xyz": {"records": [{"id": 4, "email": "foo@bar.com"}, {"id": 5, "email": "other@email.com"}], "affectedCount": 2}}}1282(1 row)12831284 resolve 1285------------------------------------------------------------------------------------------------1286 {"data": {"xyz": {"records": [{"email": "1@email.com", "status": null}], "affectedCount": 1}}}1287(1 row)12881289 resolve 1290------------------------------------------------------------------------------------------------1291 {"data": {"xyz": {"records": [{"email": "x@y.com", "status": "active"}], "affectedCount": 1}}}1292(1 row)12931294 resolve 1295-----------------------------------------------------------------------------------------------------------------1296 {"data": {"insertIntoAccountCollection": {"records": [{"id": 8, "email": "bar@foo.com"}], "affectedCount": 1}}}1297(1 row)12981299 resolve 1300-----------------------------------------------------------------------------------------------------------------1301 {"data": {"insertIntoAccountCollection": {"records": [{"id": 9, "email": "bar@foo.com"}], "affectedCount": 1}}}1302(1 row)13031304 resolve 1305--------------------------------------------------------------1306 {"data": {"insertIntoBlogCollection": {"affectedCount": 1}}}1307(1 row)13081309 resolve 1310---------------------------------------------------------------------------------------------------------------------1311 {"data": null, "errors": [{"message": "Input for type AccountInsertInput contains extra keys [\"doesNotExist\"]"}]}1312(1 row)13131314 resolve 1315-----------------------------------------------------------------------------------1316 {"data": null, "errors": [{"message": "Invalid input for BlogInsertInput type"}]}1317(1 row)13181319 resolve 1320---------------------------------------------------------------------------1321 {"data": null, "errors": [{"message": "Invalid input for NonNull type"}]}1322(1 row)13231324 resolve 1325--------------------------------------------------------------------------------------------1326 {"data": null, "errors": [{"message": "At least one record must be provided to objects"}]}1327(1 row)13281329ROLLBACK13302026-11-12 08:20:41 [INFO] Running pgtap test: pg_net.sql1331$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/pg_net.sql1332 request_id 1333------------1334 11335(1 row)133613372026-11-12 08:20:41 [INFO] Running pgtap test: pg_plan_filter.sql1338$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/pg_plan_filter.sql1339BEGIN1340psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/pg_plan_filter.sql:2: ERROR: could not access file "plan_filter": No such file or directory1341psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/pg_plan_filter.sql:4: ERROR: current transaction is aborted, commands ignored until end of transaction block1342psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/pg_plan_filter.sql:10: ERROR: current transaction is aborted, commands ignored until end of transaction block1343psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/pg_plan_filter.sql:14: ERROR: current transaction is aborted, commands ignored until end of transaction block1344psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/pg_plan_filter.sql:16: ERROR: current transaction is aborted, commands ignored until end of transaction block1345psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/pg_plan_filter.sql:18: ERROR: current transaction is aborted, commands ignored until end of transaction block1346ROLLBACK13472026-11-12 08:20:41 [INFO] Running pgtap test: pgaudit.sql1348$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/pgaudit.sql1349SET1350SET1351SET1352CREATE SCHEMA1353CREATE TABLE1354INSERT 0 11355 id | name | password | description 1356----+-------+----------+-------------1357 1 | user1 | HASH1 | blah, blah1358(1 row)13591360psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/pgaudit.sql:23: NOTICE: drop cascades to table v.account1361DROP SCHEMA13622026-11-12 08:20:41 [INFO] Running pgtap test: pgbouncer.sql1363$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/pgbouncer.sql1364 schema_name | owner 1365-------------+-------1366(0 rows)13671368 schema_name | function_name | owner 1369-------------+---------------+-------1370(0 rows)13711372 schema | object_name | grantee | privilege_type 1373--------+-------------+---------+----------------1374(0 rows)13751376CREATE ROLE1377CREATE ROLE1378UPDATE 11379Null display is "<null>".1380psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/pgbouncer.sql:62: ERROR: schema "pgbouncer" does not exist1381LINE 1: select * from pgbouncer.get_auth('test_expired_user_password...1382 ^1383psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/pgbouncer.sql:64: ERROR: schema "pgbouncer" does not exist1384LINE 1: select pgbouncer.get_auth('test_valid_user_password');1385 ^1386psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/pgbouncer.sql:67: ERROR: role "pgbouncer" does not exist1387psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/pgbouncer.sql:68: ERROR: schema "pgbouncer" does not exist1388LINE 1: select pgbouncer.get_auth('test_valid_user_password');1389 ^1390RESET1391psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/pgbouncer.sql:72: ERROR: role "postgres" does not exist1392psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/pgbouncer.sql:73: ERROR: schema "pgbouncer" does not exist1393LINE 1: select pgbouncer.get_auth('test_valid_user_password');1394 ^1395RESET1396DROP ROLE1397DROP ROLE13982026-11-12 08:20:41 [INFO] Running pgtap test: pgcrypto_cipher_matrix.sql1399$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/pgcrypto_cipher_matrix.sql1400BEGIN1401CREATE EXTENSION1402SAVEPOINT1403psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/pgcrypto_cipher_matrix.sql:26: ERROR: encrypt error: Cipher cannot be initialized1404ROLLBACK1405SAVEPOINT1406psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/pgcrypto_cipher_matrix.sql:30: ERROR: encrypt error: Cipher cannot be initialized1407ROLLBACK1408SAVEPOINT1409psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/pgcrypto_cipher_matrix.sql:34: ERROR: encrypt error: Cipher cannot be initialized1410ROLLBACK1411 aes128_rt 1412-----------1413 secret1414(1 row)14151416 aes192_rt 1417-----------1418 secret1419(1 row)14201421 aes256_rt 1422-----------1423 secret1424(1 row)14251426 des3_rt 1427---------1428 secret1429(1 row)14301431SAVEPOINT1432psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/pgcrypto_cipher_matrix.sql:45: ERROR: Wrong key or corrupt data1433ROLLBACK1434SAVEPOINT1435psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/pgcrypto_cipher_matrix.sql:49: ERROR: Wrong key or corrupt data1436ROLLBACK1437 post_error_ok 1438---------------1439 still-here1440(1 row)14411442ROLLBACK14432026-11-12 08:20:41 [INFO] Running pgtap test: pgsodium.sql1444$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/pgsodium.sql1445 status 1446--------1447 valid1448(1 row)144914502026-11-12 08:20:42 [INFO] Running pgtap test: realtime.sql1451$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/realtime.sql1452 publication_name | owner | puballtables | pubinsert | pubupdate | pubdelete | pubtruncate 1453------------------+-------+--------------+-----------+-----------+-----------+-------------1454(0 rows)145514562026-11-12 08:20:42 [INFO] Running pgtap test: replica_identity_upsert.sql1457$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/replica_identity_upsert.sql1458BEGIN1459CREATE TABLE1460CREATE PUBLICATION1461INSERT 0 11462SAVEPOINT1463psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/replica_identity_upsert.sql:17: ERROR: cannot update table "ri" because it does not have a replica identity and publishes updates1464HINT: To enable updating the table, set REPLICA IDENTITY using ALTER TABLE.1465ROLLBACK1466SAVEPOINT1467psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/replica_identity_upsert.sql:22: ERROR: cannot update table "ri" because it does not have a replica identity and publishes updates1468HINT: To enable updating the table, set REPLICA IDENTITY using ALTER TABLE.1469ROLLBACK1470ALTER TABLE1471INSERT 0 11472MERGE 11473 v 1474----1475 301476(1 row)14771478ROLLBACK14792026-11-12 08:20:42 [INFO] Running pgtap test: storage.sql1480$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/storage.sql1481 schema_name | owner 1482-------------+-------1483(0 rows)14841485 schema_name | table_name | owner | rls_enabled | rls_policies 1486-------------+------------+-------+-------------+--------------1487(0 rows)14881489 schema_name | table_name | role_name | privilege_type | is_grantable 1490-------------+------------+-----------+----------------+--------------1491(0 rows)14921493 table_schema | table_name | index_name | index_owner 1494--------------+------------+------------+-------------1495(0 rows)14961497 schema_name | function_name | owner 1498-------------+---------------+-------1499(0 rows)15001501CREATE ROLE1502psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/storage.sql:98: ERROR: role "postgres" does not exist1503psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/storage.sql:100: ERROR: role "postgres" does not exist1504psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/storage.sql:101: ERROR: schema "storage" does not exist1505psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/storage.sql:102: ERROR: schema "storage" does not exist1506psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/storage.sql:104: ERROR: role "postgres" does not exist1507DROP OWNED1508DROP ROLE1509RESET15102026-11-12 08:20:42 [INFO] Running pgtap test: supautils_reserved_roles.sql1511$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/supautils_reserved_roles.sql1512BEGIN1513psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/supautils_reserved_roles.sql:5: ERROR: role "postgres" does not exist1514psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/supautils_reserved_roles.sql:8: ERROR: current transaction is aborted, commands ignored until end of transaction block1515psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/supautils_reserved_roles.sql:9: ERROR: current transaction is aborted, commands ignored until end of transaction block1516psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/supautils_reserved_roles.sql:10: ERROR: savepoint "before_drop" does not exist1517psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/supautils_reserved_roles.sql:12: ERROR: current transaction is aborted, commands ignored until end of transaction block1518psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/supautils_reserved_roles.sql:14: ERROR: current transaction is aborted, commands ignored until end of transaction block1519ROLLBACK15202026-11-12 08:20:42 [INFO] Running pgtap test: vault.sql1521$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/vault.sql1522 schema | object_name | grantee | privilege_type 1523--------+---------------------------+----------------+----------------1524 vault | _crypto_aead_det_decrypt | supabase_admin | EXECUTE1525 vault | _crypto_aead_det_encrypt | supabase_admin | EXECUTE1526 vault | _crypto_aead_det_noncegen | supabase_admin | EXECUTE1527 vault | create_secret | supabase_admin | EXECUTE1528 vault | update_secret | supabase_admin | EXECUTE1529(5 rows)15301531 schema | table | index_name | index_owner | index_type 1532--------+---------+------------------+----------------+------------1533 vault | secrets | secrets_name_idx | supabase_admin | Unique1534 vault | secrets | secrets_pkey | supabase_admin | Unique1535(2 rows)15361537 search_path 1538-----------------1539 "$user", public1540(1 row)15411542SET1543DROP EXTENSION1544CREATE TABLE1545psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/vault.sql:65: ERROR: role "postgres" does not exist1546LINE 1: ...g_extension values (0, 'supabase_vault', '0.2.8', 'postgres'...1547 ^1548CREATE EXTENSION1549DROP TABLE1550RESET1551 function_name | grantee | privilege_type 1552---------------+---------+----------------1553(0 rows)15541555psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/vault.sql:83: ERROR: role "postgres" does not exist1556 search_path 1557-----------------1558 "$user", public1559(1 row)156015612026-11-12 08:20:42 [INFO] Running pgtap test: wal2json.sql1562$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/wal2json.sql1563CREATE SCHEMA1564CREATE TABLE1565psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/wal2json.sql:10: ERROR: could not access file "wal2json": No such file or directory1566INSERT 0 11567psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/wal2json.sql:28: ERROR: replication slot "reg_test" does not exist1568psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/wal2json.sql:31: ERROR: replication slot "reg_test" does not exist1569psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/wal2json.sql:33: NOTICE: drop cascades to table v.foo1570DROP SCHEMA15712026-11-12 08:20:42 [INFO] Running pgtap test: z_17_intarray_ltree_query.sql1572$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/z_17_intarray_ltree_query.sql1573BEGIN1574SET1575CREATE EXTENSION1576psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/z_17_intarray_ltree_query.sql:7: ERROR: lquery level is too large1577DETAIL: Total size of level exceeds the maximum allowed (65535 bytes).1578psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/z_17_intarray_ltree_query.sql:9: ERROR: current transaction is aborted, commands ignored until end of transaction block1579ROLLBACK15802026-11-12 08:20:42 [INFO] Running pgtap test: z_17_supabase_monitor_admin.sql1581$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/z_17_supabase_monitor_admin.sql1582 rolsuper | rolinherit | rolcreaterole | rolcreatedb | rolcanlogin | rolreplication | rolbypassrls | rolconnlimit | no_password 1583----------+------------+---------------+-------------+-------------+----------------+--------------+--------------+-------------1584(0 rows)15851586 setting 1587---------1588(0 rows)15891590psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/z_17_supabase_monitor_admin.sql:16: ERROR: role "supabase_monitor_admin" does not exist1591LINE 2: from pg_auth_members where member = 'supabase_monitor_admin'...1592 ^1593psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/z_17_supabase_monitor_admin.sql:19: ERROR: role "supabase_monitor_admin" does not exist1594LINE 1: ...lect count(*) from pg_auth_members where roleid = 'supabase_...1595 ^1596psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/z_17_supabase_monitor_admin.sql:26: ERROR: role "supabase_monitor_admin" does not exist1597LINE 3: and refobjid = 'supabase_monitor_admin'::regrole1598 ^1599psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/z_17_supabase_monitor_admin.sql:29: ERROR: role "supabase_monitor_admin" does not exist1600CREATE TABLE1601INSERT 0 21602ALTER TABLE1603ALTER TABLE1604psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/z_17_supabase_monitor_admin.sql:39: ERROR: role "postgres" does not exist1605psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/z_17_supabase_monitor_admin.sql:40: ERROR: role "supabase_monitor_admin" does not exist1606 count 1607-------1608 21609(1 row)16101611INSERT 0 11612SET1613 count 1614-------1615 01616(1 row)16171618RESET1619DROP TABLE1620BEGIN1621psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/z_17_supabase_monitor_admin.sql:52: ERROR: role "postgres" does not exist1622psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/z_17_supabase_monitor_admin.sql:53: ERROR: current transaction is aborted, commands ignored until end of transaction block1623psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/z_17_supabase_monitor_admin.sql:54: ERROR: current transaction is aborted, commands ignored until end of transaction block1624psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/z_17_supabase_monitor_admin.sql:55: ERROR: savepoint "s" does not exist1625psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/z_17_supabase_monitor_admin.sql:56: ERROR: current transaction is aborted, commands ignored until end of transaction block1626psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/z_17_supabase_monitor_admin.sql:57: ERROR: savepoint "s" does not exist1627psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/z_17_supabase_monitor_admin.sql:58: ERROR: current transaction is aborted, commands ignored until end of transaction block1628psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/z_17_supabase_monitor_admin.sql:59: ERROR: savepoint "s" does not exist1629psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/z_17_supabase_monitor_admin.sql:60: ERROR: current transaction is aborted, commands ignored until end of transaction block1630psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/z_17_supabase_monitor_admin.sql:61: ERROR: savepoint "s" does not exist1631psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/z_17_supabase_monitor_admin.sql:62: ERROR: current transaction is aborted, commands ignored until end of transaction block1632psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/z_17_supabase_monitor_admin.sql:63: ERROR: savepoint "s" does not exist1633psql:/nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/z_17_supabase_monitor_admin.sql:64: ERROR: current transaction is aborted, commands ignored until end of transaction block1634ROLLBACK16352026-11-12 08:20:42 [INFO] Running pgtap test: z_17_wal_summarize.sql1636$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/91zs1llglsxkw1x64gg4q6hdn2swk9nf-sql/z_17_wal_summarize.sql1637 summarize_wal_default_ok 1638--------------------------1639 f1640(1 row)16411642$ pg_ctl -D /build/tmp.Ah6XDhxXsy stop1643waiting for server to shut down.... done1644server stopped16452026-11-12 08:20:42 [INFO] Starting PostgreSQL server for pg_regress tests1646$ /nix/store/l8arahpcbqq0y7f042mibvzqsifspml6-start-postgres-server-test/bin/start-postgres-server 17 --daemonize1647Starting server for PSQL 171648/nix/store/l8arahpcbqq0y7f042mibvzqsifspml6-start-postgres-server-test/bin/start-postgres-server: line 190: warning: setlocale: LC_ALL: cannot change locale (en_US.UTF-8): No such file or directory1649KEY_FILE: /build/tmp.XSGBEY05Oo/pgsodium.key1650KEY_FILE contents:1651cat: /build/tmp.XSGBEY05Oo/pgsodium.key: No such file or directory1652PGSODIUM_GETKEY_SCRIPT: /nix/store/w9di5d0d375pnbgky9kz1gqgh0jv7i65-pgsodium-getkey/bin/pgsodium-getkey1653NOTE: using port 5541 for server1654NOTE: using temporary directory /build/tmp.XSGBEY05Oo for data1655NOTE: you are free to re-use this data directory at will1656The files belonging to this database system will be owned by user "nixbld".1657This user must also own the server process.16581659The database cluster will be initialized with locale "en_US.UTF-8".1660The default database encoding has accordingly been set to "UTF8".1661The default text search configuration will be set to "english".16621663Data page checksums are disabled.16641665fixing permissions on existing directory /build/tmp.XSGBEY05Oo ... ok1666creating subdirectories ... ok1667selecting dynamic shared memory implementation ... posix1668selecting default "max_connections" ... 1001669selecting default "shared_buffers" ... 128MB1670selecting default time zone ... UTC1671creating configuration files ... ok1672running bootstrap script ... ok1673performing post-bootstrap initialization ... ok1674syncing data to disk ... ok16751676initdb: warning: enabling "trust" authentication for local connections1677initdb: 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.16781679Success. You can now start the database server using:16801681 /nix/store/9cgb3iwg25krw3rchysinlgn6bvh36kc-postgresql-and-plugins-17.11/bin/pg_ctl -D /build/tmp.XSGBEY05Oo -l logfile start16821683NOTE: patching postgresql.conf files1684non-macos pg 17 conf1685waiting for server to start.... done1686server started1687pg_ctl: server is running (PID: 1213)1688/nix/store/9cgb3iwg25krw3rchysinlgn6bvh36kc-postgresql-and-plugins-17.11/bin/postgres "-D" "/build/tmp.XSGBEY05Oo" "--config-file=/build/tmp.XSGBEY05Oo/postgresql.conf" "-p" "5541" "-k" "/build/tmp.XSGBEY05Oo/tmp"1689PostgreSQL is ready1690NOTICE: empty string is not a valid password, clearing password1691CREATE ROLE1692ALTER DATABASE1693Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/init-scripts/00000000000000-initial-schema.sql1694CREATE PUBLICATION1695ALTER ROLE1696CREATE ROLE1697CREATE ROLE1698GRANT ROLE1699GRANT1700CREATE ROLE1701GRANT ROLE1702CREATE ROLE1703GRANT ROLE1704ALTER ROLE1705ALTER ROLE1706ALTER ROLE1707ALTER ROLE1708ALTER ROLE1709ALTER ROLE1710CREATE SCHEMA1711CREATE EXTENSION1712CREATE EXTENSION1713CREATE ROLE1714CREATE ROLE1715CREATE ROLE1716CREATE ROLE1717GRANT ROLE1718GRANT ROLE1719GRANT ROLE1720GRANT ROLE1721GRANT1722ALTER DEFAULT PRIVILEGES1723ALTER DEFAULT PRIVILEGES1724ALTER DEFAULT PRIVILEGES1725GRANT1726ALTER ROLE1727ALTER DEFAULT PRIVILEGES1728ALTER DEFAULT PRIVILEGES1729ALTER DEFAULT PRIVILEGES1730ALTER ROLE1731ALTER ROLE1732Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/init-scripts/00000000000001-auth-schema.sql1733CREATE SCHEMA1734CREATE TABLE1735CREATE INDEX1736CREATE INDEX1737COMMENT1738CREATE TABLE1739CREATE INDEX1740CREATE INDEX1741CREATE INDEX1742COMMENT1743CREATE TABLE1744COMMENT1745CREATE TABLE1746CREATE INDEX1747COMMENT1748CREATE TABLE1749COMMENT1750INSERT 0 71751CREATE FUNCTION1752CREATE FUNCTION1753CREATE FUNCTION1754GRANT1755CREATE ROLE1756GRANT1757GRANT1758GRANT1759ALTER ROLE1760ALTER TABLE1761ALTER TABLE1762ALTER TABLE1763ALTER TABLE1764ALTER TABLE1765Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/init-scripts/00000000000002-storage-schema.sql1766CREATE SCHEMA1767CREATE ROLE1768ALTER ROLE1769GRANT1770DO1771Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/init-scripts/00000000000003-post-setup.sql1772ALTER ROLE1773ALTER ROLE1774CREATE FUNCTION1775CREATE EVENT TRIGGER1776COMMENT1777CREATE FUNCTION1778COMMENT1779DO1780CREATE ROLE1781GRANT1782GRANT1783GRANT1784GRANT1785GRANT1786GRANT1787GRANT1788GRANT1789GRANT1790DO1791NOTICE: empty string is not a valid password, clearing password1792ALTER ROLE1793CREATE ROLE1794REVOKE1795CREATE SCHEMA1796CREATE FUNCTION1797REVOKE1798GRANT1799psql:/nix/store/0s4wf39csywl7iy2bchhiaqzcinrk17w-stat-extension:1: NOTICE: schema "extensions" already exists, skipping1800CREATE SCHEMA1801CREATE EXTENSION1802Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/10000000000000_demote-postgres.sql1803GRANT1804GRANT1805GRANT1806GRANT1807GRANT1808GRANT1809GRANT1810GRANT1811GRANT1812DO1813ALTER ROLE1814Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20211115181400_update-auth-permissions.sql1815GRANT1816GRANT1817GRANT1818ALTER TABLE1819ALTER TABLE1820ALTER TABLE1821ALTER TABLE1822ALTER TABLE1823GRANT1824GRANT1825GRANT1826GRANT1827ALTER DEFAULT PRIVILEGES1828ALTER DEFAULT PRIVILEGES1829ALTER DEFAULT PRIVILEGES1830Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20211118015519_create-realtime-schema.sql1831CREATE SCHEMA1832Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20211122051245_update-realtime-permissions.sql1833GRANT1834GRANT1835GRANT1836GRANT1837Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20211124212715_update-auth-owner.sql1838DO1839DO1840DO1841Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20211130151719_update-realtime-permissions.sql1842ALTER DEFAULT PRIVILEGES1843ALTER DEFAULT PRIVILEGES1844ALTER DEFAULT PRIVILEGES1845Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220118070449_enable-safeupdate-postgrest.sql1846ALTER ROLE1847Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220126121436_finer-postgrest-triggers.sql1848psql:/nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220126121436_finer-postgrest-triggers.sql:3: NOTICE: event trigger "api_restart" does not exist, skipping1849DROP EVENT TRIGGER1850psql:/nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220126121436_finer-postgrest-triggers.sql:4: NOTICE: function extensions.notify_api_restart() does not exist, skipping1851DROP FUNCTION1852CREATE FUNCTION1853CREATE FUNCTION1854psql:/nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220126121436_finer-postgrest-triggers.sql:59: NOTICE: event trigger "pgrst_ddl_watch" does not exist, skipping1855DROP EVENT TRIGGER1856CREATE EVENT TRIGGER1857psql:/nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220126121436_finer-postgrest-triggers.sql:64: NOTICE: event trigger "pgrst_drop_watch" does not exist, skipping1858DROP EVENT TRIGGER1859CREATE EVENT TRIGGER1860Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220224211803_fix-postgrest-supautils.sql1861DO1862Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220317095840_pg_graphql.sql1863CREATE SCHEMA1864psql:/nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220317095840_pg_graphql.sql:5: NOTICE: function graphql_public.graphql(text,text,jsonb) does not exist, skipping1865DROP FUNCTION1866CREATE FUNCTION1867GRANT1868ALTER DEFAULT PRIVILEGES1869ALTER DEFAULT PRIVILEGES1870ALTER DEFAULT PRIVILEGES1871ALTER DEFAULT PRIVILEGES1872ALTER DEFAULT PRIVILEGES1873ALTER DEFAULT PRIVILEGES1874CREATE FUNCTION1875psql:/nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220317095840_pg_graphql.sql:90: NOTICE: event trigger "issue_pg_graphql_access" does not exist, skipping1876DROP EVENT TRIGGER1877CREATE EVENT TRIGGER1878COMMENT1879CREATE FUNCTION1880psql:/nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220317095840_pg_graphql.sql:143: NOTICE: event trigger "issue_graphql_placeholder" does not exist, skipping1881DROP EVENT TRIGGER1882CREATE EVENT TRIGGER1883COMMENT1884Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220321174452_fix-postgrest-alter-type-event-trigger.sql1885psql:/nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220321174452_fix-postgrest-alter-type-event-trigger.sql:3: NOTICE: event trigger "api_restart" does not exist, skipping1886DROP EVENT TRIGGER1887psql:/nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220321174452_fix-postgrest-alter-type-event-trigger.sql:4: NOTICE: function extensions.notify_api_restart() does not exist, skipping1888DROP FUNCTION1889CREATE FUNCTION1890CREATE FUNCTION1891DROP EVENT TRIGGER1892CREATE EVENT TRIGGER1893DROP EVENT TRIGGER1894CREATE EVENT TRIGGER1895Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220322085208_gotrue-session-limit.sql1896ALTER ROLE1897Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220404205710_pg_graphql-on-by-default.sql1898CREATE FUNCTION1899CREATE FUNCTION1900CREATE FUNCTION1901psql:/nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220404205710_pg_graphql-on-by-default.sql:142: NOTICE: extension "pg_graphql" does not exist, skipping1902DROP EXTENSION1903DO1904Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220609081115_grant-supabase-auth-admin-and-supabase-storage-admin-to-postgres.sql1905GRANT ROLE1906Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220613123923_pg_graphql-pg-dump-perms.sql1907CREATE FUNCTION1908DROP EXTENSION1909DO1910Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20220713082019_pg_cron-pg_net-temp-perms-fix.sql1911DO1912DO1913Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20221028101028_set_authenticator_timeout.sql1914ALTER ROLE1915Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20221103090837_revoke_admin.sql1916REVOKE ROLE1917Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20221207154255_create_pgsodium_and_vault.sql1918DO1919Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20230201083204_grant_auth_roles_to_postgres.sql1920GRANT ROLE1921Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20230224042246_grant_extensions_perms_for_postgres.sql1922GRANT1923GRANT1924GRANT1925ALTER DEFAULT PRIVILEGES1926ALTER DEFAULT PRIVILEGES1927ALTER DEFAULT PRIVILEGES1928Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20230306081037_grant_pg_monitor_to_postgres.sql1929GRANT ROLE1930Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20230327032006_grant_auth_roles_to_supabase_storage_admin.sql1931GRANT ROLE1932Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20230529180330_alter_api_roles_for_inherit.sql1933ALTER ROLE1934ALTER ROLE1935ALTER ROLE1936DO1937Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20231013070755_grant_authenticator_to_supabase_storage_admin.sql1938GRANT ROLE1939REVOKE ROLE1940Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20231017062225_grant_pg_graphql_permissions_for_custom_roles.sql1941CREATE FUNCTION1942DROP EXTENSION1943DO1944Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20231020085357_revoke_writes_on_cron_job_from_postgres.sql1945DO1946CREATE FUNCTION1947DROP EVENT TRIGGER1948ALTER FUNCTION1949CREATE EVENT TRIGGER1950Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20231130133139_set_lock_timeout_to_authenticator_role.sql1951ALTER ROLE1952Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20240124080435_alter_lo_export_lo_import_owner.sql1953ALTER FUNCTION1954ALTER FUNCTION1955ALTER FUNCTION1956Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20240606060239_grant_predefined_roles_to_postgres.sql1957GRANT ROLE1958Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20241031003909_create_orioledb.sql1959DO1960Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20241215003910_backfill_pgmq_metadata.sql1961DO1962DO1963Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20250205060043_disable_log_statement_on_internal_roles.sql1964ALTER ROLE1965ALTER ROLE1966ALTER ROLE1967Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20250205144616_move_orioledb_to_extensions_schema.sql1968DO1969Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20250218031949_pgsodium_mask_role.sql1970DO1971Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20250220051611_pg_net_perms_fix.sql1972CREATE FUNCTION1973DO1974Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20250312095419_pgbouncer_ownership.sql1975ALTER FUNCTION1976GRANT1977Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20250402065937_alter_internal_event_triggers_owner_to_supabase_admin.sql1978DROP EVENT TRIGGER1979ALTER FUNCTION1980CREATE EVENT TRIGGER1981Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20250402093753_grant_subscription_to_postgres_16_and_above.sql1982DO1983Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20250417190610_update_pgbouncer_get_auth.sql1984CREATE FUNCTION1985GRANT1986Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20250421084701_revoke_admin_roles_from_postgres.sql1987REVOKE ROLE1988DO1989DO1990REVOKE ROLE1991REVOKE1992DO1993Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20250605172253_grant_with_admin_to_postgres_16_and_above.sql1994DO1995Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20250623125453_tmp_grant_storage_tables_to_postgres_with_grant_option.sql1996DO1997Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20250709135250_grant_storage_schema_to_postgres_with_grant_option.sql1998DO1999Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20250710151649_supabase_read_only_user_default_transaction_read_only.sql2000ALTER ROLE2001Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20251001204436_predefined_role_grants.sql2002GRANT ROLE2003DO2004Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20251105172723_grant_pg_reload_conf_to_postgres.sql2005GRANT2006Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20251121132723_correct_search_path_pgbouncer.sql2007CREATE FUNCTION2008REVOKE2009REVOKE2010GRANT2011Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20260211120934_supabase_privileged_role.sql2012DO2013Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20260413000000_fix-authenticator-session-preload-libraries.sql2014ALTER ROLE2015Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20260421000000_pg_graphql-off-by-default.sql2016DROP EXTENSION2017Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20260421000001_rescope_pg_graphql_access_trigger.sql2018CREATE FUNCTION2019DROP EVENT TRIGGER2020CREATE EVENT TRIGGER2021Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20260730000000_revoke_trigger_on_cron_tables_from_postgres.sql2022DO2023CREATE FUNCTION2024Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20260923021047_update_pgrst_watch_triggers.sql2025CREATE FUNCTION2026CREATE FUNCTION2027Running /nix/store/qi8wy6sa24cr7jg4vqq6bcd3wpgwlanf-migrations/migrations/20261016000001_search_path_for_supa_functions.sql2028CREATE FUNCTION2029CREATE FUNCTION2030CREATE FUNCTION2031CREATE FUNCTION2032CREATE FUNCTION2033CREATE FUNCTION2034ALTER DATABASE2035ALTER DATABASE2036ALTER ROLE2037ALTER ROLE2038ALTER ROLE2039ALTER ROLE2040ALTER ROLE2041ALTER ROLE2042ALTER ROLE2043ALTER ROLE2044ALTER ROLE2045ALTER ROLE2046Shutting down PostgreSQL...2047PostgreSQL is running in daemon mode. Please stop it using pg_ctl.2048pg_ctl: another server might be running; trying to start server anyway2049waiting for server to start.... stopped waiting2050pg_ctl: could not start server2051Examine the log output.2052pg_ctl: server is running (PID: 1213)2053/nix/store/9cgb3iwg25krw3rchysinlgn6bvh36kc-postgresql-and-plugins-17.11/bin/postgres "-D" "/build/tmp.XSGBEY05Oo" "--config-file=/build/tmp.XSGBEY05Oo/postgresql.conf" "-p" "5541" "-k" "/build/tmp.XSGBEY05Oo/tmp"2054$ pg_isready -h localhost -p 5541 -U supabase_admin -q20552026-11-12 08:20:48 [INFO] PostgreSQL is ready20562026-11-12 08:20:48 [INFO] CLI variant detected - loading CLI prime SQL file2057$ psql -p 5541 -h localhost --no-password --username=supabase_admin -d postgres -v ON_ERROR_STOP=1 -Xf /nix/store/ib75j74vyc0w374jcz7mqcg6njf21yx3-prime-cli.sql2058SET2059CREATE EXTENSION2060CREATE EXTENSION2061CREATE EXTENSION2062CREATE EXTENSION20632026-11-12 08:20:48 [INFO] Creating test_config table for pg_regress tests2064$ psql -p 5541 -h localhost --no-password --username=supabase_admin -d postgres -c 2065 CREATE TABLE IF NOT EXISTS test_config (key TEXT PRIMARY KEY, value TEXT);2066 INSERT INTO test_config (key, value) VALUES ('http_mock_port', '8880')2067 ON CONFLICT (key) DO UPDATE SET value = EXCLUDED.value;2068 INSERT INTO test_config (key, value) VALUES ('http_mock_host', 'localhost')2069 ON CONFLICT (key) DO UPDATE SET value = EXCLUDED.value;20702071CREATE TABLE2072INSERT 0 12073INSERT 0 120742026-11-12 08:20:48 [INFO] CLI variant detected - running subset of pg_regress tests (38 tests)2075$ pg_regress --use-existing --dbname=postgres --inputdir=/nix/store/2zv8j39hdn149zi4v21mv4y85w1iplvr-tests --outputdir=/nix/store/dnq6b8q4il3lyz5pnlji0x3297rlbyyc-run-check-harness-psql-17-cli/regression_output --host=localhost --port=5541 --user=supabase_admin auth create_statistics_priv dblink docs-array-test docs-cascades-deletes docs-connections docs-enums docs-full-text-search docs-functions docs-indexes docs-json docs-partitioning docs-tables-and-data docs-triggers docs-webhooks enable_tracking event_trigger_search_path intarray_ltree_query ltree_label_overflow multirange_create_priv operator_breaking_change pg-safeupdate pg_graphql pg_net pg_plan_filter pgaudit pgbouncer pgcrypto_cipher_matrix pgsodium realtime replica_identity_upsert storage supautils_reserved_roles vault wal2json z_17_intarray_ltree_query z_17_supabase_monitor_admin z_17_wal_summarize2076(using postmaster on localhost, port 5541)2077============== running regression test queries ==============2078test auth ... ok 19 ms2079test create_statistics_priv ... ok 16 ms2080test dblink ... ok 58 ms2081test docs-array-test ... ok 18 ms2082test docs-cascades-deletes ... ok 154 ms2083test docs-connections ... ok 13 ms2084test docs-enums ... ok 58 ms2085test docs-full-text-search ... ok 48 ms2086test docs-functions ... ok 92 ms2087test docs-indexes ... ok 51 ms2088test docs-json ... ok 20 ms2089test docs-partitioning ... ok 50 ms2090test docs-tables-and-data ... ok 167 ms2091test docs-triggers ... ok 120 ms2092test docs-webhooks ... ok 99 ms2093test enable_tracking ... ok 14 ms2094test event_trigger_search_path ... ok 13 ms2095test intarray_ltree_query ... ok 99 ms2096test ltree_label_overflow ... ok 72 ms2097test multirange_create_priv ... ok 15 ms2098test operator_breaking_change ... ok 43 ms2099test pg-safeupdate ... ok 19 ms2100test pg_graphql ... ok 93 ms2101test pg_net ... ok 13 ms2102test pg_plan_filter ... ok 16 ms2103test pgaudit ... ok 21 ms2104test pgbouncer ... ok 32 ms2105test pgcrypto_cipher_matrix ... ok 32 ms2106test pgsodium ... ok 14 ms2107test realtime ... ok 10 ms2108test replica_identity_upsert ... ok 17 ms2109test storage ... ok 24 ms2110test supautils_reserved_roles ... ok 11 ms2111test vault ... ok 44 ms2112test wal2json ... ok 82 ms2113test z_17_intarray_ltree_query ... ok 65 ms2114test z_17_supabase_monitor_admin ... FAILED 33 ms2115test z_17_wal_summarize ... ok 11 ms21162117=======================2118 1 of 38 tests failed. 2119=======================21202121The differences that caused some tests to fail can be viewed in the2122file "/nix/store/dnq6b8q4il3lyz5pnlji0x3297rlbyyc-run-check-harness-psql-17-cli/regression_output/regression.diffs". A copy of the test summary that you see2123above is saved in the file "/nix/store/dnq6b8q4il3lyz5pnlji0x3297rlbyyc-run-check-harness-psql-17-cli/regression_output/regression.out".212421252026-11-12 08:20:50 [ERROR] pg_regress tests failed21262026-11-12 08:20:50 [ERROR] An error occurred. Exit code: 121272026-11-12 08:20:50 [ERROR] Debug logs: