run-check-harness-psql-17-cli
checks.x86_64-linux.psql_17_cli
· build #138
· raw
12026-10-06 18:38:10 [INFO] Starting HTTP mock server (will find free port)...22026-10-06 18:38:11 [INFO] HTTP mock server started on port 888032026-10-06 18:38:11 [INFO] Creating temporary PostgreSQL cluster at /build/tmp.ShNtjpUp1a42026-10-06 18:38:11 [INFO] Generated preload libraries: pg_cron, pg_net, pgsodium, supabase_vault52026-10-06 18:38:11 [INFO] Checking shared_preload_libraries setting:62026-10-06 18:38:11 [INFO] 721:shared_preload_libraries = 'pg_cron, pg_net, pgsodium, supabase_vault' # (change requires restart)72026-10-06 18:38:11 [INFO] Configuring local auth82026-10-06 18:38:11 [INFO] Waiting for PostgreSQL to be ready...92026-10-06 18:38:11 [INFO] PostgreSQL is ready102026-10-06 18:38:11 [INFO] Creating test database112026-10-06 18:38:12 [INFO] CLI variant detected - loading CLI prime SQL file122026-10-06 18:38:12 [INFO] Creating test_config table132026-10-06 18:38:12 [INFO] Running pgtap test: auth.sql142026-10-06 18:38:12 [INFO] Running pgtap test: create_statistics_priv.sql152026-10-06 18:38:12 [INFO] Running pgtap test: dblink.sql162026-10-06 18:38:12 [INFO] Running pgtap test: docs-array-test.sql172026-10-06 18:38:12 [INFO] Running pgtap test: docs-cascades-deletes.sql182026-10-06 18:38:12 [INFO] Running pgtap test: docs-connections.sql192026-10-06 18:38:12 [INFO] Running pgtap test: docs-enums.sql202026-10-06 18:38:12 [INFO] Running pgtap test: docs-full-text-search.sql212026-10-06 18:38:12 [INFO] Running pgtap test: docs-functions.sql222026-10-06 18:38:12 [INFO] Running pgtap test: docs-indexes.sql232026-10-06 18:38:12 [INFO] Running pgtap test: docs-json.sql242026-10-06 18:38:12 [INFO] Running pgtap test: docs-partitioning.sql252026-10-06 18:38:12 [INFO] Running pgtap test: docs-tables-and-data.sql262026-10-06 18:38:12 [INFO] Running pgtap test: docs-triggers.sql272026-10-06 18:38:12 [INFO] Running pgtap test: docs-webhooks.sql282026-10-06 18:38:12 [INFO] Running pgtap test: enable_tracking.sql292026-10-06 18:38:12 [INFO] Running pgtap test: intarray_ltree_query.sql302026-10-06 18:38:13 [INFO] Running pgtap test: ltree_label_overflow.sql312026-10-06 18:38:13 [INFO] Running pgtap test: multirange_create_priv.sql322026-10-06 18:38:13 [INFO] Running pgtap test: operator_breaking_change.sql332026-10-06 18:38:13 [INFO] Running pgtap test: pg-safeupdate.sql342026-10-06 18:38:13 [INFO] Running pgtap test: pg_graphql.sql352026-10-06 18:38:13 [INFO] Running pgtap test: pg_net.sql362026-10-06 18:38:13 [INFO] Running pgtap test: pg_plan_filter.sql372026-10-06 18:38:13 [INFO] Running pgtap test: pgaudit.sql382026-10-06 18:38:13 [INFO] Running pgtap test: pgbouncer.sql392026-10-06 18:38:13 [INFO] Running pgtap test: pgcrypto_cipher_matrix.sql402026-10-06 18:38:13 [INFO] Running pgtap test: pgsodium.sql412026-10-06 18:38:13 [INFO] Running pgtap test: realtime.sql422026-10-06 18:38:13 [INFO] Running pgtap test: replica_identity_upsert.sql432026-10-06 18:38:13 [INFO] Running pgtap test: storage.sql442026-10-06 18:38:13 [INFO] Running pgtap test: supautils_reserved_roles.sql452026-10-06 18:38:13 [INFO] Running pgtap test: vault.sql462026-10-06 18:38:13 [INFO] Running pgtap test: wal2json.sql472026-10-06 18:38:13 [INFO] Running pgtap test: z_17_intarray_ltree_query.sql482026-10-06 18:38:14 [INFO] Starting PostgreSQL server for pg_regress tests492026-10-06 18:38:17 [INFO] PostgreSQL is ready502026-10-06 18:38:17 [INFO] CLI variant detected - loading CLI prime SQL file512026-10-06 18:38:17 [ERROR] Error executing CLI prime SQL file522026-10-06 18:38:17 [ERROR] An error occurred. Exit code: 1532026-10-06 18:38:17 [ERROR] Debug logs:542026-10-06 18:38:10 [INFO] Starting HTTP mock server (will find free port)...55$ /nix/store/qzc04a3npl70cyyy6flnnrb2ig3kayxm-python3-3.13.11/bin/python3 /nix/store/sfl1mnhcw0ccky7m2crn0hda79clq4mk-http-mock-server.py562026-10-06 18:38:11 [INFO] HTTP mock server started on port 8880572026-10-06 18:38:11 [INFO] Creating temporary PostgreSQL cluster at /build/tmp.ShNtjpUp1a58$ initdb --locale=C --username=supabase_admin -D /build/tmp.ShNtjpUp1a59The files belonging to this database system will be owned by user "nixbld".60This user must also own the server process.6162The database cluster will be initialized with locale "C".63The default database encoding has accordingly been set to "SQL_ASCII".64The default text search configuration will be set to "english".6566Data page checksums are disabled.6768fixing permissions on existing directory /build/tmp.ShNtjpUp1a ... ok69creating subdirectories ... ok70selecting dynamic shared memory implementation ... posix71selecting default "max_connections" ... 10072selecting default "shared_buffers" ... 128MB73selecting default time zone ... UTC74creating configuration files ... ok75running bootstrap script ... ok76performing post-bootstrap initialization ... ok77syncing data to disk ... ok7879initdb: warning: enabling "trust" authentication for local connections80initdb: 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.8182Success. You can now start the database server using:8384 pg_ctl -D /build/tmp.ShNtjpUp1a -l logfile start85862026-10-06 18:38:11 [INFO] Generated preload libraries: pg_cron, pg_net, pgsodium, supabase_vault872026-10-06 18:38:11 [INFO] Checking shared_preload_libraries setting:882026-10-06 18:38:11 [INFO] 721:shared_preload_libraries = 'pg_cron, pg_net, pgsodium, supabase_vault' # (change requires restart)892026-10-06 18:38:11 [INFO] Configuring local auth90$ pg_ctl -D /build/tmp.ShNtjpUp1a -l /build/tmp.ShNtjpUp1a/postgresql.log -o -k /build/tmp.ShNtjpUp1a/sockets -p 5541 -d 5 start91waiting for server to start.... done92server started932026-10-06 18:38:11 [INFO] Waiting for PostgreSQL to be ready...94$ pg_isready -h localhost -p 5541 -U supabase_admin -q952026-10-06 18:38:11 [INFO] PostgreSQL is ready962026-10-06 18:38:11 [INFO] Creating test database97$ createdb -p 5541 -h localhost --username=supabase_admin testing982026-10-06 18:38:12 [INFO] CLI variant detected - loading CLI prime SQL file99$ psql -p 5541 -h localhost --username=supabase_admin -d testing -v ON_ERROR_STOP=1 -Xf /nix/store/ib75j74vyc0w374jcz7mqcg6njf21yx3-prime-cli.sql100SET101CREATE EXTENSION102CREATE EXTENSION103CREATE EXTENSION104CREATE EXTENSION1052026-10-06 18:38:12 [INFO] Creating test_config table106$ psql -p 5541 -h localhost --username=supabase_admin -d testing -c 107 CREATE TABLE IF NOT EXISTS test_config (key TEXT PRIMARY KEY, value TEXT);108 INSERT INTO test_config (key, value) VALUES ('http_mock_port', '8880')109 ON CONFLICT (key) DO UPDATE SET value = EXCLUDED.value;110 INSERT INTO test_config (key, value) VALUES ('http_mock_host', 'localhost')111 ON CONFLICT (key) DO UPDATE SET value = EXCLUDED.value;112113CREATE TABLE114INSERT 0 1115INSERT 0 11162026-10-06 18:38:12 [INFO] Running pgtap test: auth.sql117$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/auth.sql118 schema_name | owner 119-------------+-------120(0 rows)121122 schema_name | table_name | owner | rls_enabled | rls_policies 123-------------+------------+-------+-------------+--------------124(0 rows)125126 schema_name | table_name | role_name | privilege_type | is_grantable 127-------------+------------+-----------+----------------+--------------128(0 rows)129130 table_schema | table_name | index_name | index_owner 131--------------+------------+------------+-------------132(0 rows)133134 schema_name | function_name | owner 135-------------+---------------+-------136(0 rows)137138psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/auth.sql:97: ERROR: relation "auth.schema_migrations" does not exist139LINE 1: select * from auth.schema_migrations;140 ^1412026-10-06 18:38:12 [INFO] Running pgtap test: create_statistics_priv.sql142$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/create_statistics_priv.sql143BEGIN144CREATE SCHEMA145CREATE SCHEMA146psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/create_statistics_priv.sql:15: ERROR: role "postgres" does not exist147psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/create_statistics_priv.sql:17: ERROR: current transaction is aborted, commands ignored until end of transaction block148psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/create_statistics_priv.sql:20: ERROR: current transaction is aborted, commands ignored until end of transaction block149psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/create_statistics_priv.sql:21: ERROR: current transaction is aborted, commands ignored until end of transaction block150psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/create_statistics_priv.sql:24: ERROR: current transaction is aborted, commands ignored until end of transaction block151psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/create_statistics_priv.sql:27: ERROR: current transaction is aborted, commands ignored until end of transaction block152psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/create_statistics_priv.sql:28: ERROR: current transaction is aborted, commands ignored until end of transaction block153psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/create_statistics_priv.sql:29: ERROR: savepoint "no_priv" does not exist154psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/create_statistics_priv.sql:31: ERROR: current transaction is aborted, commands ignored until end of transaction block155ROLLBACK1562026-10-06 18:38:12 [INFO] Running pgtap test: dblink.sql157$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/dblink.sql158SET159DROP EXTENSION160psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/dblink.sql:10: ERROR: role "postgres" does not exist161CREATE TABLE162CREATE EXTENSION163DROP TABLE164RESET165 function_name | grantee | privilege_type 166-----------------------------+----------------+----------------167 dblink_connect_u(text) | supabase_admin | EXECUTE168 dblink_connect_u(text,text) | supabase_admin | EXECUTE169(2 rows)170171psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/dblink.sql:28: ERROR: role "postgres" does not exist172 search_path 173-----------------174 "$user", public175(1 row)176177DROP EXTENSION178CREATE EXTENSION1792026-10-06 18:38:12 [INFO] Running pgtap test: docs-array-test.sql180$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-array-test.sql181CREATE TABLE182INSERT 0 1183 id | textarray 184----+-------------------185 1 | {Harry,Larry,Moe}186(1 row)187188 textarray | array_length 189-----------+--------------190 Harry | 3191(1 row)192193DROP TABLE1942026-10-06 18:38:12 [INFO] Running pgtap test: docs-cascades-deletes.sql195$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-cascades-deletes.sql196CREATE TABLE197CREATE TABLE198CREATE TABLE199INSERT 0 1200INSERT 0 1201INSERT 0 1202INSERT 0 1203 count 204-------205 1206(1 row)207208 count 209-------210 2211(1 row)212213 count 214-------215 1216(1 row)217218psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-cascades-deletes.sql:47: ERROR: update or delete on table "parent" violates foreign key constraint "child_father_fkey" on table "child"219DETAIL: Key (id)=(1) is still referenced from table "child".220 count 221-------222 1223(1 row)224225 count 226-------227 2228(1 row)229230 count 231-------232 1233(1 row)234235psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-cascades-deletes.sql:56: ERROR: duplicate key value violates unique constraint "grandparent_pkey"236DETAIL: Key (id)=(1) already exists.237psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-cascades-deletes.sql:61: ERROR: duplicate key value violates unique constraint "parent_pkey"238DETAIL: Key (id)=(1) already exists.239psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-cascades-deletes.sql:66: ERROR: duplicate key value violates unique constraint "parent_pkey"240DETAIL: Key (id)=(2) already exists.241psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-cascades-deletes.sql:71: ERROR: duplicate key value violates unique constraint "child_pkey"242DETAIL: Key (id)=(1) already exists.243ALTER TABLE244ALTER TABLE245psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-cascades-deletes.sql:80: ERROR: update or delete on table "parent" violates foreign key constraint "child_father_fkey" on table "child"246DETAIL: Key (id)=(1) is still referenced from table "child".247 count 248-------249 1250(1 row)251252 count 253-------254 2255(1 row)256257 count 258-------259 1260(1 row)261262psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-cascades-deletes.sql:89: ERROR: duplicate key value violates unique constraint "grandparent_pkey"263DETAIL: Key (id)=(1) already exists.264psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-cascades-deletes.sql:94: ERROR: duplicate key value violates unique constraint "parent_pkey"265DETAIL: Key (id)=(1) already exists.266psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-cascades-deletes.sql:99: ERROR: duplicate key value violates unique constraint "parent_pkey"267DETAIL: Key (id)=(2) already exists.268psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-cascades-deletes.sql:104: ERROR: duplicate key value violates unique constraint "child_pkey"269DETAIL: Key (id)=(1) already exists.270ALTER TABLE271ALTER TABLE272psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-cascades-deletes.sql:113: ERROR: update or delete on table "parent" violates foreign key constraint "child_father_fkey" on table "child"273DETAIL: Key (id)=(1) is still referenced from table "child".274 count 275-------276 1277(1 row)278279 count 280-------281 2282(1 row)283284 count 285-------286 1287(1 row)288289psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-cascades-deletes.sql:122: ERROR: duplicate key value violates unique constraint "grandparent_pkey"290DETAIL: Key (id)=(1) already exists.291psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-cascades-deletes.sql:127: ERROR: duplicate key value violates unique constraint "parent_pkey"292DETAIL: Key (id)=(1) already exists.293psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-cascades-deletes.sql:132: ERROR: duplicate key value violates unique constraint "parent_pkey"294DETAIL: Key (id)=(2) already exists.295psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-cascades-deletes.sql:137: ERROR: duplicate key value violates unique constraint "child_pkey"296DETAIL: Key (id)=(1) already exists.297ALTER TABLE298UPDATE 1299DELETE 1300 count 301-------302 0303(1 row)304305 count 306-------307 0308(1 row)309310 count 311-------312 0313(1 row)314315CREATE TABLE316CREATE TABLE317INSERT 0 1318INSERT 0 1319DELETE 1320 count 321-------322 0323(1 row)324325 count 326-------327 0328(1 row)329330CREATE TABLE331CREATE TABLE332INSERT 0 1333INSERT 0 1334psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-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"335DETAIL: Key (id)=(1) is still referenced from table "test_restrict_child".336 count 337-------338 1339(1 row)340341 count 342-------343 1344(1 row)345346CREATE TABLE347CREATE TABLE348INSERT 0 1349INSERT 0 1350DELETE 1351 count 352-------353 0354(1 row)355356 count 357-------358 1359(1 row)360361 parent_id 362-----------363 364(1 row)365366CREATE TABLE367CREATE TABLE368INSERT 0 1369INSERT 0 1370psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-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"371DETAIL: Key (parent_id)=(999) is not present in table "test_set_default".372 count 373-------374 1375(1 row)376377 count 378-------379 1380(1 row)381382 parent_id 383-----------384 1385(1 row)386387CREATE TABLE388CREATE TABLE389INSERT 0 1390INSERT 0 1391psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-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"392DETAIL: Key (id)=(1) is still referenced from table "test_no_action_child".393 count 394-------395 1396(1 row)397398 count 399-------400 1401(1 row)402403DROP TABLE404DROP TABLE405DROP TABLE406DROP TABLE407DROP TABLE408DROP TABLE409DROP TABLE410DROP TABLE411DROP TABLE412DROP TABLE413DROP TABLE414DROP TABLE415DROP TABLE4162026-10-06 18:38:12 [INFO] Running pgtap test: docs-connections.sql417$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-connections.sql418 ssl | database | connected_role | application_name | query | state 419-----+----------+----------------+------------------+--------------------------------------------+--------420 f | testing | supabase_admin | psql | select +| active421 | | | | ssl, +| 422 | | | | datname as database, +| 423 | | | | usename as connected_role, +| 424 | | | | application_name, +| 425 | | | | query, +| 426 | | | | state +| 427 | | | | from pg_stat_ssl +| 428 | | | | join pg_stat_activity +| 429 | | | | on pg_stat_ssl.pid = pg_stat_activity.pid; | 430(1 row)4314322026-10-06 18:38:12 [INFO] Running pgtap test: docs-enums.sql433$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-enums.sql434CREATE TYPE435CREATE TABLE436INSERT 0 1437INSERT 0 1438INSERT 0 1439 id | name | current_mood 440----+------+--------------441 2 | Bob | sad442(1 row)443444 id | name | current_mood 445----+-------+--------------446 1 | Alice | happy447(1 row)448449UPDATE 1450 id | name | current_mood 451----+-------+--------------452 1 | Alice | excited453(1 row)454455ALTER TYPE456INSERT 0 1457 enum_range 458----------------------------------459 {happy,sad,excited,calm,content}460(1 row)461462 id | name | current_mood 463----+-------+--------------464 4 | David | content465(1 row)466467CREATE TYPE468CREATE TABLE469INSERT 0 3470 id | order_number | status 471----+--------------+--------472 1 | ORD-001 | active473(1 row)474475UPDATE 1476 id | order_number | status 477----+--------------+----------478 2 | ORD-002 | inactive479(1 row)480481ALTER TYPE482INSERT 0 1483 enum_range 484-------------------------------------485 {active,inactive,pending,cancelled}486(1 row)487488 id | order_number | status 489----+--------------+-----------490 4 | ORD-004 | cancelled491(1 row)492493CREATE TYPE494CREATE TABLE495INSERT 0 3496 id | title | priority 497----+----------------+----------498 3 | Security audit | critical499(1 row)500501UPDATE 1502 id | title | priority 503----+-------------+----------504 2 | Update docs | medium505(1 row)506507ALTER TYPE508INSERT 0 1509 enum_range 510-----------------------------------511 {low,medium,high,critical,urgent}512(1 row)513514 id | title | priority 515----+--------------------+----------516 4 | Server maintenance | urgent517(1 row)518519DROP TABLE520DROP TABLE521DROP TABLE522DROP TYPE523DROP TYPE524DROP TYPE5252026-10-06 18:38:12 [INFO] Running pgtap test: docs-full-text-search.sql526$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-full-text-search.sql527CREATE TABLE528INSERT 0 5529 to_tsvector 530---------------------------531 'egg':2 'green':1 'ham':4532(1 row)533534 to_tsvector 535---------------------------536 'egg':2 'green':1 'ham':4537(1 row)538539 id | title | author | description 540----+-------+--------+-------------541(0 rows)542543 id | title | author | description 544----+-------------------------------------+--------------+-------------------------------------------------545 5 | Harry Potter and the Goblet of Fire | J.K. Rowling | Fourth year of school starts, big drama ensues.546(1 row)547548 id | title | author | description 549----+-------------------------------------+-------------------+-------------------------------------------------550 3 | Tootle | Gertrude Crampton | Little toy train has big dreams.551 5 | Harry Potter and the Goblet of Fire | J.K. Rowling | Fourth year of school starts, big drama ensues.552(2 rows)553554 id | title | author | description 555----+-----------------------+------------------------+---------------------------------------------556 1 | The Poky Little Puppy | Janette Sebring Lowrey | Puppy is slower than other, bigger animals.557 3 | Tootle | Gertrude Crampton | Little toy train has big dreams.558(2 rows)559560CREATE FUNCTION561 id | title | author | description 562----+-----------------------+------------------------+---------------------------------------------563 1 | The Poky Little Puppy | Janette Sebring Lowrey | Puppy is slower than other, bigger animals.564 3 | Tootle | Gertrude Crampton | Little toy train has big dreams.565(2 rows)566567 id | title | author | description 568----+--------+-------------------+----------------------------------569 3 | Tootle | Gertrude Crampton | Little toy train has big dreams.570(1 row)571572 id | title | author | description 573----+-------------------------------------+-------------------+-------------------------------------------------574 3 | Tootle | Gertrude Crampton | Little toy train has big dreams.575 5 | Harry Potter and the Goblet of Fire | J.K. Rowling | Fourth year of school starts, big drama ensues.576(2 rows)577578 title 579-----------------------580 The Poky Little Puppy581(1 row)582583CREATE FUNCTION584 id | title | author | description 585----+-----------------------+------------------------+---------------------------------------------586 1 | The Poky Little Puppy | Janette Sebring Lowrey | Puppy is slower than other, bigger animals.587(1 row)588589 id | title | author | description 590----+-----------------------+------------------------+---------------------------------------------591 1 | The Poky Little Puppy | Janette Sebring Lowrey | Puppy is slower than other, bigger animals.592(1 row)593594ALTER TABLE595CREATE INDEX596 id | fts 597----+-----------------------------------------------------------------------------------------------------------------598 1 | 'anim':7 'bigger':6 'littl':10 'poki':9 'puppi':1,11 'slower':3599 2 | 'eat':2 'peter':8 'rabbit':1,9 'tale':6 'veget':4600 3 | 'big':5 'dream':6 'littl':1 'tootl':7 'toy':2 'train':3601 4 | 'chang':3 'color':9 'eat':7 'egg':12 'food':4,10 'green':11 'ham':14 'prefer':5 'sam':1 'unusu':8602 5 | 'big':6 'drama':7 'ensu':8 'fire':15 'fourth':1 'goblet':13 'harri':9 'potter':10 'school':4 'start':5 'year':2603(5 rows)604605 id | title | author | description | fts 606----+--------+-------------------+----------------------------------+---------------------------------------------------------607 3 | Tootle | Gertrude Crampton | Little toy train has big dreams. | 'big':5 'dream':6 'littl':1 'tootl':7 'toy':2 'train':3608(1 row)609610 id | title | author | description | fts 611----+--------+-------------------+----------------------------------+---------------------------------------------------------612 3 | Tootle | Gertrude Crampton | Little toy train has big dreams. | 'big':5 'dream':6 'littl':1 'tootl':7 'toy':2 'train':3613(1 row)614615 id | title | author | description | fts 616----+-------------------------------------+--------------+-------------------------------------------------+-----------------------------------------------------------------------------------------------------------------617 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':2618(1 row)619620 id | title | author | description | fts 621----+-------------------------------------+--------------+-------------------------------------------------+-----------------------------------------------------------------------------------------------------------------622 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':2623(1 row)624625 id | title | author | description | fts 626----+-------------------------------------+--------------+-------------------------------------------------+-----------------------------------------------------------------------------------------------------------------627 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':2628(1 row)629630 id | title | author | description | fts 631----+--------------------+-----------+--------------------------------------------------------------------+---------------------------------------------------------------------------------------------------632 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':8633(1 row)634635 id | title | author | description | fts 636----+--------+-------------------+----------------------------------+---------------------------------------------------------637 3 | Tootle | Gertrude Crampton | Little toy train has big dreams. | 'big':5 'dream':6 'littl':1 'tootl':7 'toy':2 'train':3638(1 row)639640 id | title | author | description | fts 641----+-------+--------+-------------+-----642(0 rows)643644 id | title | author | description | fts 645----+--------------------------+----------------+------------------------------+---------------------------------------------------646 2 | The Tale of Peter Rabbit | Beatrix Potter | Rabbit eats some vegetables. | 'eat':2 'peter':8 'rabbit':1,9 'tale':6 'veget':4647(1 row)648649 id | title | author | description | fts 650----+-------------------------------------+--------------+-------------------------------------------------+-----------------------------------------------------------------------------------------------------------------651 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':2652(1 row)653654 id | title | author | description | fts 655----+-------+--------+-------------+-----656(0 rows)657658 id | title | author | description | fts 659----+--------+-------------------+----------------------------------+---------------------------------------------------------660 3 | Tootle | Gertrude Crampton | Little toy train has big dreams. | 'big':5 'dream':6 'littl':1 'tootl':7 'toy':2 'train':3661(1 row)662663DROP FUNCTION664DROP FUNCTION665DROP TABLE6662026-10-06 18:38:12 [INFO] Running pgtap test: docs-functions.sql667$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-functions.sql668CREATE FUNCTION669 hello_world 670-------------671 hello world672(1 row)673674CREATE TABLE675INSERT 0 3676CREATE TABLE677INSERT 0 4678CREATE FUNCTION679 id | name 680----+----------681 1 | Tattoine682(1 row)683684CREATE FUNCTION685psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-functions.sql:64: ERROR: duplicate key value violates unique constraint "planets_pkey"686DETAIL: Key (id)=(1) already exists.687CONTEXT: SQL statement "insert into planets(name)688 values (add_planet.name)689 returning id"690PL/pgSQL function add_planet(text) line 5 at SQL statement691CREATE FUNCTION692 hello_world_definer 693---------------------694 hello world695(1 row)696697REVOKE698psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-functions.sql:79: ERROR: role "anon" does not exist699psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-functions.sql:81: ERROR: role "authenticated" does not exist700REVOKE701psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-functions.sql:84: ERROR: role "anon" does not exist702ALTER DEFAULT PRIVILEGES703psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-functions.sql:87: ERROR: role "anon" does not exist704psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-functions.sql:89: ERROR: role "authenticated" does not exist705CREATE FUNCTION706psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-functions.sql:106: WARNING: logging warning: WARNING MESSAGE707psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-functions.sql:106: ERROR: logging error: ERROR MESSAGE708CONTEXT: PL/pgSQL function logging_example(text,text,text) line 5 at RAISE709CREATE FUNCTION710 error_if_null 711---------------712 not null713(1 row)714715CREATE TABLE716INSERT 0 1717CREATE FUNCTION718 assert_example 719--------------------------------------720 123e4567-e89b-12d3-a456-426614174000721(1 row)722723CREATE FUNCTION724psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-functions.sql:162: ERROR: An error occurred in function <function name>: relation "table_that_does_not_exist" does not exist725CONTEXT: PL/pgSQL function error_example() line 7 at RAISE726CREATE TABLE727INSERT 0 1728CREATE FUNCTION729 advanced_example 730------------------731 42,new val732(1 row)733734DROP FUNCTION735DROP FUNCTION736DROP FUNCTION737DROP FUNCTION738DROP FUNCTION739DROP FUNCTION740DROP FUNCTION741DROP FUNCTION742DROP FUNCTION743DROP TABLE744DROP TABLE745DROP TABLE746DROP TABLE747GRANT748psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-functions.sql:221: ERROR: role "anon" does not exist749ALTER DEFAULT PRIVILEGES750psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-functions.sql:224: ERROR: role "anon" does not exist7512026-10-06 18:38:12 [INFO] Running pgtap test: docs-indexes.sql752$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-indexes.sql753CREATE TABLE754INSERT 0 1755 name 756----------757 John Doe758(1 row)759760CREATE INDEX761CREATE INDEX762CREATE INDEX763REINDEX764REINDEX765DROP TABLE7662026-10-06 18:38:12 [INFO] Running pgtap test: docs-json.sql767$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-json.sql768CREATE TABLE769INSERT 0 5770 title | description | price | low_age | high_age 771-------------------------------------+--------------------------------------------------------------------+-------+---------+----------772 The Poky Little Puppy | Puppy is slower than other, bigger animals. | 5.95 | 3 | 6773 The Tale of Peter Rabbit | Rabbit eats some vegetables. | 4.49 | 2 | 5774 Tootle | Little toy train has big dreams. | 3.99 | 2 | 5775 Green Eggs and Ham | Sam has changing food preferences and eats unusually colored food. | 7.49 | 4 | 8776 Harry Potter and the Goblet of Fire | Fourth year of school starts, big drama ensues. | 24.95 | 10 | 99777(5 rows)778779DROP TABLE7802026-10-06 18:38:12 [INFO] Running pgtap test: docs-partitioning.sql781$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-partitioning.sql782CREATE TABLE783CREATE TABLE784CREATE TABLE785INSERT 0 4786 id | order_date | customer_id | amount 787----+------------+-------------+--------788 1 | 2000-01-15 | 1 | 100789 2 | 2000-01-20 | 2 | 200790 3 | 2000-02-10 | 3 | 150791 4 | 2000-02-25 | 4 | 300792(4 rows)793794 id | order_date | customer_id | amount 795----+------------+-------------+--------796 3 | 2000-02-10 | 3 | 150797 4 | 2000-02-25 | 4 | 300798(2 rows)799800DROP TABLE801CREATE TABLE802CREATE TABLE803CREATE TABLE804INSERT 0 5805 id | name | country 806----+------------+---------807 1 | John Doe | US808 2 | Jane Smith | CANADA809(2 rows)810811 id | name | country 812----+-------------+---------813 3 | Li Wei | CHINA814 4 | Priya Patel | INDIA815 5 | Yuki Tanaka | JAPAN816(3 rows)817818DROP TABLE819CREATE TABLE820CREATE TABLE821CREATE TABLE822INSERT 0 4823 id | name | category | price 824----+--------+-------------+-------825 1 | Laptop | Electronics | 999826 2 | Phone | Electronics | 599827(2 rows)828829 count 830-------831 2832(1 row)833834 count 835-------836 2837(1 row)838839DROP TABLE8402026-10-06 18:38:12 [INFO] Running pgtap test: docs-tables-and-data.sql841$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-tables-and-data.sql842CREATE TABLE843 table_name | column_name | data_type | is_nullable | column_default 844------------+-------------+-----------+-------------+----------------845 movies | id | bigint | NO | 846 movies | name | text | YES | 847 movies | description | text | YES | 848(3 rows)849850DROP TABLE851CREATE TABLE852 column_name | data_type | is_nullable | column_default | is_identity | identity_generation 853-------------+-----------+-------------+----------------+-------------+---------------------854 id | bigint | NO | | YES | ALWAYS855(1 row)856857DROP TABLE858CREATE TABLE859 column_name | data_type | is_nullable | column_default | is_identity | identity_generation 860-------------+-----------+-------------+----------------+-------------+---------------------861 id | bigint | NO | | YES | BY DEFAULT862(1 row)863864DROP TABLE865CREATE TABLE866INSERT 0 2867 id | name | description 868----+-------------------------+--------------------------------------------------------------------------------------------------------------------------------869 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.870 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.871(2 rows)872873DROP TABLE874psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-tables-and-data.sql:57: NOTICE: table "categories" does not exist, skipping875DROP TABLE876CREATE TABLE877CREATE TABLE878ALTER TABLE879 table_name | column_name | foreign_table_name | foreign_column_name 880------------+-------------+--------------------+---------------------881 movies | category_id | categories | id882(1 row)883884psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-tables-and-data.sql:89: NOTICE: table "performances" does not exist, skipping885DROP TABLE886psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-tables-and-data.sql:90: NOTICE: table "actors" does not exist, skipping887DROP TABLE888DROP TABLE889CREATE TABLE890CREATE TABLE891CREATE TABLE892 table_name 893--------------894 actors895 movies896 performances897(3 rows)898899CREATE SCHEMA900 schema_name 901-------------902 private903(1 row)904905psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-tables-and-data.sql:120: NOTICE: table "salaries" does not exist, skipping906DROP TABLE907psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-tables-and-data.sql:121: NOTICE: drop cascades to constraint performances_actor_id_fkey on table performances908DROP TABLE909CREATE TABLE910CREATE TABLE911 table_schema | table_name 912--------------+------------913 private | salaries914(1 row)915916psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-tables-and-data.sql:137: NOTICE: table "grades" does not exist, skipping917DROP TABLE918psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-tables-and-data.sql:138: NOTICE: table "courses" does not exist, skipping919DROP TABLE920psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-tables-and-data.sql:139: NOTICE: table "students" does not exist, skipping921DROP TABLE922psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-tables-and-data.sql:140: NOTICE: view "transcripts" does not exist, skipping923DROP VIEW924CREATE TABLE925CREATE TABLE926CREATE TABLE927INSERT 0 3928INSERT 0 3929INSERT 0 6930CREATE VIEW931psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-tables-and-data.sql:192: ERROR: role "authenticated" does not exist932 name | type | title | code | result 933------------------+---------------+--------------------------+---------+--------934 Anakin Skywalker | graduate | Authentication Theories | AUTH205 | A935 Anakin Skywalker | graduate | Introduction to Postgres | PG101 | A-936 Anakin Skywalker | graduate | Fundamentals of Supabase | SUP412 | B-937 Princess Leia | undergraduate | Introduction to Postgres | PG101 | B+938 Princess Leia | undergraduate | Fundamentals of Supabase | SUP412 | A+939 Yoda | graduate | Authentication Theories | AUTH205 | A940(6 rows)941942psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-tables-and-data.sql:196: NOTICE: materialized view "transcripts_materialized" does not exist, skipping943DROP MATERIALIZED VIEW944SELECT 6945 name | type | title | code | result 946------------------+---------------+--------------------------+---------+--------947 Anakin Skywalker | graduate | Authentication Theories | AUTH205 | A948 Anakin Skywalker | graduate | Introduction to Postgres | PG101 | A-949 Anakin Skywalker | graduate | Fundamentals of Supabase | SUP412 | B-950 Princess Leia | undergraduate | Introduction to Postgres | PG101 | B+951 Princess Leia | undergraduate | Fundamentals of Supabase | SUP412 | A+952 Yoda | graduate | Authentication Theories | AUTH205 | A953(6 rows)954955REFRESH MATERIALIZED VIEW956 count 957-------958 6959(1 row)960961psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-tables-and-data.sql:217: NOTICE: view "secure_transcripts" does not exist, skipping962DROP VIEW963CREATE VIEW964 schemaname | viewname 965------------+--------------------966 public | secure_transcripts967(1 row)968969psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-tables-and-data.sql:228: NOTICE: view "test_view" does not exist, skipping970DROP VIEW971CREATE VIEW972ALTER VIEW973 schemaname | viewname 974------------+-----------975 public | test_view976(1 row)977978DROP MATERIALIZED VIEW979DROP VIEW980DROP VIEW981DROP VIEW982DROP TABLE983DROP TABLE984DROP TABLE985DROP TABLE986DROP TABLE987DROP TABLE988DROP TABLE989DROP TABLE990DROP SCHEMA9912026-10-06 18:38:12 [INFO] Running pgtap test: docs-triggers.sql992$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-triggers.sql993CREATE TABLE994CREATE TABLE995CREATE FUNCTION996CREATE TRIGGER997INSERT 0 1998INSERT 0 1999UPDATE 11000 id | employee_id | old_salary | new_salary 1001----+-------------+------------+------------1002 1 | 1 | 50000 | 550001003(1 row)10041005CREATE TABLE1006CREATE TABLE1007CREATE FUNCTION1008CREATE TRIGGER1009CREATE TABLE1010CREATE FUNCTION1011CREATE TRIGGER1012INSERT 0 11013INSERT 0 11014INSERT 0 11015INSERT 0 11016DELETE 11017 id | customer_id | action | customer_name 1018----+-------------+--------+---------------1019 1 | 1 | DELETE | Alice Johnson1020(1 row)10211022CREATE TABLE1023CREATE FUNCTION1024CREATE TRIGGER1025INSERT 0 11026 id | trigger_name | operation | table_name 1027----+-------------------------+-----------+------------1028 1 | statement_level_trigger | INSERT | orders1029(1 row)10301031CREATE TABLE1032CREATE FUNCTION1033CREATE TRIGGER1034INSERT 0 11035UPDATE 11036DELETE 11037 id | trigger_name | trigger_when | operation | table_name | table_schema | row_id 1038----+-------------------+--------------+-----------+------------+--------------+--------1039 1 | variables_trigger | AFTER | INSERT | employees | public | 31040 2 | variables_trigger | AFTER | UPDATE | employees | public | 31041 3 | variables_trigger | AFTER | DELETE | employees | public | 31042(3 rows)10431044CREATE TABLE1045CREATE FUNCTION1046CREATE TRIGGER1047INSERT 0 11048INSERT 0 11049 id | employee_name | salary 1050----+---------------+--------1051 1 | Executive | 1500001052(1 row)10531054DROP TRIGGER1055DROP TRIGGER1056DROP TRIGGER1057DROP TRIGGER1058DROP TRIGGER1059DROP TRIGGER1060DROP FUNCTION1061DROP FUNCTION1062DROP FUNCTION1063DROP FUNCTION1064DROP FUNCTION1065DROP FUNCTION1066DROP TABLE1067DROP TABLE1068DROP TABLE1069DROP TABLE1070DROP TABLE1071DROP TABLE1072DROP TABLE1073DROP TABLE10742026-10-06 18:38:12 [INFO] Running pgtap test: docs-webhooks.sql1075$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/docs-webhooks.sql1076CREATE TABLE1077CREATE TABLE1078CREATE FUNCTION1079CREATE TRIGGER1080CREATE TRIGGER1081CREATE TRIGGER1082INSERT 0 11083INSERT 0 11084 id | webhook_name | event_type | table_name | schema_name | ?column? 1085----+----------------+------------+------------+-------------+--------------------------------------------------------------1086 1 | insert_webhook | INSERT | profiles | public | {"id": 1, "name": "John Doe", "email": "john@example.com"}1087 2 | insert_webhook | INSERT | profiles | public | {"id": 2, "name": "Jane Smith", "email": "jane@example.com"}1088(2 rows)10891090UPDATE 11091 id | webhook_name | event_type | table_name | schema_name | ?column? | ?column? 1092----+----------------+------------+------------+-------------+----------------------------------------------------------------+------------------------------------------------------------1093 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"}1094(1 row)10951096DELETE 11097 id | webhook_name | event_type | table_name | schema_name | ?column? 1098----+----------------+------------+------------+-------------+--------------------------------------------------------------1099 4 | delete_webhook | DELETE | profiles | public | {"id": 2, "name": "Jane Smith", "email": "jane@example.com"}1100(1 row)11011102CREATE TABLE1103CREATE TABLE1104CREATE FUNCTION1105CREATE FUNCTION1106CREATE TRIGGER1107INSERT 0 11108INSERT 0 11109 id | webhook_name | url | method | response_status | response_data 1110----+----------------+----------------------------------+--------+-----------------+------------------------------------------------------------------------------------------1111 1 | orders_webhook | https://dummyjson.com/products/1 | GET | 200 | {"id": 1, "price": 9.99, "title": "Essence Mascara Lash Princess", "category": "beauty"}1112 2 | orders_webhook | https://dummyjson.com/products/1 | GET | 200 | {"id": 1, "price": 9.99, "title": "Essence Mascara Lash Princess", "category": "beauty"}1113(2 rows)11141115CREATE TABLE1116INSERT 0 11117CREATE FUNCTION1118CREATE TRIGGER1119INSERT 0 11120 id | webhook_name | url | method | response_status | response_data 1121----+-----------------+----------------------------------+--------+-----------------+-------------------------------------------------------------------------------------------1122 3 | product_webhook | https://dummyjson.com/products/2 | GET | 200 | {"id": 2, "price": 19.99, "title": "Eyeshadow Palette with Mirror", "category": "beauty"}1123(1 row)11241125CREATE FUNCTION1126 webhook_name | event_type | table_name | record_count 1127----------------+------------+------------+--------------1128 delete_webhook | DELETE | profiles | 11129 insert_webhook | INSERT | profiles | 31130 update_webhook | UPDATE | profiles | 11131(3 rows)11321133DROP TRIGGER1134DROP TRIGGER1135DROP TRIGGER1136DROP TRIGGER1137DROP TRIGGER1138DROP FUNCTION1139DROP FUNCTION1140DROP FUNCTION1141DROP FUNCTION1142DROP FUNCTION1143DROP TABLE1144DROP TABLE1145DROP TABLE1146DROP TABLE1147DROP TABLE11482026-10-06 18:38:12 [INFO] Running pgtap test: enable_tracking.sql1149$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/enable_tracking.sql1150psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/enable_tracking.sql:1: ERROR: role "postgres" does not exist1151psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/enable_tracking.sql:2: ERROR: role "postgres" does not exist1152psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/enable_tracking.sql:4: ERROR: role "postgres" does not exist1153psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/enable_tracking.sql:5: ERROR: role "postgres" does not exist11542026-10-06 18:38:12 [INFO] Running pgtap test: intarray_ltree_query.sql1155$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/intarray_ltree_query.sql1156BEGIN1157SET1158CREATE EXTENSION1159CREATE EXTENSION1160 q_and 1161-------1162 f1163(1 row)11641165 q_or 1166------1167 t1168(1 row)11691170 lquery_match 1171--------------1172 t1173(1 row)11741175 ltxtquery_match 1176-----------------1177 t1178(1 row)11791180psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/intarray_ltree_query.sql:38: ERROR: query_int expression is too complex1181psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/intarray_ltree_query.sql:42: ERROR: current transaction is aborted, commands ignored until end of transaction block1182psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/intarray_ltree_query.sql:45: ERROR: current transaction is aborted, commands ignored until end of transaction block1183psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/intarray_ltree_query.sql:47: ERROR: current transaction is aborted, commands ignored until end of transaction block1184ROLLBACK11852026-10-06 18:38:13 [INFO] Running pgtap test: ltree_label_overflow.sql1186$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/ltree_label_overflow.sql1187BEGIN1188SET1189CREATE EXTENSION1190 na | nb | a_gt_b | a_lt_b | b_lt_a | a_eq_a 1191-------+----+--------+--------+--------+--------1192 20001 | 1 | t | f | t | t1193(1 row)11941195ROLLBACK11962026-10-06 18:38:13 [INFO] Running pgtap test: multirange_create_priv.sql1197$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/multirange_create_priv.sql1198BEGIN1199CREATE SCHEMA1200CREATE SCHEMA1201psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/multirange_create_priv.sql:16: ERROR: role "postgres" does not exist1202psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/multirange_create_priv.sql:18: ERROR: current transaction is aborted, commands ignored until end of transaction block1203psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/multirange_create_priv.sql:24: ERROR: current transaction is aborted, commands ignored until end of transaction block1204psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/multirange_create_priv.sql:28: ERROR: current transaction is aborted, commands ignored until end of transaction block1205psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/multirange_create_priv.sql:32: ERROR: current transaction is aborted, commands ignored until end of transaction block1206psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/multirange_create_priv.sql:33: ERROR: savepoint "no_priv" does not exist1207psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/multirange_create_priv.sql:35: ERROR: current transaction is aborted, commands ignored until end of transaction block1208ROLLBACK12092026-10-06 18:38:13 [INFO] Running pgtap test: operator_breaking_change.sql1210$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/operator_breaking_change.sql1211BEGIN1212SET1213CREATE EXTENSION1214CREATE SCHEMA1215psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/operator_breaking_change.sql:22: ERROR: role "postgres" does not exist1216psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/operator_breaking_change.sql:26: ERROR: current transaction is aborted, commands ignored until end of transaction block1217psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/operator_breaking_change.sql:29: ERROR: current transaction is aborted, commands ignored until end of transaction block1218psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/operator_breaking_change.sql:32: ERROR: current transaction is aborted, commands ignored until end of transaction block1219psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/operator_breaking_change.sql:37: ERROR: current transaction is aborted, commands ignored until end of transaction block1220psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/operator_breaking_change.sql:38: ERROR: savepoint "before_restrict" does not exist1221psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/operator_breaking_change.sql:41: ERROR: current transaction is aborted, commands ignored until end of transaction block1222psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/operator_breaking_change.sql:46: ERROR: current transaction is aborted, commands ignored until end of transaction block1223psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/operator_breaking_change.sql:47: ERROR: savepoint "before_join" does not exist1224psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/operator_breaking_change.sql:55: ERROR: current transaction is aborted, commands ignored until end of transaction block1225psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/operator_breaking_change.sql:56: ERROR: current transaction is aborted, commands ignored until end of transaction block1226psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/operator_breaking_change.sql:58: ERROR: current transaction is aborted, commands ignored until end of transaction block1227psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/operator_breaking_change.sql:60: ERROR: current transaction is aborted, commands ignored until end of transaction block1228ROLLBACK12292026-10-06 18:38:13 [INFO] Running pgtap test: pg-safeupdate.sql1230$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pg-safeupdate.sql1231LOAD1232SET1233CREATE SCHEMA1234CREATE TABLE1235psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pg-safeupdate.sql:13: ERROR: UPDATE requires a WHERE clause1236psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pg-safeupdate.sql:15: NOTICE: drop cascades to table v.foo1237DROP SCHEMA12382026-10-06 18:38:13 [INFO] Running pgtap test: pg_graphql.sql1239$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pg_graphql.sql1240BEGIN1241COMMENT1242CREATE TABLE1243CREATE TABLE1244COMMENT1245CREATE FUNCTION1246 resolve 1247----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------1248 {"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}}}1249(1 row)12501251 resolve 1252--------------------------------------------------------------------------------------1253 {"data": {"insertIntoBlogCollection": {"records": [{"id": 1, "owner": {"id": 1}}]}}}1254(1 row)12551256 resolve 1257------------------------------------------------------------------------------------------------------------------------1258 {"data": {"insertIntoAccountCollection": {"records": [{"email": "baz@baz.com", "status": null}], "affectedCount": 1}}}1259(1 row)12601261 resolve 1262--------------------------------------------------------------------------------------------------------------------------------1263 {"data": {"xyz": {"records": [{"id": 4, "email": "foo@bar.com"}, {"id": 5, "email": "other@email.com"}], "affectedCount": 2}}}1264(1 row)12651266 resolve 1267------------------------------------------------------------------------------------------------1268 {"data": {"xyz": {"records": [{"email": "1@email.com", "status": null}], "affectedCount": 1}}}1269(1 row)12701271 resolve 1272------------------------------------------------------------------------------------------------1273 {"data": {"xyz": {"records": [{"email": "x@y.com", "status": "active"}], "affectedCount": 1}}}1274(1 row)12751276 resolve 1277-----------------------------------------------------------------------------------------------------------------1278 {"data": {"insertIntoAccountCollection": {"records": [{"id": 8, "email": "bar@foo.com"}], "affectedCount": 1}}}1279(1 row)12801281 resolve 1282-----------------------------------------------------------------------------------------------------------------1283 {"data": {"insertIntoAccountCollection": {"records": [{"id": 9, "email": "bar@foo.com"}], "affectedCount": 1}}}1284(1 row)12851286 resolve 1287--------------------------------------------------------------1288 {"data": {"insertIntoBlogCollection": {"affectedCount": 1}}}1289(1 row)12901291 resolve 1292---------------------------------------------------------------------------------------------------------------------1293 {"data": null, "errors": [{"message": "Input for type AccountInsertInput contains extra keys [\"doesNotExist\"]"}]}1294(1 row)12951296 resolve 1297-----------------------------------------------------------------------------------1298 {"data": null, "errors": [{"message": "Invalid input for BlogInsertInput type"}]}1299(1 row)13001301 resolve 1302---------------------------------------------------------------------------1303 {"data": null, "errors": [{"message": "Invalid input for NonNull type"}]}1304(1 row)13051306 resolve 1307--------------------------------------------------------------------------------------------1308 {"data": null, "errors": [{"message": "At least one record must be provided to objects"}]}1309(1 row)13101311ROLLBACK13122026-10-06 18:38:13 [INFO] Running pgtap test: pg_net.sql1313$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pg_net.sql1314 request_id 1315------------1316 11317(1 row)131813192026-10-06 18:38:13 [INFO] Running pgtap test: pg_plan_filter.sql1320$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pg_plan_filter.sql1321BEGIN1322psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pg_plan_filter.sql:2: ERROR: could not access file "plan_filter": No such file or directory1323psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pg_plan_filter.sql:4: ERROR: current transaction is aborted, commands ignored until end of transaction block1324psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pg_plan_filter.sql:10: ERROR: current transaction is aborted, commands ignored until end of transaction block1325psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pg_plan_filter.sql:14: ERROR: current transaction is aborted, commands ignored until end of transaction block1326psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pg_plan_filter.sql:16: ERROR: current transaction is aborted, commands ignored until end of transaction block1327psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pg_plan_filter.sql:18: ERROR: current transaction is aborted, commands ignored until end of transaction block1328ROLLBACK13292026-10-06 18:38:13 [INFO] Running pgtap test: pgaudit.sql1330$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pgaudit.sql1331SET1332SET1333SET1334CREATE SCHEMA1335CREATE TABLE1336INSERT 0 11337 id | name | password | description 1338----+-------+----------+-------------1339 1 | user1 | HASH1 | blah, blah1340(1 row)13411342psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pgaudit.sql:23: NOTICE: drop cascades to table v.account1343DROP SCHEMA13442026-10-06 18:38:13 [INFO] Running pgtap test: pgbouncer.sql1345$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pgbouncer.sql1346 schema_name | owner 1347-------------+-------1348(0 rows)13491350 schema_name | function_name | owner 1351-------------+---------------+-------1352(0 rows)13531354 schema | object_name | grantee | privilege_type 1355--------+-------------+---------+----------------1356(0 rows)13571358CREATE ROLE1359CREATE ROLE1360UPDATE 11361psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pgbouncer.sql:61: ERROR: schema "pgbouncer" does not exist1362LINE 1: select pgbouncer.get_auth('test_expired_user_password');1363 ^1364psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pgbouncer.sql:63: ERROR: schema "pgbouncer" does not exist1365LINE 1: select pgbouncer.get_auth('test_valid_user_password');1366 ^1367psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pgbouncer.sql:66: ERROR: role "pgbouncer" does not exist1368psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pgbouncer.sql:67: ERROR: schema "pgbouncer" does not exist1369LINE 1: select pgbouncer.get_auth('test_valid_user_password');1370 ^1371RESET1372psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pgbouncer.sql:71: ERROR: role "postgres" does not exist1373psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pgbouncer.sql:72: ERROR: schema "pgbouncer" does not exist1374LINE 1: select pgbouncer.get_auth('test_valid_user_password');1375 ^1376RESET1377DROP ROLE1378DROP ROLE13792026-10-06 18:38:13 [INFO] Running pgtap test: pgcrypto_cipher_matrix.sql1380$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pgcrypto_cipher_matrix.sql1381BEGIN1382CREATE EXTENSION1383SAVEPOINT1384psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pgcrypto_cipher_matrix.sql:26: ERROR: encrypt error: Cipher cannot be initialized1385ROLLBACK1386SAVEPOINT1387psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pgcrypto_cipher_matrix.sql:30: ERROR: encrypt error: Cipher cannot be initialized1388ROLLBACK1389SAVEPOINT1390psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pgcrypto_cipher_matrix.sql:34: ERROR: encrypt error: Cipher cannot be initialized1391ROLLBACK1392 aes128_rt 1393-----------1394 secret1395(1 row)13961397 aes192_rt 1398-----------1399 secret1400(1 row)14011402 aes256_rt 1403-----------1404 secret1405(1 row)14061407 des3_rt 1408---------1409 secret1410(1 row)14111412SAVEPOINT1413psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pgcrypto_cipher_matrix.sql:45: ERROR: Wrong key or corrupt data1414ROLLBACK1415SAVEPOINT1416psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pgcrypto_cipher_matrix.sql:49: ERROR: Wrong key or corrupt data1417ROLLBACK1418 post_error_ok 1419---------------1420 still-here1421(1 row)14221423ROLLBACK14242026-10-06 18:38:13 [INFO] Running pgtap test: pgsodium.sql1425$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/pgsodium.sql1426 status 1427--------1428 valid1429(1 row)143014312026-10-06 18:38:13 [INFO] Running pgtap test: realtime.sql1432$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/realtime.sql1433 publication_name | owner | puballtables | pubinsert | pubupdate | pubdelete | pubtruncate 1434------------------+-------+--------------+-----------+-----------+-----------+-------------1435(0 rows)143614372026-10-06 18:38:13 [INFO] Running pgtap test: replica_identity_upsert.sql1438$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/replica_identity_upsert.sql1439BEGIN1440CREATE TABLE1441CREATE PUBLICATION1442INSERT 0 11443SAVEPOINT1444psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/replica_identity_upsert.sql:17: ERROR: cannot update table "ri" because it does not have a replica identity and publishes updates1445HINT: To enable updating the table, set REPLICA IDENTITY using ALTER TABLE.1446ROLLBACK1447SAVEPOINT1448psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/replica_identity_upsert.sql:22: ERROR: cannot update table "ri" because it does not have a replica identity and publishes updates1449HINT: To enable updating the table, set REPLICA IDENTITY using ALTER TABLE.1450ROLLBACK1451ALTER TABLE1452INSERT 0 11453MERGE 11454 v 1455----1456 301457(1 row)14581459ROLLBACK14602026-10-06 18:38:13 [INFO] Running pgtap test: storage.sql1461$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/storage.sql1462 schema_name | owner 1463-------------+-------1464(0 rows)14651466 schema_name | table_name | owner | rls_enabled | rls_policies 1467-------------+------------+-------+-------------+--------------1468(0 rows)14691470 schema_name | table_name | role_name | privilege_type | is_grantable 1471-------------+------------+-----------+----------------+--------------1472(0 rows)14731474 table_schema | table_name | index_name | index_owner 1475--------------+------------+------------+-------------1476(0 rows)14771478 schema_name | function_name | owner 1479-------------+---------------+-------1480(0 rows)14811482CREATE ROLE1483psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/storage.sql:98: ERROR: role "postgres" does not exist1484psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/storage.sql:100: ERROR: role "postgres" does not exist1485psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/storage.sql:101: ERROR: schema "storage" does not exist1486psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/storage.sql:102: ERROR: schema "storage" does not exist1487psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/storage.sql:104: ERROR: role "postgres" does not exist1488DROP OWNED1489DROP ROLE1490RESET14912026-10-06 18:38:13 [INFO] Running pgtap test: supautils_reserved_roles.sql1492$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/supautils_reserved_roles.sql1493BEGIN1494psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/supautils_reserved_roles.sql:5: ERROR: role "postgres" does not exist1495psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/supautils_reserved_roles.sql:8: ERROR: current transaction is aborted, commands ignored until end of transaction block1496psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/supautils_reserved_roles.sql:9: ERROR: current transaction is aborted, commands ignored until end of transaction block1497psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/supautils_reserved_roles.sql:10: ERROR: savepoint "before_drop" does not exist1498psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/supautils_reserved_roles.sql:12: ERROR: current transaction is aborted, commands ignored until end of transaction block1499psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/supautils_reserved_roles.sql:14: ERROR: current transaction is aborted, commands ignored until end of transaction block1500ROLLBACK15012026-10-06 18:38:13 [INFO] Running pgtap test: vault.sql1502$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/vault.sql1503 schema | object_name | grantee | privilege_type 1504--------+---------------------------+----------------+----------------1505 vault | _crypto_aead_det_decrypt | supabase_admin | EXECUTE1506 vault | _crypto_aead_det_encrypt | supabase_admin | EXECUTE1507 vault | _crypto_aead_det_noncegen | supabase_admin | EXECUTE1508 vault | create_secret | supabase_admin | EXECUTE1509 vault | update_secret | supabase_admin | EXECUTE1510(5 rows)15111512 schema | table | index_name | index_owner | index_type 1513--------+---------+------------------+----------------+------------1514 vault | secrets | secrets_name_idx | supabase_admin | Unique1515 vault | secrets | secrets_pkey | supabase_admin | Unique1516(2 rows)15171518 search_path 1519-----------------1520 "$user", public1521(1 row)15221523SET1524DROP EXTENSION1525CREATE TABLE1526psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/vault.sql:65: ERROR: role "postgres" does not exist1527LINE 1: ...g_extension values (0, 'supabase_vault', '0.2.8', 'postgres'...1528 ^1529CREATE EXTENSION1530DROP TABLE1531RESET1532 function_name | grantee | privilege_type 1533---------------+---------+----------------1534(0 rows)15351536psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/vault.sql:83: ERROR: role "postgres" does not exist1537 search_path 1538-----------------1539 "$user", public1540(1 row)154115422026-10-06 18:38:13 [INFO] Running pgtap test: wal2json.sql1543$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/wal2json.sql1544CREATE SCHEMA1545CREATE TABLE1546psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/wal2json.sql:10: ERROR: could not access file "wal2json": No such file or directory1547INSERT 0 11548psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/wal2json.sql:28: ERROR: replication slot "reg_test" does not exist1549psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/wal2json.sql:31: ERROR: replication slot "reg_test" does not exist1550psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/wal2json.sql:33: NOTICE: drop cascades to table v.foo1551DROP SCHEMA15522026-10-06 18:38:13 [INFO] Running pgtap test: z_17_intarray_ltree_query.sql1553$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/z_17_intarray_ltree_query.sql1554BEGIN1555SET1556CREATE EXTENSION1557psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/z_17_intarray_ltree_query.sql:7: ERROR: lquery level is too large1558DETAIL: Total size of level exceeds the maximum allowed (65535 bytes).1559psql:/nix/store/7g27fp0zcvm88sy936jmi29s03i8w9zq-sql/z_17_intarray_ltree_query.sql:9: ERROR: current transaction is aborted, commands ignored until end of transaction block1560ROLLBACK1561$ pg_ctl -D /build/tmp.ShNtjpUp1a stop1562waiting for server to shut down.... done1563server stopped15642026-10-06 18:38:14 [INFO] Starting PostgreSQL server for pg_regress tests1565$ /nix/store/c8nrmj3fwsxsgv3n02hxk84cw2lb4ygp-start-postgres-server-test/bin/start-postgres-server 17 --daemonize1566Starting server for PSQL 171567/nix/store/c8nrmj3fwsxsgv3n02hxk84cw2lb4ygp-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 directory1568KEY_FILE: /build/tmp.s7o1qtdArr/pgsodium.key1569KEY_FILE contents:1570cat: /build/tmp.s7o1qtdArr/pgsodium.key: No such file or directory1571PGSODIUM_GETKEY_SCRIPT: /nix/store/hm49fhplcc21kvjqvmyqk4wj50cqqmkx-pgsodium-getkey/bin/pgsodium-getkey1572NOTE: using port 5541 for server1573NOTE: using temporary directory /build/tmp.s7o1qtdArr for data1574NOTE: you are free to re-use this data directory at will1575The files belonging to this database system will be owned by user "nixbld".1576This user must also own the server process.15771578The database cluster will be initialized with locale "en_US.UTF-8".1579The default database encoding has accordingly been set to "UTF8".1580The default text search configuration will be set to "english".15811582Data page checksums are disabled.15831584fixing permissions on existing directory /build/tmp.s7o1qtdArr ... ok1585creating subdirectories ... ok1586selecting dynamic shared memory implementation ... posix1587selecting default "max_connections" ... 1001588selecting default "shared_buffers" ... 128MB1589selecting default time zone ... UTC1590creating configuration files ... ok1591running bootstrap script ... ok1592performing post-bootstrap initialization ... ok1593syncing data to disk ... ok15941595initdb: warning: enabling "trust" authentication for local connections1596initdb: 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.15971598Success. You can now start the database server using:15991600 /nix/store/2ywjdcpsm75vl2yzb2841brzmacdscid-postgresql-and-plugins-17.11/bin/pg_ctl -D /build/tmp.s7o1qtdArr -l logfile start16011602NOTE: patching postgresql.conf files1603non-macos pg 17 conf1604waiting for server to start.... done1605server started1606pg_ctl: server is running (PID: 1142)1607/nix/store/2ywjdcpsm75vl2yzb2841brzmacdscid-postgresql-and-plugins-17.11/bin/postgres "-D" "/build/tmp.s7o1qtdArr" "--config-file=/build/tmp.s7o1qtdArr/postgresql.conf" "-p" "5541" "-k" "/build/tmp.s7o1qtdArr/tmp"1608PostgreSQL is ready1609psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1610PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1611Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/init-scripts/00000000000000-initial-schema.sql1612psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: role "postgres" does not exist1613PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1614Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/init-scripts/00000000000001-auth-schema.sql1615psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: role "postgres" does not exist1616PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1617Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/init-scripts/00000000000002-storage-schema.sql1618psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: role "postgres" does not exist1619PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1620Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/init-scripts/00000000000003-post-setup.sql1621psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: role "postgres" does not exist1622PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1623psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: role "postgres" does not exist1624PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1625psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: role "postgres" does not exist1626PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1627psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: role "postgres" does not exist1628PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1629Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/10000000000000_demote-postgres.sql1630psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1631PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1632Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20211115181400_update-auth-permissions.sql1633psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1634PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1635Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20211118015519_create-realtime-schema.sql1636psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1637PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1638Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20211122051245_update-realtime-permissions.sql1639psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1640PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1641Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20211124212715_update-auth-owner.sql1642psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1643PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1644Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20211130151719_update-realtime-permissions.sql1645psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1646PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1647Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20220118070449_enable-safeupdate-postgrest.sql1648psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1649PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1650Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20220126121436_finer-postgrest-triggers.sql1651psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1652PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1653Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20220224211803_fix-postgrest-supautils.sql1654psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1655PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1656Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20220317095840_pg_graphql.sql1657psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1658PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1659Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20220321174452_fix-postgrest-alter-type-event-trigger.sql1660psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1661PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1662Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20220322085208_gotrue-session-limit.sql1663psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1664PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1665Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20220404205710_pg_graphql-on-by-default.sql1666psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1667PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1668Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20220609081115_grant-supabase-auth-admin-and-supabase-storage-admin-to-postgres.sql1669psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1670PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1671Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20220613123923_pg_graphql-pg-dump-perms.sql1672psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1673PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1674Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20220713082019_pg_cron-pg_net-temp-perms-fix.sql1675psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1676PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1677Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20221028101028_set_authenticator_timeout.sql1678psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1679PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1680Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20221103090837_revoke_admin.sql1681psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1682PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1683Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20221207154255_create_pgsodium_and_vault.sql1684psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1685PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1686Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20230201083204_grant_auth_roles_to_postgres.sql1687psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1688PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1689Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20230224042246_grant_extensions_perms_for_postgres.sql1690psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1691PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1692Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20230306081037_grant_pg_monitor_to_postgres.sql1693psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1694PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1695Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20230327032006_grant_auth_roles_to_supabase_storage_admin.sql1696psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1697PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1698Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20230529180330_alter_api_roles_for_inherit.sql1699psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1700PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1701Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20231013070755_grant_authenticator_to_supabase_storage_admin.sql1702psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1703PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1704Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20231017062225_grant_pg_graphql_permissions_for_custom_roles.sql1705psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1706PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1707Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20231020085357_revoke_writes_on_cron_job_from_postgres.sql1708psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1709PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1710Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20231130133139_set_lock_timeout_to_authenticator_role.sql1711psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1712PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1713Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20240124080435_alter_lo_export_lo_import_owner.sql1714psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1715PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1716Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20240606060239_grant_predefined_roles_to_postgres.sql1717psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1718PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1719Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20241031003909_create_orioledb.sql1720psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1721PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1722Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20241215003910_backfill_pgmq_metadata.sql1723psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1724PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1725Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20250205060043_disable_log_statement_on_internal_roles.sql1726psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1727PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1728Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20250205144616_move_orioledb_to_extensions_schema.sql1729psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1730PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1731Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20250218031949_pgsodium_mask_role.sql1732psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1733PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1734Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20250220051611_pg_net_perms_fix.sql1735psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1736PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1737Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20250312095419_pgbouncer_ownership.sql1738psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1739PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1740Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20250402065937_alter_internal_event_triggers_owner_to_supabase_admin.sql1741psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1742PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1743Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20250402093753_grant_subscription_to_postgres_16_and_above.sql1744psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1745PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1746Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20250417190610_update_pgbouncer_get_auth.sql1747psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1748PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1749Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20250421084701_revoke_admin_roles_from_postgres.sql1750psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1751PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1752Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20250605172253_grant_with_admin_to_postgres_16_and_above.sql1753psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1754PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1755Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20250623125453_tmp_grant_storage_tables_to_postgres_with_grant_option.sql1756psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1757PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1758Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20250709135250_grant_storage_schema_to_postgres_with_grant_option.sql1759psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1760PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1761Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20250710151649_supabase_read_only_user_default_transaction_read_only.sql1762psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1763PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1764Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20251001204436_predefined_role_grants.sql1765psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1766PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1767Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20251105172723_grant_pg_reload_conf_to_postgres.sql1768psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1769PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1770Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20251121132723_correct_search_path_pgbouncer.sql1771psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1772PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1773Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20260211120934_supabase_privileged_role.sql1774psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1775PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1776Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20260413000000_fix-authenticator-session-preload-libraries.sql1777psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1778PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1779Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20260421000000_pg_graphql-off-by-default.sql1780psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1781PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1782Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20260421000001_rescope_pg_graphql_access_trigger.sql1783psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1784PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1785Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20260730000000_revoke_trigger_on_cron_tables_from_postgres.sql1786psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1787PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1788Running /nix/store/645zyjykc9v36vi2w9zrw1ah4cnrsnq1-migrations/migrations/20260923021047_update_pgrst_watch_triggers.sql1789psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1790PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1791psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory1792PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1793Shutting down PostgreSQL...1794PostgreSQL is running in daemon mode. Please stop it using pg_ctl.1795pg_ctl: another server might be running; trying to start server anyway1796waiting for server to start.... stopped waiting1797pg_ctl: could not start server1798Examine the log output.1799pg_ctl: server is running (PID: 1142)1800/nix/store/2ywjdcpsm75vl2yzb2841brzmacdscid-postgresql-and-plugins-17.11/bin/postgres "-D" "/build/tmp.s7o1qtdArr" "--config-file=/build/tmp.s7o1qtdArr/postgresql.conf" "-p" "5541" "-k" "/build/tmp.s7o1qtdArr/tmp"1801$ pg_isready -h localhost -p 5541 -U supabase_admin -q18022026-10-06 18:38:17 [INFO] PostgreSQL is ready18032026-10-06 18:38:17 [INFO] CLI variant detected - loading CLI prime SQL file1804$ psql -p 5541 -h localhost --no-password --username=supabase_admin -d postgres -v ON_ERROR_STOP=1 -Xf /nix/store/ib75j74vyc0w374jcz7mqcg6njf21yx3-prime-cli.sql1805psql: error: connection to server at "localhost" (127.0.0.1), port 5541 failed: FATAL: could not access file "supautils": No such file or directory18062026-10-06 18:38:17 [ERROR] Error executing CLI prime SQL file18072026-10-06 18:38:17 [ERROR] An error occurred. Exit code: 118082026-10-06 18:38:17 [ERROR] Debug logs: