2025-01-05 17:27:08.584 UTC postmaster[16085] LOG: starting PostgreSQL 18devel on x86_64-freebsd, compiled by clang-17.0.6, 64-bit 2025-01-05 17:27:08.584 UTC postmaster[16085] LOG: listening on Unix socket "/tmp/pg_regress-7tF6Kk/.s.PGSQL.40003" 2025-01-05 17:27:08.585 UTC startup[16088] LOG: database system was shut down at 2025-01-05 17:27:08 UTC 2025-01-05 17:27:08.586 UTC postmaster[16085] LOG: database system is ready to accept connections 2025-01-05 17:27:08.775 UTC client backend[16105] pg_regress/pltcl_queries ERROR: value for domain d_comp1 violates check constraint "d_comp1_check" 2025-01-05 17:27:08.775 UTC client backend[16105] pg_regress/pltcl_queries STATEMENT: select tcl_cdomain_arg(row('tkey', -1, 'ref2')); 2025-01-05 17:27:08.776 UTC client backend[16105] pg_regress/pltcl_queries ERROR: invalid command name "returm" 2025-01-05 17:27:08.776 UTC client backend[16105] pg_regress/pltcl_queries CONTEXT: while executing "returm 1" (procedure "__PLTcl_proc_tcl_error" line 2) invoked from within "__PLTcl_proc_tcl_error" in PL/Tcl function tcl_error() 2025-01-05 17:27:08.776 UTC client backend[16105] pg_regress/pltcl_queries STATEMENT: select tcl_error(); 2025-01-05 17:27:08.777 UTC client backend[16105] pg_regress/pltcl_queries ERROR: column name/value list must have even number of elements 2025-01-05 17:27:08.777 UTC client backend[16105] pg_regress/pltcl_queries STATEMENT: select bad_record(); 2025-01-05 17:27:08.777 UTC client backend[16105] pg_regress/pltcl_queries ERROR: column name/value list contains nonexistent column name "cow" 2025-01-05 17:27:08.777 UTC client backend[16105] pg_regress/pltcl_queries STATEMENT: select bad_field(); 2025-01-05 17:27:08.779 UTC client backend[16105] pg_regress/pltcl_queries ERROR: return_next cannot be used in non-set-returning functions 2025-01-05 17:27:08.779 UTC client backend[16105] pg_regress/pltcl_queries CONTEXT: while executing "return_next 1" (procedure "__PLTcl_proc_non_srf" line 2) invoked from within "__PLTcl_proc_non_srf" in PL/Tcl function non_srf() 2025-01-05 17:27:08.779 UTC client backend[16105] pg_regress/pltcl_queries STATEMENT: select non_srf(); 2025-01-05 17:27:08.779 UTC client backend[16105] pg_regress/pltcl_queries ERROR: column name/value list must have even number of elements 2025-01-05 17:27:08.779 UTC client backend[16105] pg_regress/pltcl_queries CONTEXT: while executing "return_next [list a]" (procedure "__PLTcl_proc_bad_record_srf" line 3) invoked from within "__PLTcl_proc_bad_record_srf" in PL/Tcl function bad_record_srf() 2025-01-05 17:27:08.779 UTC client backend[16105] pg_regress/pltcl_queries STATEMENT: select bad_record_srf(); 2025-01-05 17:27:08.780 UTC client backend[16105] pg_regress/pltcl_queries ERROR: column name/value list contains nonexistent column name "cow" 2025-01-05 17:27:08.780 UTC client backend[16105] pg_regress/pltcl_queries CONTEXT: while executing "return_next [list a 1 b 2 cow 3]" (procedure "__PLTcl_proc_bad_field_srf" line 3) invoked from within "__PLTcl_proc_bad_field_srf" in PL/Tcl function bad_field_srf() 2025-01-05 17:27:08.780 UTC client backend[16105] pg_regress/pltcl_queries STATEMENT: select bad_field_srf(); 2025-01-05 17:27:08.781 UTC client backend[16105] pg_regress/pltcl_queries ERROR: value for domain d_comp1 violates check constraint "d_comp1_check" 2025-01-05 17:27:08.781 UTC client backend[16105] pg_regress/pltcl_queries STATEMENT: select * from tcl_dcomposite_result(-1); 2025-01-05 17:27:08.782 UTC client backend[16105] pg_regress/pltcl_queries ERROR: function returning record called in context that cannot accept type record 2025-01-05 17:27:08.782 UTC client backend[16105] pg_regress/pltcl_queries STATEMENT: select tcl_record_result(42); 2025-01-05 17:27:08.782 UTC client backend[16105] pg_regress/pltcl_queries ERROR: a column definition list is required for functions returning "record" at character 15 2025-01-05 17:27:08.782 UTC client backend[16105] pg_regress/pltcl_queries STATEMENT: select * from tcl_record_result(42); 2025-01-05 17:27:08.782 UTC client backend[16105] pg_regress/pltcl_queries ERROR: column name/value list contains nonexistent column name "q3" 2025-01-05 17:27:08.782 UTC client backend[16105] pg_regress/pltcl_queries STATEMENT: select * from tcl_record_result(42) as (q1 text, q2 int, q4 int); 2025-01-05 17:27:08.783 UTC client backend[16105] pg_regress/pltcl_queries ERROR: wrong # args: should be "quote string" 2025-01-05 17:27:08.783 UTC client backend[16105] pg_regress/pltcl_queries CONTEXT: while executing "quote foo bar" ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text {quote foo bar}" in PL/Tcl function tcl_eval(text) 2025-01-05 17:27:08.783 UTC client backend[16105] pg_regress/pltcl_queries STATEMENT: select tcl_eval('quote foo bar'); 2025-01-05 17:27:08.783 UTC client backend[16105] pg_regress/pltcl_queries ERROR: wrong # args: should be "argisnull argno" 2025-01-05 17:27:08.783 UTC client backend[16105] pg_regress/pltcl_queries CONTEXT: while executing "argisnull" ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text argisnull" in PL/Tcl function tcl_eval(text) 2025-01-05 17:27:08.783 UTC client backend[16105] pg_regress/pltcl_queries STATEMENT: select tcl_eval('argisnull'); 2025-01-05 17:27:08.783 UTC client backend[16105] pg_regress/pltcl_queries ERROR: argno out of range 2025-01-05 17:27:08.783 UTC client backend[16105] pg_regress/pltcl_queries CONTEXT: while executing "argisnull 14" ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text {argisnull 14}" in PL/Tcl function tcl_eval(text) 2025-01-05 17:27:08.783 UTC client backend[16105] pg_regress/pltcl_queries STATEMENT: select tcl_eval('argisnull 14'); 2025-01-05 17:27:08.783 UTC client backend[16105] pg_regress/pltcl_queries ERROR: expected integer but got "abc" 2025-01-05 17:27:08.783 UTC client backend[16105] pg_regress/pltcl_queries CONTEXT: while executing "argisnull abc" ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text {argisnull abc}" in PL/Tcl function tcl_eval(text) 2025-01-05 17:27:08.783 UTC client backend[16105] pg_regress/pltcl_queries STATEMENT: select tcl_eval('argisnull abc'); 2025-01-05 17:27:08.783 UTC client backend[16105] pg_regress/pltcl_queries ERROR: wrong # args: should be "return_null " 2025-01-05 17:27:08.783 UTC client backend[16105] pg_regress/pltcl_queries CONTEXT: while executing "return_null 14" ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text {return_null 14}" in PL/Tcl function tcl_eval(text) 2025-01-05 17:27:08.783 UTC client backend[16105] pg_regress/pltcl_queries STATEMENT: select tcl_eval('return_null 14'); 2025-01-05 17:27:08.783 UTC client backend[16105] pg_regress/pltcl_queries ERROR: wrong # args: should be "spi_exec ?-count n? ?-array name? query ?loop body?" 2025-01-05 17:27:08.783 UTC client backend[16105] pg_regress/pltcl_queries CONTEXT: while executing "spi_exec" ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text spi_exec" in PL/Tcl function tcl_eval(text) 2025-01-05 17:27:08.783 UTC client backend[16105] pg_regress/pltcl_queries STATEMENT: select tcl_eval('spi_exec'); 2025-01-05 17:27:08.784 UTC client backend[16105] pg_regress/pltcl_queries ERROR: missing argument to -count or -array 2025-01-05 17:27:08.784 UTC client backend[16105] pg_regress/pltcl_queries CONTEXT: while executing "spi_exec -count" ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text {spi_exec -count}" in PL/Tcl function tcl_eval(text) 2025-01-05 17:27:08.784 UTC client backend[16105] pg_regress/pltcl_queries STATEMENT: select tcl_eval('spi_exec -count'); 2025-01-05 17:27:08.784 UTC client backend[16105] pg_regress/pltcl_queries ERROR: missing argument to -count or -array 2025-01-05 17:27:08.784 UTC client backend[16105] pg_regress/pltcl_queries CONTEXT: while executing "spi_exec -array" ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text {spi_exec -array}" in PL/Tcl function tcl_eval(text) 2025-01-05 17:27:08.784 UTC client backend[16105] pg_regress/pltcl_queries STATEMENT: select tcl_eval('spi_exec -array'); 2025-01-05 17:27:08.784 UTC client backend[16105] pg_regress/pltcl_queries ERROR: expected integer but got "abc" 2025-01-05 17:27:08.784 UTC client backend[16105] pg_regress/pltcl_queries CONTEXT: while executing "spi_exec -count abc" ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text {spi_exec -count abc}" in PL/Tcl function tcl_eval(text) 2025-01-05 17:27:08.784 UTC client backend[16105] pg_regress/pltcl_queries STATEMENT: select tcl_eval('spi_exec -count abc'); 2025-01-05 17:27:08.784 UTC client backend[16105] pg_regress/pltcl_queries ERROR: wrong # args: should be "query ?loop body?" 2025-01-05 17:27:08.784 UTC client backend[16105] pg_regress/pltcl_queries CONTEXT: while executing "spi_exec query loop body toomuch" ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text {spi_exec query loop body toomuch}" in PL/Tcl function tcl_eval(text) 2025-01-05 17:27:08.784 UTC client backend[16105] pg_regress/pltcl_queries STATEMENT: select tcl_eval('spi_exec query loop body toomuch'); 2025-01-05 17:27:08.784 UTC client backend[16105] pg_regress/pltcl_queries ERROR: pltcl: SPI_execute failed: SPI_ERROR_TRANSACTION 2025-01-05 17:27:08.784 UTC client backend[16105] pg_regress/pltcl_queries CONTEXT: while executing "spi_exec "begin; rollback;"" ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text {spi_exec "begin; rollback;"}" in PL/Tcl function tcl_eval(text) 2025-01-05 17:27:08.784 UTC client backend[16105] pg_regress/pltcl_queries STATEMENT: select tcl_eval('spi_exec "begin; rollback;"'); 2025-01-05 17:27:08.784 UTC client backend[16105] pg_regress/pltcl_queries ERROR: missing argument to -count or -array 2025-01-05 17:27:08.784 UTC client backend[16105] pg_regress/pltcl_queries CONTEXT: while executing "spi_execp" ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text spi_execp" in PL/Tcl function tcl_eval(text) 2025-01-05 17:27:08.784 UTC client backend[16105] pg_regress/pltcl_queries STATEMENT: select tcl_eval('spi_execp'); 2025-01-05 17:27:08.784 UTC client backend[16105] pg_regress/pltcl_queries ERROR: missing argument to -array, -count or -nulls 2025-01-05 17:27:08.784 UTC client backend[16105] pg_regress/pltcl_queries CONTEXT: while executing "spi_execp -count" ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text {spi_execp -count}" in PL/Tcl function tcl_eval(text) 2025-01-05 17:27:08.784 UTC client backend[16105] pg_regress/pltcl_queries STATEMENT: select tcl_eval('spi_execp -count'); 2025-01-05 17:27:08.784 UTC client backend[16105] pg_regress/pltcl_queries ERROR: missing argument to -array, -count or -nulls 2025-01-05 17:27:08.784 UTC client backend[16105] pg_regress/pltcl_queries CONTEXT: while executing "spi_execp -array" ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text {spi_execp -array}" in PL/Tcl function tcl_eval(text) 2025-01-05 17:27:08.784 UTC client backend[16105] pg_regress/pltcl_queries STATEMENT: select tcl_eval('spi_execp -array'); 2025-01-05 17:27:08.785 UTC client backend[16105] pg_regress/pltcl_queries ERROR: expected integer but got "abc" 2025-01-05 17:27:08.785 UTC client backend[16105] pg_regress/pltcl_queries CONTEXT: while executing "spi_execp -count abc" ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text {spi_execp -count abc}" in PL/Tcl function tcl_eval(text) 2025-01-05 17:27:08.785 UTC client backend[16105] pg_regress/pltcl_queries STATEMENT: select tcl_eval('spi_execp -count abc'); 2025-01-05 17:27:08.785 UTC client backend[16105] pg_regress/pltcl_queries ERROR: missing argument to -array, -count or -nulls 2025-01-05 17:27:08.785 UTC client backend[16105] pg_regress/pltcl_queries CONTEXT: while executing "spi_execp -nulls" ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text {spi_execp -nulls}" in PL/Tcl function tcl_eval(text) 2025-01-05 17:27:08.785 UTC client backend[16105] pg_regress/pltcl_queries STATEMENT: select tcl_eval('spi_execp -nulls'); 2025-01-05 17:27:08.785 UTC client backend[16105] pg_regress/pltcl_queries ERROR: invalid queryid '' 2025-01-05 17:27:08.785 UTC client backend[16105] pg_regress/pltcl_queries CONTEXT: while executing "spi_execp """ ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text {spi_execp ""}" in PL/Tcl function tcl_eval(text) 2025-01-05 17:27:08.785 UTC client backend[16105] pg_regress/pltcl_queries STATEMENT: select tcl_eval('spi_execp ""'); 2025-01-05 17:27:08.785 UTC client backend[16105] pg_regress/pltcl_queries ERROR: wrong # args: should be "spi_prepare query argtypes" 2025-01-05 17:27:08.785 UTC client backend[16105] pg_regress/pltcl_queries CONTEXT: while executing "spi_prepare" ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text spi_prepare" in PL/Tcl function tcl_eval(text) 2025-01-05 17:27:08.785 UTC client backend[16105] pg_regress/pltcl_queries STATEMENT: select tcl_eval('spi_prepare'); 2025-01-05 17:27:08.785 UTC client backend[16105] pg_regress/pltcl_queries ERROR: type "b" does not exist 2025-01-05 17:27:08.785 UTC client backend[16105] pg_regress/pltcl_queries CONTEXT: while executing "spi_prepare a b" ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text {spi_prepare a b}" in PL/Tcl function tcl_eval(text) 2025-01-05 17:27:08.785 UTC client backend[16105] pg_regress/pltcl_queries STATEMENT: select tcl_eval('spi_prepare a b'); 2025-01-05 17:27:08.785 UTC client backend[16105] pg_regress/pltcl_queries ERROR: unmatched open brace in list 2025-01-05 17:27:08.785 UTC client backend[16105] pg_regress/pltcl_queries CONTEXT: while executing "spi_prepare a "b {"" ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text spi_prepare\ a\ \"b\ \{\"" in PL/Tcl function tcl_eval(text) 2025-01-05 17:27:08.785 UTC client backend[16105] pg_regress/pltcl_queries STATEMENT: select tcl_eval('spi_prepare a "b {"'); 2025-01-05 17:27:08.787 UTC client backend[16105] pg_regress/pltcl_queries ERROR: wrong # args: should be "elog level msg" 2025-01-05 17:27:08.787 UTC client backend[16105] pg_regress/pltcl_queries CONTEXT: while executing "elog" ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text elog" in PL/Tcl function tcl_eval(text) 2025-01-05 17:27:08.787 UTC client backend[16105] pg_regress/pltcl_queries STATEMENT: select tcl_eval('elog'); 2025-01-05 17:27:08.787 UTC client backend[16105] pg_regress/pltcl_queries ERROR: bad priority "foo": must be DEBUG, LOG, INFO, NOTICE, WARNING, ERROR, or FATAL 2025-01-05 17:27:08.787 UTC client backend[16105] pg_regress/pltcl_queries CONTEXT: while executing "elog foo bar" ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text {elog foo bar}" in PL/Tcl function tcl_eval(text) 2025-01-05 17:27:08.787 UTC client backend[16105] pg_regress/pltcl_queries STATEMENT: select tcl_eval('elog foo bar'); 2025-01-05 17:27:08.787 UTC client backend[16105] pg_regress/pltcl_queries ERROR: forced error 2025-01-05 17:27:08.787 UTC client backend[16105] pg_regress/pltcl_queries CONTEXT: while executing "error "forced error"" ("eval" body line 1) invoked from within "eval $1" (procedure "__PLTcl_proc_tcl_eval_text" line 3) invoked from within "__PLTcl_proc_tcl_eval_text {error "forced error"}" in PL/Tcl function tcl_eval(text) 2025-01-05 17:27:08.787 UTC client backend[16105] pg_regress/pltcl_queries STATEMENT: select tcl_eval('error "forced error"'); 2025-01-05 17:27:08.789 UTC client backend[16105] pg_regress/pltcl_queries ERROR: error message 2025-01-05 17:27:08.789 UTC client backend[16105] pg_regress/pltcl_queries CONTEXT: while executing "error "error message"" invoked from within "spi_execp -array A $prep { elog NOTICE "col1 $A(col1), col2 $A(col2)" switch $A(col1) { 2 { elog NOTICE "..." (procedure "__PLTcl_proc_tcl_spi_exec_boolean_text" line 6) invoked from within "__PLTcl_proc_tcl_spi_exec_boolean_text t error" in PL/Tcl function tcl_spi_exec(boolean,text) 2025-01-05 17:27:08.789 UTC client backend[16105] pg_regress/pltcl_queries STATEMENT: select tcl_spi_exec(true, 'error'); 2025-01-05 17:27:08.790 UTC client backend[16105] pg_regress/pltcl_queries ERROR: error message 2025-01-05 17:27:08.790 UTC client backend[16105] pg_regress/pltcl_queries CONTEXT: while executing "error "error message"" invoked from within "spi_exec -array A $query { elog NOTICE "col1 $A(col1), col2 $A(col2)" switch $A(col1) { 2 { elog NOTICE "..." (procedure "__PLTcl_proc_tcl_spi_exec_boolean_text" line 31) invoked from within "__PLTcl_proc_tcl_spi_exec_boolean_text f error" in PL/Tcl function tcl_spi_exec(boolean,text) 2025-01-05 17:27:08.790 UTC client backend[16105] pg_regress/pltcl_queries STATEMENT: select tcl_spi_exec(false, 'error'); 2025-01-05 17:27:08.929 UTC client backend[16110] pg_regress/pltcl_trigger ERROR: duplicate key '1', 'KEY1-3' for T_pkey2 2025-01-05 17:27:08.929 UTC client backend[16110] pg_regress/pltcl_trigger CONTEXT: while executing "elog ERROR "duplicate key '$NEW(key1)', '$NEW(key2)' for T_pkey2"" invoked from within "if {$n > 0} { elog ERROR \ "duplicate key '$NEW(key1)', '$NEW(key2)' for T_pkey2" }" (procedure "__PLTcl_trigger_trig_pkey2_before" line 32) invoked from within "__PLTcl_trigger_trig_pkey2_before pkey2_before 16454 t_pkey2 public {{} key1 key2 txt} BEFORE ROW INSERT {key1 1 key2 {KEY1-3 } txt {shou..." in PL/Tcl function trig_pkey2_before() 2025-01-05 17:27:08.929 UTC client backend[16110] pg_regress/pltcl_trigger STATEMENT: insert into T_pkey2 values (1, 'KEY1-3', 'should fail'); 2025-01-05 17:27:08.935 UTC client backend[16110] pg_regress/pltcl_trigger ERROR: key for t_dta1 not in t_pkey1 2025-01-05 17:27:08.935 UTC client backend[16110] pg_regress/pltcl_trigger CONTEXT: while executing "elog ERROR "key for $GD($planrel) not in $keyrel"" (procedure "__PLTcl_trigger_check_primkey" line 92) invoked from within "__PLTcl_trigger_check_primkey dta1_before 16457 t_dta1 public {{} tkey ref1 ref2} BEFORE ROW INSERT {tkey {trec 4 } ref1 1 ref2 {key1-4 ..." in PL/Tcl function check_primkey() 2025-01-05 17:27:08.935 UTC client backend[16110] pg_regress/pltcl_trigger STATEMENT: insert into T_dta1 values ('trec 4', 1, 'key1-4'); 2025-01-05 17:27:08.939 UTC client backend[16110] pg_regress/pltcl_trigger ERROR: key for t_dta2 not in t_pkey2 2025-01-05 17:27:08.939 UTC client backend[16110] pg_regress/pltcl_trigger CONTEXT: while executing "elog ERROR "key for $GD($planrel) not in $keyrel"" (procedure "__PLTcl_trigger_check_primkey" line 92) invoked from within "__PLTcl_trigger_check_primkey dta2_before 16460 t_dta2 public {{} tkey ref1 ref2} BEFORE ROW INSERT {tkey {trec 4 } ref1 1 ref2 {KEY1-4 ..." in PL/Tcl function check_primkey() 2025-01-05 17:27:08.939 UTC client backend[16110] pg_regress/pltcl_trigger STATEMENT: insert into T_dta2 values ('trec 4', 1, 'KEY1-4'); 2025-01-05 17:27:08.941 UTC client backend[16110] pg_regress/pltcl_trigger ERROR: key '1', 'key1-1 ' referenced by T_dta1 2025-01-05 17:27:08.941 UTC client backend[16110] pg_regress/pltcl_trigger CONTEXT: while executing "elog ERROR "key '$OLD(key1)', '$OLD(key2)' referenced by T_dta1"" invoked from within "if {$check_old_ref} { # # Check for references to OLD # set n [spi_execp -count 1 $GD(plan_dta1) [list $OLD(key1) $OLD(key2)]] if {$n > 0}..." (procedure "__PLTcl_trigger_trig_pkey1_before" line 79) invoked from within "__PLTcl_trigger_trig_pkey1_before pkey1_before 16451 t_pkey1 public {{} key1 key2 txt} BEFORE ROW UPDATE {key1 1 key2 {key1-9 } txt {test..." in PL/Tcl function trig_pkey1_before() 2025-01-05 17:27:08.941 UTC client backend[16110] pg_regress/pltcl_trigger STATEMENT: update T_pkey1 set key2 = 'key1-9' where key1 = 1 and key2 = 'key1-1'; 2025-01-05 17:27:08.943 UTC client backend[16110] pg_regress/pltcl_trigger ERROR: key '1', 'key1-2 ' referenced by T_dta1 2025-01-05 17:27:08.943 UTC client backend[16110] pg_regress/pltcl_trigger CONTEXT: while executing "elog ERROR "key '$OLD(key1)', '$OLD(key2)' referenced by T_dta1"" invoked from within "if {$check_old_ref} { # # Check for references to OLD # set n [spi_execp -count 1 $GD(plan_dta1) [list $OLD(key1) $OLD(key2)]] if {$n > 0}..." (procedure "__PLTcl_trigger_trig_pkey1_before" line 79) invoked from within "__PLTcl_trigger_trig_pkey1_before pkey1_before 16451 t_pkey1 public {{} key1 key2 txt} BEFORE ROW DELETE {} {key1 1 key2 {key1-2 } txt {t..." in PL/Tcl function trig_pkey1_before() 2025-01-05 17:27:08.943 UTC client backend[16110] pg_regress/pltcl_trigger STATEMENT: delete from T_pkey1 where key1 = 1 and key2 = 'key1-2'; 2025-01-05 17:27:08.962 UTC client backend[16110] pg_regress/pltcl_trigger ERROR: argisnull cannot be used in triggers 2025-01-05 17:27:08.962 UTC client backend[16110] pg_regress/pltcl_trigger CONTEXT: while executing "argisnull 1" (procedure "__PLTcl_trigger_trigger_data" line 19) invoked from within "__PLTcl_trigger_trigger_data show_trigger_data_trig 16464 trigger_test public {{} i v {} test_skip test_return_null test_argisnull} BEFORE ROW INSERT ..." in PL/Tcl function trigger_data() 2025-01-05 17:27:08.962 UTC client backend[16110] pg_regress/pltcl_trigger STATEMENT: insert into trigger_test(test_argisnull) values(true); 2025-01-05 17:27:08.963 UTC client backend[16110] pg_regress/pltcl_trigger ERROR: return_null cannot be used in triggers 2025-01-05 17:27:08.963 UTC client backend[16110] pg_regress/pltcl_trigger CONTEXT: while executing "return_null" (procedure "__PLTcl_trigger_trigger_data" line 16) invoked from within "__PLTcl_trigger_trigger_data show_trigger_data_trig 16464 trigger_test public {{} i v {} test_skip test_return_null test_argisnull} BEFORE ROW INSERT ..." in PL/Tcl function trigger_data() 2025-01-05 17:27:08.963 UTC client backend[16110] pg_regress/pltcl_trigger STATEMENT: insert into trigger_test(test_return_null) values(true); 2025-01-05 17:27:08.969 UTC client backend[16110] pg_regress/pltcl_trigger ERROR: cannot set generated column "j" 2025-01-05 17:27:08.969 UTC client backend[16110] pg_regress/pltcl_trigger STATEMENT: INSERT INTO trigger_test_generated (i) VALUES (1); 2025-01-05 17:27:08.987 UTC client backend[16115] pg_regress/pltcl_call ERROR: could not parse function return value: list element in braces followed by ")" instead of space 2025-01-05 17:27:08.987 UTC client backend[16115] pg_regress/pltcl_call STATEMENT: CALL test_proc10('abc'); 2025-01-05 17:27:08.999 UTC client backend[16118] pg_regress/pltcl_start_proc ERROR: function no_such_function() does not exist 2025-01-05 17:27:08.999 UTC client backend[16118] pg_regress/pltcl_start_proc CONTEXT: processing pltcl.start_proc parameter 2025-01-05 17:27:08.999 UTC client backend[16118] pg_regress/pltcl_start_proc STATEMENT: select tcl_int4add(1, 2); 2025-01-05 17:27:09.000 UTC client backend[16118] pg_regress/pltcl_start_proc ERROR: function no_such_function() does not exist 2025-01-05 17:27:09.000 UTC client backend[16118] pg_regress/pltcl_start_proc CONTEXT: processing pltcl.start_proc parameter 2025-01-05 17:27:09.000 UTC client backend[16118] pg_regress/pltcl_start_proc STATEMENT: select tcl_int4add(1, 2); 2025-01-05 17:27:09.001 UTC client backend[16118] pg_regress/pltcl_start_proc ERROR: function "public.tcl_initialize" must not be SECURITY DEFINER 2025-01-05 17:27:09.001 UTC client backend[16118] pg_regress/pltcl_start_proc CONTEXT: processing pltcl.start_proc parameter 2025-01-05 17:27:09.001 UTC client backend[16118] pg_regress/pltcl_start_proc STATEMENT: select tcl_int4add(1, 2); 2025-01-05 17:27:09.058 UTC client backend[16127] pg_regress/pltcl_transaction ERROR: invalid transaction termination 2025-01-05 17:27:09.058 UTC client backend[16127] pg_regress/pltcl_transaction CONTEXT: while executing "commit" (procedure "__PLTcl_proc_transaction_test2" line 6) invoked from within "__PLTcl_proc_transaction_test2" in PL/Tcl function transaction_test2() 2025-01-05 17:27:09.058 UTC client backend[16127] pg_regress/pltcl_transaction STATEMENT: SELECT transaction_test2(); 2025-01-05 17:27:09.059 UTC client backend[16127] pg_regress/pltcl_transaction ERROR: invalid transaction termination 2025-01-05 17:27:09.059 UTC client backend[16127] pg_regress/pltcl_transaction CONTEXT: while executing "commit" (procedure "__PLTcl_proc_transaction_test1" line 6) invoked from within "__PLTcl_proc_transaction_test1" invoked from within "spi_exec "CALL transaction_test1()"" (procedure "__PLTcl_proc_transaction_test3" line 3) invoked from within "__PLTcl_proc_transaction_test3" in PL/Tcl function transaction_test3() 2025-01-05 17:27:09.059 UTC client backend[16127] pg_regress/pltcl_transaction STATEMENT: SELECT transaction_test3(); 2025-01-05 17:27:09.063 UTC client backend[16127] pg_regress/pltcl_transaction ERROR: cannot commit while a subtransaction is active 2025-01-05 17:27:09.063 UTC client backend[16127] pg_regress/pltcl_transaction CONTEXT: while executing "commit" invoked from within "spi_exec -array row "SELECT * FROM test2 ORDER BY x" { spi_exec "INSERT INTO test1 (a) VALUES ($row(x))" commit }" (procedure "__PLTcl_proc_transaction_test4a" line 3) invoked from within "__PLTcl_proc_transaction_test4a" in PL/Tcl function transaction_test4a() 2025-01-05 17:27:09.063 UTC client backend[16127] pg_regress/pltcl_transaction STATEMENT: CALL transaction_test4a(); 2025-01-05 17:27:09.065 UTC client backend[16127] pg_regress/pltcl_transaction ERROR: cannot roll back while a subtransaction is active 2025-01-05 17:27:09.065 UTC client backend[16127] pg_regress/pltcl_transaction CONTEXT: while executing "rollback" invoked from within "spi_exec -array row "SELECT * FROM test2 ORDER BY x" { spi_exec "INSERT INTO test1 (a) VALUES ($row(x))" rollback }" (procedure "__PLTcl_proc_transaction_test4b" line 3) invoked from within "__PLTcl_proc_transaction_test4b" in PL/Tcl function transaction_test4b() 2025-01-05 17:27:09.065 UTC client backend[16127] pg_regress/pltcl_transaction STATEMENT: CALL transaction_test4b(); 2025-01-05 17:27:09.070 UTC client backend[16127] pg_regress/pltcl_transaction ERROR: insert or update on table "testfk" violates foreign key constraint "testfk_f1_fkey" 2025-01-05 17:27:09.070 UTC client backend[16127] pg_regress/pltcl_transaction CONTEXT: while executing "commit" (procedure "__PLTcl_proc_transaction_testfk" line 5) invoked from within "__PLTcl_proc_transaction_testfk" in PL/Tcl function transaction_testfk() 2025-01-05 17:27:09.070 UTC client backend[16127] pg_regress/pltcl_transaction STATEMENT: CALL transaction_testfk(); 2025-01-05 17:27:09.078 UTC postmaster[16085] LOG: received fast shutdown request 2025-01-05 17:27:09.078 UTC postmaster[16085] LOG: aborting any active transactions TRAP: failed Assert("(remainMask.mask | targetMask.mask) == BTYPE_MASK_ALL.mask"), File: "../src/backend/postmaster/postmaster.c", Line: 2896, PID: 16085 0xaa8ed2 at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres 0x8a3087 at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres 0x8a1589 at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres 0x8a0964 at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres