Hello, I have built IvorySQL from source and I try to run "install makecheck". It fails on: make[5]: Entering directory '/home/pierre/IvorySQL/src/common' make[5]: Nothing to be done for 'all'. make[5]: Leaving directory '/home/pierre/IvorySQL/src/common' make[4]: Leaving directory '/home/pierre/IvorySQL/src/test/regress' echo "# +++ regress install-check in src/pl/plpgsql/src +++" && ../../../../src/test/regress/pg_regress --inputdir=. --bindir='/usr/local/ivorysql/ivorysql-5/bin' --dbname=pl_regression plpgsql_array plpgsql_cache plpgsql_call plpgsql_control plpgsql_copy plpgsql_domain plpgsql_misc plpgsql_record plpgsql_simple plpgsql_transaction plpgsql_trap plpgsql_trigger plpgsql_varprops # +++ regress install-check in src/pl/plpgsql/src +++ # using postmaster on Unix socket, default port not ok 1 - plpgsql_array 24 ms ok 2 - plpgsql_cache 13 ms not ok 3 - plpgsql_call 52 ms not ok 4 - plpgsql_control 47 ms ok 5 - plpgsql_copy 30 ms ok 6 - plpgsql_domain 48 ms ok 7 - plpgsql_misc 11 ms not ok 8 - plpgsql_record 117 ms ok 9 - plpgsql_simple 25 ms ok 10 - plpgsql_transaction 109 ms ok 11 - plpgsql_trap 1060 ms ok 12 - plpgsql_trigger 13 ms not ok 13 - plpgsql_varprops 15 ms 1..13 # 5 of 13 tests failed. # The differences that caused some tests to fail can be viewed in the file "/home/pierre/IvorySQL/src/pl/plpgsql/src/regression.diffs". # A copy of the test summary that you see above is saved in the file "/home/pierre/IvorySQL/src/pl/plpgsql/src/regression.out". make[3]: *** [Makefile:101: installcheck] Error 1 make[3]: Leaving directory '/home/pierre/IvorySQL/src/pl/plpgsql/src' make[2]: *** [Makefile:17: installcheck-src-recurse] Error 2 make[2]: Leaving directory '/home/pierre/IvorySQL/src/pl/plpgsql' make[1]: *** [Makefile:36: installcheck-plpgsql-recurse] Error 2 make[1]: Leaving directory '/home/pierre/IvorySQL/src/pl' make: *** [Makefile:48: installcheck-pl-recurse] Error 2 Example of edtailed error messages: diff -U3 /home/pierre/IvorySQL/src/pl/plpgsql/src/expected/plpgsql_array.out /home/pierre/IvorySQL/src/pl/plpgsql/src/results/plpgsql_array.out --- /home/pierre/IvorySQL/src/pl/plpgsql/src/expected/plpgsql_array.out 2026-01-23 10:15:32.156479475 +0100 +++ /home/pierre/IvorySQL/src/pl/plpgsql/src/results/plpgsql_array.out 2026-01-23 15:25:17.283892995 +0100 @@ -11,43 +11,57 @@ NOTICE: a = {1,2,4} do $$ declare a int[]; begin a := array[1,2]; a[3] := 4; raise notice 'a = %', a; end$$ language plisql; -NOTICE: a = {1,2,4} +ERROR: when ivorysql.compatible_mode is pg, not support a plisql procedural-language function statement +LINE 2: begin a := array[1,2]; a[3] := 4; raise notice 'a = %', a; e... + ^ do $$ declare a int[]; begin a[3] := 4; raise notice 'a = %', a; end$$ language plpgsql; NOTICE: a = [3:3]={4} do $$ declare a int[]; begin a[3] := 4; raise notice 'a = %', a; end$$ language plisql; -NOTICE: a = [3:3]={4} +ERROR: when ivorysql.compatible_mode is pg, not support a plisql procedural-language function statement +LINE 2: begin a[3] := 4; raise notice 'a = %', a; end$$ language pli... + ^ It looks like that make installcheck needs an already running PG instance. Is this correct ? In this case I understand this is due to the fact that I cannot create a PG instance running in Oracle mode: see https://github.com/IvorySQL/IvorySQL/issues/1171
Hi Pierre, I replied to your confusion in issues/1171, hope it helps. see https://github.com/IvorySQL/IvorySQL/issues/1171 Regards, JiaoShuntian
Hi, Yes it has helped: I was able to run "make installcheck" without errors. I have closed the issue. Thanks and regards. Pierre
participants (2)
-
jiaoshuntian@highgo.com -
Pierre Forstmann