run-check-harness-psql-17-cli
checks.x86_64-linux.psql_17_cli
· build #635
· raw
12026-11-09 21:29:37 [INFO] Starting HTTP mock server (will find free port)...22026-11-09 21:29:38 [INFO] HTTP mock server started on port 888032026-11-09 21:29:38 [INFO] Creating temporary PostgreSQL cluster at /build/tmp.ejv3XkOR6Z42026-11-09 21:29:39 [INFO] Generated preload libraries: pg_cron, pg_net, pgsodium, supabase_vault52026-11-09 21:29:39 [INFO] Checking shared_preload_libraries setting:62026-11-09 21:29:39 [INFO] 721:shared_preload_libraries = 'pg_cron, pg_net, pgsodium, supabase_vault' # (change requires restart)72026-11-09 21:29:39 [INFO] Configuring local auth82026-11-09 21:29:39 [INFO] Waiting for PostgreSQL to be ready...92026-11-09 21:29:39 [INFO] PostgreSQL is ready102026-11-09 21:29:39 [INFO] Creating test database112026-11-09 21:29:39 [INFO] CLI variant detected - loading CLI prime SQL file122026-11-09 21:29:40 [INFO] Creating test_config table132026-11-09 21:29:40 [INFO] Running pgtap test: auth.sql142026-11-09 21:29:40 [INFO] Running pgtap test: create_statistics_priv.sql152026-11-09 21:29:40 [INFO] Running pgtap test: dblink.sql162026-11-09 21:29:40 [INFO] Running pgtap test: docs-array-test.sql172026-11-09 21:29:40 [INFO] Running pgtap test: docs-cascades-deletes.sql182026-11-09 21:29:40 [INFO] Running pgtap test: docs-connections.sql192026-11-09 21:29:40 [INFO] Running pgtap test: docs-enums.sql202026-11-09 21:29:40 [INFO] Running pgtap test: docs-full-text-search.sql212026-11-09 21:29:40 [INFO] Running pgtap test: docs-functions.sql222026-11-09 21:29:40 [INFO] Running pgtap test: docs-indexes.sql232026-11-09 21:29:40 [INFO] Running pgtap test: docs-json.sql242026-11-09 21:29:40 [INFO] Running pgtap test: docs-partitioning.sql252026-11-09 21:29:40 [INFO] Running pgtap test: docs-tables-and-data.sql262026-11-09 21:29:41 [INFO] Running pgtap test: docs-triggers.sql272026-11-09 21:29:41 [INFO] Running pgtap test: docs-webhooks.sql282026-11-09 21:29:41 [INFO] Running pgtap test: enable_tracking.sql292026-11-09 21:29:41 [INFO] Running pgtap test: event_trigger_search_path.sql302026-11-09 21:29:41 [INFO] Running pgtap test: intarray_ltree_query.sql312026-11-09 21:29:41 [INFO] Running pgtap test: ltree_label_overflow.sql322026-11-09 21:29:41 [INFO] Running pgtap test: multirange_create_priv.sql332026-11-09 21:29:41 [INFO] Running pgtap test: operator_breaking_change.sql342026-11-09 21:29:41 [INFO] Running pgtap test: pg-safeupdate.sql352026-11-09 21:29:41 [INFO] Running pgtap test: pg_graphql.sql362026-11-09 21:29:41 [INFO] Running pgtap test: pg_net.sql372026-11-09 21:29:41 [INFO] Running pgtap test: pg_plan_filter.sql382026-11-09 21:29:42 [INFO] Running pgtap test: pgaudit.sql392026-11-09 21:29:42 [INFO] Running pgtap test: pgbouncer.sql402026-11-09 21:29:42 [INFO] Running pgtap test: pgcrypto_cipher_matrix.sql412026-11-09 21:29:42 [INFO] Running pgtap test: pgsodium.sql422026-11-09 21:29:42 [INFO] Running pgtap test: realtime.sql432026-11-09 21:29:42 [INFO] Running pgtap test: replica_identity_upsert.sql442026-11-09 21:29:42 [INFO] Running pgtap test: storage.sql452026-11-09 21:29:42 [INFO] Running pgtap test: supautils_reserved_memberships.sql462026-11-09 21:29:42 [INFO] Running pgtap test: supautils_reserved_roles.sql472026-11-09 21:29:42 [INFO] Running pgtap test: vault.sql482026-11-09 21:29:42 [INFO] Running pgtap test: wal2json.sql492026-11-09 21:29:42 [INFO] Running pgtap test: z_17_intarray_ltree_query.sql502026-11-09 21:29:42 [INFO] Running pgtap test: z_17_wal_summarize.sql512026-11-09 21:29:42 [INFO] Starting PostgreSQL server for pg_regress tests522026-11-09 21:29:47 [INFO] PostgreSQL is ready532026-11-09 21:29:47 [INFO] CLI variant detected - loading CLI prime SQL file542026-11-09 21:29:47 [INFO] Creating test_config table for pg_regress tests552026-11-09 21:29:47 [INFO] CLI variant detected - running subset of pg_regress tests (38 tests)562026-11-09 21:29:48 [ERROR] pg_regress tests failed57diff -U3 /nix/store/wmpf35g6g5qk0xyrzwlv10jzs5a4qmqz-tests/expected/supautils_reserved_memberships.out /nix/store/ip3s1gasrhkdsknmss5hmfcxb6rsx1di-run-check-harness-psql-17-cli/regression_output/results/supautils_reserved_memberships.out58--- /nix/store/wmpf35g6g5qk0xyrzwlv10jzs5a4qmqz-tests/expected/supautils_reserved_memberships.out 1970-01-01 00:00:01.000000000 +000059+++ /nix/store/ip3s1gasrhkdsknmss5hmfcxb6rsx1di-run-check-harness-psql-17-cli/regression_output/results/supautils_reserved_memberships.out 2026-11-09 21:29:48.434554823 +000060@@ -26,5 +26,5 @@61 grant authenticator to postgres;62 ERROR: "authenticator" role memberships are reserved, only superusers can grant them63 grant pg_write_all_data to postgres;64-ERROR: "pg_write_all_data " role memberships are reserved, only superusers can grant them65+ERROR: "pg_write_all_data" role memberships are reserved, only superusers can grant them66 reset role;672026-11-09 21:29:48 [ERROR] An error occurred. Exit code: 1682026-11-09 21:29:48 [ERROR] Debug logs:692026-11-09 21:29:37 [INFO] Starting HTTP mock server (will find free port)...70$ /nix/store/3r480dxgsf65fw3giaa1zbv38zajiv8i-python3-3.13.11/bin/python3 /nix/store/sfl1mnhcw0ccky7m2crn0hda79clq4mk-http-mock-server.py712026-11-09 21:29:38 [INFO] HTTP mock server started on port 8880722026-11-09 21:29:38 [INFO] Creating temporary PostgreSQL cluster at /build/tmp.ejv3XkOR6Z73$ initdb --locale=C --username=supabase_admin -D /build/tmp.ejv3XkOR6Z74The 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.ejv3XkOR6Z ... 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.ejv3XkOR6Z -l logfile start1001012026-11-09 21:29:39 [INFO] Generated preload libraries: pg_cron, pg_net, pgsodium, supabase_vault1022026-11-09 21:29:39 [INFO] Checking shared_preload_libraries setting:1032026-11-09 21:29:39 [INFO] 721:shared_preload_libraries = 'pg_cron, pg_net, pgsodium, supabase_vault' # (change requires restart)1042026-11-09 21:29:39 [INFO] Configuring local auth105$ pg_ctl -D /build/tmp.ejv3XkOR6Z -l /build/tmp.ejv3XkOR6Z/postgresql.log -o -k /build/tmp.ejv3XkOR6Z/sockets -p 5541 -d 5 start106waiting for server to start.... done107server started1082026-11-09 21:29:39 [INFO] Waiting for PostgreSQL to be ready...109$ pg_isready -h localhost -p 5541 -U supabase_admin -q1102026-11-09 21:29:39 [INFO] PostgreSQL is ready1112026-11-09 21:29:39 [INFO] Creating test database112$ createdb -p 5541 -h localhost --username=supabase_admin testing1132026-11-09 21:29: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-09 21:29:40 [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-09 21:29:40 [INFO] Running pgtap test: auth.sql132$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-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/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/auth.sql:97: ERROR: relation "auth.schema_migrations" does not exist154LINE 1: select * from auth.schema_migrations;155 ^1562026-11-09 21:29:40 [INFO] Running pgtap test: create_statistics_priv.sql157$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/create_statistics_priv.sql158BEGIN159CREATE SCHEMA160CREATE SCHEMA161psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/create_statistics_priv.sql:15: ERROR: role "postgres" does not exist162psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/create_statistics_priv.sql:17: ERROR: current transaction is aborted, commands ignored until end of transaction block163psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/create_statistics_priv.sql:20: ERROR: current transaction is aborted, commands ignored until end of transaction block164psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/create_statistics_priv.sql:21: ERROR: current transaction is aborted, commands ignored until end of transaction block165psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/create_statistics_priv.sql:24: ERROR: current transaction is aborted, commands ignored until end of transaction block166psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/create_statistics_priv.sql:27: ERROR: current transaction is aborted, commands ignored until end of transaction block167psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/create_statistics_priv.sql:28: ERROR: current transaction is aborted, commands ignored until end of transaction block168psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/create_statistics_priv.sql:29: ERROR: savepoint "no_priv" does not exist169psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/create_statistics_priv.sql:31: ERROR: current transaction is aborted, commands ignored until end of transaction block170ROLLBACK1712026-11-09 21:29:40 [INFO] Running pgtap test: dblink.sql172$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/dblink.sql173SET174DROP EXTENSION175psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-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/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/dblink.sql:28: ERROR: role "postgres" does not exist187 search_path 188-----------------189 "$user", public190(1 row)191192DROP EXTENSION193CREATE EXTENSION1942026-11-09 21:29:40 [INFO] Running pgtap test: docs-array-test.sql195$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-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-09 21:29:40 [INFO] Running pgtap test: docs-cascades-deletes.sql210$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-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/m5lxd3hm4s1xx25brqjix2fyqry6p92d-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/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/docs-cascades-deletes.sql:56: ERROR: duplicate key value violates unique constraint "grandparent_pkey"251DETAIL: Key (id)=(1) already exists.252psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/docs-cascades-deletes.sql:61: ERROR: duplicate key value violates unique constraint "parent_pkey"253DETAIL: Key (id)=(1) already exists.254psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/docs-cascades-deletes.sql:66: ERROR: duplicate key value violates unique constraint "parent_pkey"255DETAIL: Key (id)=(2) already exists.256psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-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/m5lxd3hm4s1xx25brqjix2fyqry6p92d-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/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/docs-cascades-deletes.sql:89: ERROR: duplicate key value violates unique constraint "grandparent_pkey"278DETAIL: Key (id)=(1) already exists.279psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/docs-cascades-deletes.sql:94: ERROR: duplicate key value violates unique constraint "parent_pkey"280DETAIL: Key (id)=(1) already exists.281psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/docs-cascades-deletes.sql:99: ERROR: duplicate key value violates unique constraint "parent_pkey"282DETAIL: Key (id)=(2) already exists.283psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-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/m5lxd3hm4s1xx25brqjix2fyqry6p92d-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/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/docs-cascades-deletes.sql:122: ERROR: duplicate key value violates unique constraint "grandparent_pkey"305DETAIL: Key (id)=(1) already exists.306psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/docs-cascades-deletes.sql:127: ERROR: duplicate key value violates unique constraint "parent_pkey"307DETAIL: Key (id)=(1) already exists.308psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/docs-cascades-deletes.sql:132: ERROR: duplicate key value violates unique constraint "parent_pkey"309DETAIL: Key (id)=(2) already exists.310psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-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/m5lxd3hm4s1xx25brqjix2fyqry6p92d-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/m5lxd3hm4s1xx25brqjix2fyqry6p92d-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/m5lxd3hm4s1xx25brqjix2fyqry6p92d-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-09 21:29:40 [INFO] Running pgtap test: docs-connections.sql432$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-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-09 21:29:40 [INFO] Running pgtap test: docs-enums.sql448$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-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-09 21:29:40 [INFO] Running pgtap test: docs-full-text-search.sql541$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-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-09 21:29:40 [INFO] Running pgtap test: docs-functions.sql682$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-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/m5lxd3hm4s1xx25brqjix2fyqry6p92d-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/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/docs-functions.sql:79: ERROR: role "anon" does not exist714psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/docs-functions.sql:81: ERROR: role "authenticated" does not exist715REVOKE716psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/docs-functions.sql:84: ERROR: role "anon" does not exist717ALTER DEFAULT PRIVILEGES718psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/docs-functions.sql:87: ERROR: role "anon" does not exist719psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/docs-functions.sql:89: ERROR: role "authenticated" does not exist720CREATE FUNCTION721psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/docs-functions.sql:106: WARNING: logging warning: WARNING MESSAGE722psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-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/m5lxd3hm4s1xx25brqjix2fyqry6p92d-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/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/docs-functions.sql:221: ERROR: role "anon" does not exist764ALTER DEFAULT PRIVILEGES765psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/docs-functions.sql:224: ERROR: role "anon" does not exist7662026-11-09 21:29:40 [INFO] Running pgtap test: docs-indexes.sql767$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/docs-indexes.sql768CREATE TABLE769INSERT 0 1770 name 771----------772 John Doe773(1 row)774775CREATE INDEX776CREATE INDEX777CREATE INDEX778REINDEX779REINDEX780DROP TABLE7812026-11-09 21:29:40 [INFO] Running pgtap test: docs-json.sql782$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-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-09 21:29:40 [INFO] Running pgtap test: docs-partitioning.sql796$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-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-09 21:29:40 [INFO] Running pgtap test: docs-tables-and-data.sql856$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-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/m5lxd3hm4s1xx25brqjix2fyqry6p92d-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/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/docs-tables-and-data.sql:89: NOTICE: table "performances" does not exist, skipping900DROP TABLE901psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-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/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/docs-tables-and-data.sql:120: NOTICE: table "salaries" does not exist, skipping921DROP TABLE922psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-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/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/docs-tables-and-data.sql:137: NOTICE: table "grades" does not exist, skipping932DROP TABLE933psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/docs-tables-and-data.sql:138: NOTICE: table "courses" does not exist, skipping934DROP TABLE935psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/docs-tables-and-data.sql:139: NOTICE: table "students" does not exist, skipping936DROP TABLE937psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-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/m5lxd3hm4s1xx25brqjix2fyqry6p92d-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/m5lxd3hm4s1xx25brqjix2fyqry6p92d-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/m5lxd3hm4s1xx25brqjix2fyqry6p92d-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/m5lxd3hm4s1xx25brqjix2fyqry6p92d-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-09 21:29:41 [INFO] Running pgtap test: docs-triggers.sql1007$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-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-09 21:29:41 [INFO] Running pgtap test: docs-webhooks.sql1090$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-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-09 21:29:41 [INFO] Running pgtap test: enable_tracking.sql1164$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/enable_tracking.sql1165psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/enable_tracking.sql:1: ERROR: role "postgres" does not exist1166psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/enable_tracking.sql:2: ERROR: role "postgres" does not exist1167psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/enable_tracking.sql:4: ERROR: role "postgres" does not exist1168psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/enable_tracking.sql:5: ERROR: role "postgres" does not exist11692026-11-09 21:29:41 [INFO] Running pgtap test: event_trigger_search_path.sql1170$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/event_trigger_search_path.sql1171DO11722026-11-09 21:29:41 [INFO] Running pgtap test: intarray_ltree_query.sql1173$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-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/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/intarray_ltree_query.sql:38: ERROR: query_int expression is too complex1199psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/intarray_ltree_query.sql:42: ERROR: current transaction is aborted, commands ignored until end of transaction block1200psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/intarray_ltree_query.sql:45: ERROR: current transaction is aborted, commands ignored until end of transaction block1201psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/intarray_ltree_query.sql:47: ERROR: current transaction is aborted, commands ignored until end of transaction block1202ROLLBACK12032026-11-09 21:29:41 [INFO] Running pgtap test: ltree_label_overflow.sql1204$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-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-09 21:29:41 [INFO] Running pgtap test: multirange_create_priv.sql1215$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/multirange_create_priv.sql1216BEGIN1217CREATE SCHEMA1218CREATE SCHEMA1219psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/multirange_create_priv.sql:16: ERROR: role "postgres" does not exist1220psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/multirange_create_priv.sql:18: ERROR: current transaction is aborted, commands ignored until end of transaction block1221psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/multirange_create_priv.sql:24: ERROR: current transaction is aborted, commands ignored until end of transaction block1222psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/multirange_create_priv.sql:28: ERROR: current transaction is aborted, commands ignored until end of transaction block1223psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/multirange_create_priv.sql:32: ERROR: current transaction is aborted, commands ignored until end of transaction block1224psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/multirange_create_priv.sql:33: ERROR: savepoint "no_priv" does not exist1225psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/multirange_create_priv.sql:35: ERROR: current transaction is aborted, commands ignored until end of transaction block1226ROLLBACK12272026-11-09 21:29:41 [INFO] Running pgtap test: operator_breaking_change.sql1228$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/operator_breaking_change.sql1229BEGIN1230SET1231CREATE EXTENSION1232CREATE SCHEMA1233psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/operator_breaking_change.sql:22: ERROR: role "postgres" does not exist1234psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/operator_breaking_change.sql:26: ERROR: current transaction is aborted, commands ignored until end of transaction block1235psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/operator_breaking_change.sql:29: ERROR: current transaction is aborted, commands ignored until end of transaction block1236psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/operator_breaking_change.sql:32: ERROR: current transaction is aborted, commands ignored until end of transaction block1237psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/operator_breaking_change.sql:37: ERROR: current transaction is aborted, commands ignored until end of transaction block1238psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/operator_breaking_change.sql:38: ERROR: savepoint "before_restrict" does not exist1239psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/operator_breaking_change.sql:41: ERROR: current transaction is aborted, commands ignored until end of transaction block1240psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/operator_breaking_change.sql:46: ERROR: current transaction is aborted, commands ignored until end of transaction block1241psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/operator_breaking_change.sql:47: ERROR: savepoint "before_join" does not exist1242psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/operator_breaking_change.sql:55: ERROR: current transaction is aborted, commands ignored until end of transaction block1243psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/operator_breaking_change.sql:56: ERROR: current transaction is aborted, commands ignored until end of transaction block1244psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/operator_breaking_change.sql:58: ERROR: current transaction is aborted, commands ignored until end of transaction block1245psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/operator_breaking_change.sql:60: ERROR: current transaction is aborted, commands ignored until end of transaction block1246ROLLBACK12472026-11-09 21:29:41 [INFO] Running pgtap test: pg-safeupdate.sql1248$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/pg-safeupdate.sql1249LOAD1250SET1251CREATE SCHEMA1252CREATE TABLE1253psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/pg-safeupdate.sql:13: ERROR: UPDATE requires a WHERE clause1254psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/pg-safeupdate.sql:15: NOTICE: drop cascades to table v.foo1255DROP SCHEMA12562026-11-09 21:29:41 [INFO] Running pgtap test: pg_graphql.sql1257$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-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-09 21:29:41 [INFO] Running pgtap test: pg_net.sql1331$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/pg_net.sql1332 request_id 1333------------1334 11335(1 row)133613372026-11-09 21:29:41 [INFO] Running pgtap test: pg_plan_filter.sql1338$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/pg_plan_filter.sql1339BEGIN1340psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/pg_plan_filter.sql:2: ERROR: could not access file "plan_filter": No such file or directory1341psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/pg_plan_filter.sql:4: ERROR: current transaction is aborted, commands ignored until end of transaction block1342psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/pg_plan_filter.sql:10: ERROR: current transaction is aborted, commands ignored until end of transaction block1343psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/pg_plan_filter.sql:14: ERROR: current transaction is aborted, commands ignored until end of transaction block1344psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/pg_plan_filter.sql:16: ERROR: current transaction is aborted, commands ignored until end of transaction block1345psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/pg_plan_filter.sql:18: ERROR: current transaction is aborted, commands ignored until end of transaction block1346ROLLBACK13472026-11-09 21:29:42 [INFO] Running pgtap test: pgaudit.sql1348$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/pgaudit.sql1349SET1350SET1351SET1352CREATE SCHEMA1353CREATE TABLE1354INSERT 0 11355 id | name | password | description 1356----+-------+----------+-------------1357 1 | user1 | HASH1 | blah, blah1358(1 row)13591360psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/pgaudit.sql:23: NOTICE: drop cascades to table v.account1361DROP SCHEMA13622026-11-09 21:29:42 [INFO] Running pgtap test: pgbouncer.sql1363$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-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/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/pgbouncer.sql:62: ERROR: schema "pgbouncer" does not exist1381LINE 1: select * from pgbouncer.get_auth('test_expired_user_password...1382 ^1383psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/pgbouncer.sql:64: ERROR: schema "pgbouncer" does not exist1384LINE 1: select pgbouncer.get_auth('test_valid_user_password');1385 ^1386psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/pgbouncer.sql:67: ERROR: role "pgbouncer" does not exist1387psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/pgbouncer.sql:68: ERROR: schema "pgbouncer" does not exist1388LINE 1: select pgbouncer.get_auth('test_valid_user_password');1389 ^1390RESET1391psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/pgbouncer.sql:72: ERROR: role "postgres" does not exist1392psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/pgbouncer.sql:73: ERROR: schema "pgbouncer" does not exist1393LINE 1: select pgbouncer.get_auth('test_valid_user_password');1394 ^1395RESET1396DROP ROLE1397DROP ROLE13982026-11-09 21:29:42 [INFO] Running pgtap test: pgcrypto_cipher_matrix.sql1399$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/pgcrypto_cipher_matrix.sql1400BEGIN1401CREATE EXTENSION1402SAVEPOINT1403psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/pgcrypto_cipher_matrix.sql:26: ERROR: encrypt error: Cipher cannot be initialized1404ROLLBACK1405SAVEPOINT1406psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/pgcrypto_cipher_matrix.sql:30: ERROR: encrypt error: Cipher cannot be initialized1407ROLLBACK1408SAVEPOINT1409psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-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/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/pgcrypto_cipher_matrix.sql:45: ERROR: Wrong key or corrupt data1433ROLLBACK1434SAVEPOINT1435psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/pgcrypto_cipher_matrix.sql:49: ERROR: Wrong key or corrupt data1436ROLLBACK1437 post_error_ok 1438---------------1439 still-here1440(1 row)14411442ROLLBACK14432026-11-09 21:29:42 [INFO] Running pgtap test: pgsodium.sql1444$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/pgsodium.sql1445 status 1446--------1447 valid1448(1 row)144914502026-11-09 21:29:42 [INFO] Running pgtap test: realtime.sql1451$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/realtime.sql1452 publication_name | owner | puballtables | pubinsert | pubupdate | pubdelete | pubtruncate 1453------------------+-------+--------------+-----------+-----------+-----------+-------------1454(0 rows)145514562026-11-09 21:29:42 [INFO] Running pgtap test: replica_identity_upsert.sql1457$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/replica_identity_upsert.sql1458BEGIN1459CREATE TABLE1460CREATE PUBLICATION1461INSERT 0 11462SAVEPOINT1463psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-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/m5lxd3hm4s1xx25brqjix2fyqry6p92d-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-09 21:29:42 [INFO] Running pgtap test: storage.sql1480$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-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/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/storage.sql:98: ERROR: role "postgres" does not exist1503psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/storage.sql:100: ERROR: role "postgres" does not exist1504psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/storage.sql:101: ERROR: schema "storage" does not exist1505psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/storage.sql:102: ERROR: schema "storage" does not exist1506psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/storage.sql:104: ERROR: role "postgres" does not exist1507DROP OWNED1508DROP ROLE1509RESET15102026-11-09 21:29:42 [INFO] Running pgtap test: supautils_reserved_memberships.sql1511$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/supautils_reserved_memberships.sql1512psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/supautils_reserved_memberships.sql:1: ERROR: role "postgres" does not exist1513psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/supautils_reserved_memberships.sql:3: ERROR: role "postgres" does not exist1514psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/supautils_reserved_memberships.sql:4: ERROR: role "postgres" does not exist1515psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/supautils_reserved_memberships.sql:5: ERROR: role "postgres" does not exist1516psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/supautils_reserved_memberships.sql:6: ERROR: role "postgres" does not exist1517psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/supautils_reserved_memberships.sql:7: ERROR: role "postgres" does not exist1518psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/supautils_reserved_memberships.sql:8: ERROR: role "postgres" does not exist1519psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/supautils_reserved_memberships.sql:9: ERROR: role "postgres" does not exist1520psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/supautils_reserved_memberships.sql:10: ERROR: role "postgres" does not exist1521psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/supautils_reserved_memberships.sql:11: ERROR: role "postgres" does not exist1522psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/supautils_reserved_memberships.sql:12: ERROR: role "postgres" does not exist1523psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/supautils_reserved_memberships.sql:13: ERROR: role "postgres" does not exist1524psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/supautils_reserved_memberships.sql:14: ERROR: role "postgres" does not exist1525psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/supautils_reserved_memberships.sql:15: ERROR: role "postgres" does not exist1526psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/supautils_reserved_memberships.sql:16: ERROR: role "postgres" does not exist1527RESET15282026-11-09 21:29:42 [INFO] Running pgtap test: supautils_reserved_roles.sql1529$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/supautils_reserved_roles.sql1530BEGIN1531psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/supautils_reserved_roles.sql:5: ERROR: role "postgres" does not exist1532psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/supautils_reserved_roles.sql:8: ERROR: current transaction is aborted, commands ignored until end of transaction block1533psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/supautils_reserved_roles.sql:9: ERROR: current transaction is aborted, commands ignored until end of transaction block1534psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/supautils_reserved_roles.sql:10: ERROR: savepoint "before_drop" does not exist1535psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/supautils_reserved_roles.sql:12: ERROR: current transaction is aborted, commands ignored until end of transaction block1536psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/supautils_reserved_roles.sql:14: ERROR: current transaction is aborted, commands ignored until end of transaction block1537ROLLBACK15382026-11-09 21:29:42 [INFO] Running pgtap test: vault.sql1539$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/vault.sql1540 schema | object_name | grantee | privilege_type 1541--------+---------------------------+----------------+----------------1542 vault | _crypto_aead_det_decrypt | supabase_admin | EXECUTE1543 vault | _crypto_aead_det_encrypt | supabase_admin | EXECUTE1544 vault | _crypto_aead_det_noncegen | supabase_admin | EXECUTE1545 vault | create_secret | supabase_admin | EXECUTE1546 vault | update_secret | supabase_admin | EXECUTE1547(5 rows)15481549 schema | table | index_name | index_owner | index_type 1550--------+---------+------------------+----------------+------------1551 vault | secrets | secrets_name_idx | supabase_admin | Unique1552 vault | secrets | secrets_pkey | supabase_admin | Unique1553(2 rows)15541555 search_path 1556-----------------1557 "$user", public1558(1 row)15591560SET1561DROP EXTENSION1562CREATE TABLE1563psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/vault.sql:65: ERROR: role "postgres" does not exist1564LINE 1: ...g_extension values (0, 'supabase_vault', '0.2.8', 'postgres'...1565 ^1566CREATE EXTENSION1567DROP TABLE1568RESET1569 function_name | grantee | privilege_type 1570---------------+---------+----------------1571(0 rows)15721573psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/vault.sql:83: ERROR: role "postgres" does not exist1574 search_path 1575-----------------1576 "$user", public1577(1 row)157815792026-11-09 21:29:42 [INFO] Running pgtap test: wal2json.sql1580$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/wal2json.sql1581CREATE SCHEMA1582CREATE TABLE1583psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/wal2json.sql:10: ERROR: could not access file "wal2json": No such file or directory1584INSERT 0 11585psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/wal2json.sql:28: ERROR: replication slot "reg_test" does not exist1586psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/wal2json.sql:31: ERROR: replication slot "reg_test" does not exist1587psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/wal2json.sql:33: NOTICE: drop cascades to table v.foo1588DROP SCHEMA15892026-11-09 21:29:42 [INFO] Running pgtap test: z_17_intarray_ltree_query.sql1590$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/z_17_intarray_ltree_query.sql1591BEGIN1592SET1593CREATE EXTENSION1594psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/z_17_intarray_ltree_query.sql:7: ERROR: lquery level is too large1595DETAIL: Total size of level exceeds the maximum allowed (65535 bytes).1596psql:/nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/z_17_intarray_ltree_query.sql:9: ERROR: current transaction is aborted, commands ignored until end of transaction block1597ROLLBACK15982026-11-09 21:29:42 [INFO] Running pgtap test: z_17_wal_summarize.sql1599$ psql -p 5541 -h localhost --username=supabase_admin -d testing -f /nix/store/m5lxd3hm4s1xx25brqjix2fyqry6p92d-sql/z_17_wal_summarize.sql1600 summarize_wal_default_ok 1601--------------------------1602 f1603(1 row)16041605$ pg_ctl -D /build/tmp.ejv3XkOR6Z stop1606waiting for server to shut down.... done1607server stopped16082026-11-09 21:29:42 [INFO] Starting PostgreSQL server for pg_regress tests1609$ /nix/store/bjdj1rqvfas865vya6ywxhvzrc3adv0n-start-postgres-server-test/bin/start-postgres-server 17 --daemonize1610Starting server for PSQL 171611/nix/store/bjdj1rqvfas865vya6ywxhvzrc3adv0n-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 directory1612KEY_FILE: /build/tmp.76QqaMQrDM/pgsodium.key1613KEY_FILE contents:1614cat: /build/tmp.76QqaMQrDM/pgsodium.key: No such file or directory1615PGSODIUM_GETKEY_SCRIPT: /nix/store/hm49fhplcc21kvjqvmyqk4wj50cqqmkx-pgsodium-getkey/bin/pgsodium-getkey1616NOTE: using port 5541 for server1617NOTE: using temporary directory /build/tmp.76QqaMQrDM for data1618NOTE: you are free to re-use this data directory at will1619The files belonging to this database system will be owned by user "nixbld".1620This user must also own the server process.16211622The database cluster will be initialized with locale "en_US.UTF-8".1623The default database encoding has accordingly been set to "UTF8".1624The default text search configuration will be set to "english".16251626Data page checksums are disabled.16271628fixing permissions on existing directory /build/tmp.76QqaMQrDM ... ok1629creating subdirectories ... ok1630selecting dynamic shared memory implementation ... posix1631selecting default "max_connections" ... 1001632selecting default "shared_buffers" ... 128MB1633selecting default time zone ... UTC1634creating configuration files ... ok1635running bootstrap script ... ok1636performing post-bootstrap initialization ... ok1637syncing data to disk ... ok16381639initdb: warning: enabling "trust" authentication for local connections1640initdb: 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.16411642Success. You can now start the database server using:16431644 /nix/store/m8x106cxyrwf7favnjisvm38xz5wplmn-postgresql-and-plugins-17.11/bin/pg_ctl -D /build/tmp.76QqaMQrDM -l logfile start16451646NOTE: patching postgresql.conf files1647non-macos pg 17 conf1648waiting for server to start.... done1649server started1650pg_ctl: server is running (PID: 1213)1651/nix/store/m8x106cxyrwf7favnjisvm38xz5wplmn-postgresql-and-plugins-17.11/bin/postgres "-D" "/build/tmp.76QqaMQrDM" "--config-file=/build/tmp.76QqaMQrDM/postgresql.conf" "-p" "5541" "-k" "/build/tmp.76QqaMQrDM/tmp"1652PostgreSQL is ready1653NOTICE: empty string is not a valid password, clearing password1654CREATE ROLE1655ALTER DATABASE1656Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/init-scripts/00000000000000-initial-schema.sql1657CREATE PUBLICATION1658ALTER ROLE1659CREATE ROLE1660CREATE ROLE1661GRANT ROLE1662GRANT1663CREATE ROLE1664GRANT ROLE1665CREATE SCHEMA1666CREATE EXTENSION1667CREATE EXTENSION1668CREATE ROLE1669CREATE ROLE1670CREATE ROLE1671CREATE ROLE1672GRANT ROLE1673GRANT ROLE1674GRANT ROLE1675GRANT ROLE1676GRANT1677ALTER DEFAULT PRIVILEGES1678ALTER DEFAULT PRIVILEGES1679ALTER DEFAULT PRIVILEGES1680GRANT1681ALTER ROLE1682ALTER DEFAULT PRIVILEGES1683ALTER DEFAULT PRIVILEGES1684ALTER DEFAULT PRIVILEGES1685ALTER ROLE1686ALTER ROLE1687Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/init-scripts/00000000000001-auth-schema.sql1688CREATE SCHEMA1689CREATE TABLE1690CREATE INDEX1691CREATE INDEX1692COMMENT1693CREATE TABLE1694CREATE INDEX1695CREATE INDEX1696CREATE INDEX1697COMMENT1698CREATE TABLE1699COMMENT1700CREATE TABLE1701CREATE INDEX1702COMMENT1703CREATE TABLE1704COMMENT1705INSERT 0 71706CREATE FUNCTION1707CREATE FUNCTION1708CREATE FUNCTION1709GRANT1710CREATE ROLE1711GRANT1712GRANT1713GRANT1714ALTER ROLE1715ALTER TABLE1716ALTER TABLE1717ALTER TABLE1718ALTER TABLE1719ALTER TABLE1720Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/init-scripts/00000000000002-storage-schema.sql1721CREATE SCHEMA1722CREATE ROLE1723ALTER ROLE1724GRANT1725DO1726Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/init-scripts/00000000000003-post-setup.sql1727ALTER ROLE1728ALTER ROLE1729CREATE FUNCTION1730CREATE EVENT TRIGGER1731COMMENT1732CREATE FUNCTION1733COMMENT1734DO1735CREATE ROLE1736GRANT1737GRANT1738GRANT1739GRANT1740GRANT1741GRANT1742GRANT1743GRANT1744GRANT1745DO1746NOTICE: empty string is not a valid password, clearing password1747ALTER ROLE1748CREATE ROLE1749REVOKE1750CREATE SCHEMA1751CREATE FUNCTION1752REVOKE1753GRANT1754psql:/nix/store/0s4wf39csywl7iy2bchhiaqzcinrk17w-stat-extension:1: NOTICE: schema "extensions" already exists, skipping1755CREATE SCHEMA1756CREATE EXTENSION1757Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/10000000000000_demote-postgres.sql1758GRANT1759GRANT1760GRANT1761GRANT1762GRANT1763GRANT1764GRANT1765GRANT1766GRANT1767DO1768ALTER ROLE1769Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20211115181400_update-auth-permissions.sql1770GRANT1771GRANT1772GRANT1773ALTER TABLE1774ALTER TABLE1775ALTER TABLE1776ALTER TABLE1777ALTER TABLE1778GRANT1779GRANT1780GRANT1781GRANT1782ALTER DEFAULT PRIVILEGES1783ALTER DEFAULT PRIVILEGES1784ALTER DEFAULT PRIVILEGES1785Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20211118015519_create-realtime-schema.sql1786CREATE SCHEMA1787Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20211122051245_update-realtime-permissions.sql1788GRANT1789GRANT1790GRANT1791GRANT1792Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20211124212715_update-auth-owner.sql1793DO1794DO1795DO1796Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20211130151719_update-realtime-permissions.sql1797ALTER DEFAULT PRIVILEGES1798ALTER DEFAULT PRIVILEGES1799ALTER DEFAULT PRIVILEGES1800Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220118070449_enable-safeupdate-postgrest.sql1801ALTER ROLE1802Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220126121436_finer-postgrest-triggers.sql1803psql:/nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220126121436_finer-postgrest-triggers.sql:3: NOTICE: event trigger "api_restart" does not exist, skipping1804DROP EVENT TRIGGER1805psql:/nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220126121436_finer-postgrest-triggers.sql:4: NOTICE: function extensions.notify_api_restart() does not exist, skipping1806DROP FUNCTION1807CREATE FUNCTION1808CREATE FUNCTION1809psql:/nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220126121436_finer-postgrest-triggers.sql:59: NOTICE: event trigger "pgrst_ddl_watch" does not exist, skipping1810DROP EVENT TRIGGER1811CREATE EVENT TRIGGER1812psql:/nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220126121436_finer-postgrest-triggers.sql:64: NOTICE: event trigger "pgrst_drop_watch" does not exist, skipping1813DROP EVENT TRIGGER1814CREATE EVENT TRIGGER1815Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220224211803_fix-postgrest-supautils.sql1816DO1817Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220317095840_pg_graphql.sql1818CREATE SCHEMA1819psql:/nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220317095840_pg_graphql.sql:5: NOTICE: function graphql_public.graphql(text,text,jsonb) does not exist, skipping1820DROP FUNCTION1821CREATE FUNCTION1822GRANT1823ALTER DEFAULT PRIVILEGES1824ALTER DEFAULT PRIVILEGES1825ALTER DEFAULT PRIVILEGES1826ALTER DEFAULT PRIVILEGES1827ALTER DEFAULT PRIVILEGES1828ALTER DEFAULT PRIVILEGES1829CREATE FUNCTION1830psql:/nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220317095840_pg_graphql.sql:90: NOTICE: event trigger "issue_pg_graphql_access" does not exist, skipping1831DROP EVENT TRIGGER1832CREATE EVENT TRIGGER1833COMMENT1834CREATE FUNCTION1835psql:/nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220317095840_pg_graphql.sql:143: NOTICE: event trigger "issue_graphql_placeholder" does not exist, skipping1836DROP EVENT TRIGGER1837CREATE EVENT TRIGGER1838COMMENT1839Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220321174452_fix-postgrest-alter-type-event-trigger.sql1840psql:/nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220321174452_fix-postgrest-alter-type-event-trigger.sql:3: NOTICE: event trigger "api_restart" does not exist, skipping1841DROP EVENT TRIGGER1842psql:/nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220321174452_fix-postgrest-alter-type-event-trigger.sql:4: NOTICE: function extensions.notify_api_restart() does not exist, skipping1843DROP FUNCTION1844CREATE FUNCTION1845CREATE FUNCTION1846DROP EVENT TRIGGER1847CREATE EVENT TRIGGER1848DROP EVENT TRIGGER1849CREATE EVENT TRIGGER1850Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220322085208_gotrue-session-limit.sql1851ALTER ROLE1852Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220404205710_pg_graphql-on-by-default.sql1853CREATE FUNCTION1854CREATE FUNCTION1855CREATE FUNCTION1856psql:/nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220404205710_pg_graphql-on-by-default.sql:142: NOTICE: extension "pg_graphql" does not exist, skipping1857DROP EXTENSION1858DO1859Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220609081115_grant-supabase-auth-admin-and-supabase-storage-admin-to-postgres.sql1860GRANT ROLE1861Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220613123923_pg_graphql-pg-dump-perms.sql1862CREATE FUNCTION1863DROP EXTENSION1864DO1865Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20220713082019_pg_cron-pg_net-temp-perms-fix.sql1866DO1867DO1868Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20221028101028_set_authenticator_timeout.sql1869ALTER ROLE1870Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20221103090837_revoke_admin.sql1871REVOKE ROLE1872Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20221207154255_create_pgsodium_and_vault.sql1873DO1874Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20230201083204_grant_auth_roles_to_postgres.sql1875GRANT ROLE1876Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20230224042246_grant_extensions_perms_for_postgres.sql1877GRANT1878GRANT1879GRANT1880ALTER DEFAULT PRIVILEGES1881ALTER DEFAULT PRIVILEGES1882ALTER DEFAULT PRIVILEGES1883Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20230306081037_grant_pg_monitor_to_postgres.sql1884GRANT ROLE1885Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20230327032006_grant_auth_roles_to_supabase_storage_admin.sql1886GRANT ROLE1887Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20230529180330_alter_api_roles_for_inherit.sql1888ALTER ROLE1889ALTER ROLE1890ALTER ROLE1891DO1892Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20231013070755_grant_authenticator_to_supabase_storage_admin.sql1893GRANT ROLE1894REVOKE ROLE1895Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20231017062225_grant_pg_graphql_permissions_for_custom_roles.sql1896CREATE FUNCTION1897DROP EXTENSION1898DO1899Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20231020085357_revoke_writes_on_cron_job_from_postgres.sql1900DO1901CREATE FUNCTION1902DROP EVENT TRIGGER1903ALTER FUNCTION1904CREATE EVENT TRIGGER1905Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20231130133139_set_lock_timeout_to_authenticator_role.sql1906ALTER ROLE1907Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20240124080435_alter_lo_export_lo_import_owner.sql1908ALTER FUNCTION1909ALTER FUNCTION1910ALTER FUNCTION1911Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20240606060239_grant_predefined_roles_to_postgres.sql1912GRANT ROLE1913Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20241031003909_create_orioledb.sql1914DO1915Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20241215003910_backfill_pgmq_metadata.sql1916DO1917DO1918Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20250205060043_disable_log_statement_on_internal_roles.sql1919ALTER ROLE1920ALTER ROLE1921ALTER ROLE1922Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20250205144616_move_orioledb_to_extensions_schema.sql1923DO1924Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20250218031949_pgsodium_mask_role.sql1925DO1926Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20250220051611_pg_net_perms_fix.sql1927CREATE FUNCTION1928DO1929Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20250312095419_pgbouncer_ownership.sql1930ALTER FUNCTION1931GRANT1932Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20250402065937_alter_internal_event_triggers_owner_to_supabase_admin.sql1933DROP EVENT TRIGGER1934ALTER FUNCTION1935CREATE EVENT TRIGGER1936Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20250402093753_grant_subscription_to_postgres_16_and_above.sql1937DO1938Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20250417190610_update_pgbouncer_get_auth.sql1939CREATE FUNCTION1940GRANT1941Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20250421084701_revoke_admin_roles_from_postgres.sql1942REVOKE ROLE1943DO1944DO1945REVOKE ROLE1946REVOKE1947DO1948Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20250605172253_grant_with_admin_to_postgres_16_and_above.sql1949DO1950Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20250623125453_tmp_grant_storage_tables_to_postgres_with_grant_option.sql1951DO1952Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20250709135250_grant_storage_schema_to_postgres_with_grant_option.sql1953DO1954Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20250710151649_supabase_read_only_user_default_transaction_read_only.sql1955ALTER ROLE1956Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20251001204436_predefined_role_grants.sql1957GRANT ROLE1958DO1959Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20251105172723_grant_pg_reload_conf_to_postgres.sql1960GRANT1961Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20251121132723_correct_search_path_pgbouncer.sql1962CREATE FUNCTION1963REVOKE1964REVOKE1965GRANT1966Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20260211120934_supabase_privileged_role.sql1967DO1968Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20260413000000_fix-authenticator-session-preload-libraries.sql1969ALTER ROLE1970Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20260421000000_pg_graphql-off-by-default.sql1971DROP EXTENSION1972Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20260421000001_rescope_pg_graphql_access_trigger.sql1973CREATE FUNCTION1974DROP EVENT TRIGGER1975CREATE EVENT TRIGGER1976Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20260730000000_revoke_trigger_on_cron_tables_from_postgres.sql1977DO1978CREATE FUNCTION1979Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20260923021047_update_pgrst_watch_triggers.sql1980CREATE FUNCTION1981CREATE FUNCTION1982Running /nix/store/2fhqya3f24gnf6ikxqldp48j5xqvslp3-migrations/migrations/20261016000001_search_path_for_supa_functions.sql1983CREATE FUNCTION1984CREATE FUNCTION1985CREATE FUNCTION1986CREATE FUNCTION1987CREATE FUNCTION1988CREATE FUNCTION1989ALTER DATABASE1990ALTER DATABASE1991ALTER ROLE1992ALTER ROLE1993ALTER ROLE1994ALTER ROLE1995ALTER ROLE1996ALTER ROLE1997ALTER ROLE1998ALTER ROLE1999ALTER ROLE2000ALTER ROLE2001Shutting down PostgreSQL...2002PostgreSQL is running in daemon mode. Please stop it using pg_ctl.2003pg_ctl: another server might be running; trying to start server anyway2004waiting for server to start.... stopped waiting2005pg_ctl: could not start server2006Examine the log output.2007pg_ctl: server is running (PID: 1213)2008/nix/store/m8x106cxyrwf7favnjisvm38xz5wplmn-postgresql-and-plugins-17.11/bin/postgres "-D" "/build/tmp.76QqaMQrDM" "--config-file=/build/tmp.76QqaMQrDM/postgresql.conf" "-p" "5541" "-k" "/build/tmp.76QqaMQrDM/tmp"2009$ pg_isready -h localhost -p 5541 -U supabase_admin -q20102026-11-09 21:29:47 [INFO] PostgreSQL is ready20112026-11-09 21:29:47 [INFO] CLI variant detected - loading CLI prime SQL file2012$ psql -p 5541 -h localhost --no-password --username=supabase_admin -d postgres -v ON_ERROR_STOP=1 -Xf /nix/store/ib75j74vyc0w374jcz7mqcg6njf21yx3-prime-cli.sql2013SET2014CREATE EXTENSION2015CREATE EXTENSION2016CREATE EXTENSION2017CREATE EXTENSION20182026-11-09 21:29:47 [INFO] Creating test_config table for pg_regress tests2019$ psql -p 5541 -h localhost --no-password --username=supabase_admin -d postgres -c 2020 CREATE TABLE IF NOT EXISTS test_config (key TEXT PRIMARY KEY, value TEXT);2021 INSERT INTO test_config (key, value) VALUES ('http_mock_port', '8880')2022 ON CONFLICT (key) DO UPDATE SET value = EXCLUDED.value;2023 INSERT INTO test_config (key, value) VALUES ('http_mock_host', 'localhost')2024 ON CONFLICT (key) DO UPDATE SET value = EXCLUDED.value;20252026CREATE TABLE2027INSERT 0 12028INSERT 0 120292026-11-09 21:29:47 [INFO] CLI variant detected - running subset of pg_regress tests (38 tests)2030$ pg_regress --use-existing --dbname=postgres --inputdir=/nix/store/wmpf35g6g5qk0xyrzwlv10jzs5a4qmqz-tests --outputdir=/nix/store/ip3s1gasrhkdsknmss5hmfcxb6rsx1di-run-check-harness-psql-17-cli/regression_output --host=localhost --port=5541 --user=supabase_admin auth create_statistics_priv dblink docs-array-test docs-cascades-deletes docs-connections docs-enums docs-full-text-search docs-functions docs-indexes docs-json docs-partitioning docs-tables-and-data docs-triggers docs-webhooks enable_tracking event_trigger_search_path intarray_ltree_query ltree_label_overflow multirange_create_priv operator_breaking_change pg-safeupdate pg_graphql pg_net pg_plan_filter pgaudit pgbouncer pgcrypto_cipher_matrix pgsodium realtime replica_identity_upsert storage supautils_reserved_memberships supautils_reserved_roles vault wal2json z_17_intarray_ltree_query z_17_wal_summarize2031(using postmaster on localhost, port 5541)2032============== running regression test queries ==============2033test auth ... ok 18 ms2034test create_statistics_priv ... ok 15 ms2035test dblink ... ok 41 ms2036test docs-array-test ... ok 15 ms2037test docs-cascades-deletes ... ok 78 ms2038test docs-connections ... ok 13 ms2039test docs-enums ... ok 35 ms2040test docs-full-text-search ... ok 31 ms2041test docs-functions ... ok 42 ms2042test docs-indexes ... ok 25 ms2043test docs-json ... ok 17 ms2044test docs-partitioning ... ok 31 ms2045test docs-tables-and-data ... ok 97 ms2046test docs-triggers ... ok 52 ms2047test docs-webhooks ... ok 40 ms2048test enable_tracking ... ok 12 ms2049test event_trigger_search_path ... ok 12 ms2050test intarray_ltree_query ... ok 100 ms2051test ltree_label_overflow ... ok 70 ms2052test multirange_create_priv ... ok 14 ms2053test operator_breaking_change ... ok 39 ms2054test pg-safeupdate ... ok 16 ms2055test pg_graphql ... ok 87 ms2056test pg_net ... ok 13 ms2057test pg_plan_filter ... ok 19 ms2058test pgaudit ... ok 15 ms2059test pgbouncer ... ok 25 ms2060test pgcrypto_cipher_matrix ... ok 29 ms2061test pgsodium ... ok 13 ms2062test realtime ... ok 10 ms2063test replica_identity_upsert ... ok 17 ms2064test storage ... ok 18 ms2065test supautils_reserved_memberships ... FAILED 14 ms2066test supautils_reserved_roles ... ok 11 ms2067test vault ... ok 37 ms2068test wal2json ... ok 23 ms2069test z_17_intarray_ltree_query ... ok 64 ms2070test z_17_wal_summarize ... ok 12 ms20712072=======================2073 1 of 38 tests failed. 2074=======================20752076The differences that caused some tests to fail can be viewed in the2077file "/nix/store/ip3s1gasrhkdsknmss5hmfcxb6rsx1di-run-check-harness-psql-17-cli/regression_output/regression.diffs". A copy of the test summary that you see2078above is saved in the file "/nix/store/ip3s1gasrhkdsknmss5hmfcxb6rsx1di-run-check-harness-psql-17-cli/regression_output/regression.out".207920802026-11-09 21:29:48 [ERROR] pg_regress tests failed20812026-11-09 21:29:48 [ERROR] An error occurred. Exit code: 120822026-11-09 21:29:48 [ERROR] Debug logs: