supabase-postgres.git / summary / log / commit / refs

commit    47d598f6be65cd5b920ae807cf98c401ed5ae045
Author:   Oliver Rice <github@oliverrice.com>
Commit:   Div Arora <darora@users.noreply.github.com>
Date:     Mon Aug 05 21:30:47 2024 +0000

    whitesapce cleanup


flake.nix | 5 ++--- nix/tests/expected/postgis_sql_interface.out | 12 ++++++------ nix/tests/sql/postgis_sql_interface.sql | 12 ++++++------ 3 files changed, 14 insertions(+), 15 deletions(-) diff --git a/flake.nix b/flake.nix index b44c68d8..5fb3dc0c 100644 --- a/flake.nix +++ b/flake.nix @@ -418,10 +418,9 @@ createdb -p 5432 -h localhost testing psql -p 5432 -h localhost -d testing -Xaf ${./nix/tests/prime.sql} + pg_prove -p 5432 -h localhost -d testing ${sqlTests}/*.sql - #pg_prove -p 5432 -h localhost -d testing ${sqlTests}/*.sql - - mkdir -p $out/regression_output + mkdir -p $out/regression_output pg_regress \ --use-existing \ --dbname=testing \ diff --git a/nix/tests/expected/postgis_sql_interface.out b/nix/tests/expected/postgis_sql_interface.out index 4065a18a..f728cdbb 100644 --- a/nix/tests/expected/postgis_sql_interface.out +++ b/nix/tests/expected/postgis_sql_interface.out @@ -5,12 +5,12 @@ select pg_catalog.pg_get_function_result(p.oid) as return_type from pg_catalog.pg_proc p - join pg_catalog.pg_namespace n - on n.oid = p.pronamespace - join pg_catalog.pg_depend d - on d.objid = p.oid - join pg_catalog.pg_extension e - on e.oid = d.refobjid + join pg_catalog.pg_namespace n + on n.oid = p.pronamespace + join pg_catalog.pg_depend d + on d.objid = p.oid + join pg_catalog.pg_extension e + on e.oid = d.refobjid where e.extname = 'postgis' -- replace with your extension name and n.nspname = 'public' diff --git a/nix/tests/sql/postgis_sql_interface.sql b/nix/tests/sql/postgis_sql_interface.sql index 418635c5..2ac13101 100644 --- a/nix/tests/sql/postgis_sql_interface.sql +++ b/nix/tests/sql/postgis_sql_interface.sql @@ -5,12 +5,12 @@ select pg_catalog.pg_get_function_result(p.oid) as return_type from pg_catalog.pg_proc p - join pg_catalog.pg_namespace n - on n.oid = p.pronamespace - join pg_catalog.pg_depend d - on d.objid = p.oid - join pg_catalog.pg_extension e - on e.oid = d.refobjid + join pg_catalog.pg_namespace n + on n.oid = p.pronamespace + join pg_catalog.pg_depend d + on d.objid = p.oid + join pg_catalog.pg_extension e + on e.oid = d.refobjid where e.extname = 'postgis' -- replace with your extension name and n.nspname = 'public' [parent: a9162bfc310b]