2024-11-17 21:33:59.269 UTC postmaster[35244] LOG: starting PostgreSQL 18devel on x86_64-linux, compiled by gcc-12.2.0, 64-bit 2024-11-17 21:33:59.269 UTC postmaster[35244] LOG: listening on Unix socket "/tmp/pg_regress-gp3qxL/.s.PGSQL.40003" 2024-11-17 21:33:59.272 UTC startup[35249] LOG: database system was shut down at 2024-11-17 21:32:34 UTC 2024-11-17 21:33:59.275 UTC postmaster[35244] LOG: database system is ready to accept connections 2024-11-17 21:33:59.467 UTC client backend[35267] pg_regress/pltcl_queries ERROR: value for domain d_comp1 violates check constraint "d_comp1_check" 2024-11-17 21:33:59.467 UTC client backend[35267] pg_regress/pltcl_queries STATEMENT: select tcl_cdomain_arg(row('tkey', -1, 'ref2')); 2024-11-17 21:33:59.468 UTC client backend[35267] pg_regress/pltcl_queries ERROR: invalid command name "returm" 2024-11-17 21:33:59.468 UTC client backend[35267] 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() 2024-11-17 21:33:59.468 UTC client backend[35267] pg_regress/pltcl_queries STATEMENT: select tcl_error(); 2024-11-17 21:33:59.468 UTC client backend[35267] pg_regress/pltcl_queries ERROR: column name/value list must have even number of elements 2024-11-17 21:33:59.468 UTC client backend[35267] pg_regress/pltcl_queries STATEMENT: select bad_record(); 2024-11-17 21:33:59.468 UTC client backend[35267] pg_regress/pltcl_queries ERROR: column name/value list contains nonexistent column name "cow" 2024-11-17 21:33:59.468 UTC client backend[35267] pg_regress/pltcl_queries STATEMENT: select bad_field(); 2024-11-17 21:33:59.470 UTC client backend[35267] pg_regress/pltcl_queries ERROR: return_next cannot be used in non-set-returning functions 2024-11-17 21:33:59.470 UTC client backend[35267] 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() 2024-11-17 21:33:59.470 UTC client backend[35267] pg_regress/pltcl_queries STATEMENT: select non_srf(); 2024-11-17 21:33:59.470 UTC client backend[35267] pg_regress/pltcl_queries ERROR: column name/value list must have even number of elements 2024-11-17 21:33:59.470 UTC client backend[35267] 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() 2024-11-17 21:33:59.470 UTC client backend[35267] pg_regress/pltcl_queries STATEMENT: select bad_record_srf(); 2024-11-17 21:33:59.471 UTC client backend[35267] pg_regress/pltcl_queries ERROR: column name/value list contains nonexistent column name "cow" 2024-11-17 21:33:59.471 UTC client backend[35267] 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() 2024-11-17 21:33:59.471 UTC client backend[35267] pg_regress/pltcl_queries STATEMENT: select bad_field_srf(); 2024-11-17 21:33:59.472 UTC client backend[35267] pg_regress/pltcl_queries ERROR: value for domain d_comp1 violates check constraint "d_comp1_check" 2024-11-17 21:33:59.472 UTC client backend[35267] pg_regress/pltcl_queries STATEMENT: select * from tcl_dcomposite_result(-1); 2024-11-17 21:33:59.472 UTC client backend[35267] pg_regress/pltcl_queries ERROR: function returning record called in context that cannot accept type record 2024-11-17 21:33:59.472 UTC client backend[35267] pg_regress/pltcl_queries STATEMENT: select tcl_record_result(42); 2024-11-17 21:33:59.472 UTC client backend[35267] pg_regress/pltcl_queries ERROR: a column definition list is required for functions returning "record" at character 15 2024-11-17 21:33:59.472 UTC client backend[35267] pg_regress/pltcl_queries STATEMENT: select * from tcl_record_result(42); 2024-11-17 21:33:59.473 UTC client backend[35267] pg_regress/pltcl_queries ERROR: column name/value list contains nonexistent column name "q3" 2024-11-17 21:33:59.473 UTC client backend[35267] pg_regress/pltcl_queries STATEMENT: select * from tcl_record_result(42) as (q1 text, q2 int, q4 int); 2024-11-17 21:33:59.473 UTC client backend[35267] pg_regress/pltcl_queries ERROR: wrong # args: should be "quote string" 2024-11-17 21:33:59.473 UTC client backend[35267] 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) 2024-11-17 21:33:59.473 UTC client backend[35267] pg_regress/pltcl_queries STATEMENT: select tcl_eval('quote foo bar'); 2024-11-17 21:33:59.474 UTC client backend[35267] pg_regress/pltcl_queries ERROR: wrong # args: should be "argisnull argno" 2024-11-17 21:33:59.474 UTC client backend[35267] 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) 2024-11-17 21:33:59.474 UTC client backend[35267] pg_regress/pltcl_queries STATEMENT: select tcl_eval('argisnull'); 2024-11-17 21:33:59.474 UTC client backend[35267] pg_regress/pltcl_queries ERROR: argno out of range 2024-11-17 21:33:59.474 UTC client backend[35267] 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) 2024-11-17 21:33:59.474 UTC client backend[35267] pg_regress/pltcl_queries STATEMENT: select tcl_eval('argisnull 14'); 2024-11-17 21:33:59.474 UTC client backend[35267] pg_regress/pltcl_queries ERROR: expected integer but got "abc" 2024-11-17 21:33:59.474 UTC client backend[35267] 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) 2024-11-17 21:33:59.474 UTC client backend[35267] pg_regress/pltcl_queries STATEMENT: select tcl_eval('argisnull abc'); 2024-11-17 21:33:59.474 UTC client backend[35267] pg_regress/pltcl_queries ERROR: wrong # args: should be "return_null " 2024-11-17 21:33:59.474 UTC client backend[35267] 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) 2024-11-17 21:33:59.474 UTC client backend[35267] pg_regress/pltcl_queries STATEMENT: select tcl_eval('return_null 14'); 2024-11-17 21:33:59.474 UTC client backend[35267] pg_regress/pltcl_queries ERROR: wrong # args: should be "spi_exec ?-count n? ?-array name? query ?loop body?" 2024-11-17 21:33:59.474 UTC client backend[35267] 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) 2024-11-17 21:33:59.474 UTC client backend[35267] pg_regress/pltcl_queries STATEMENT: select tcl_eval('spi_exec'); 2024-11-17 21:33:59.474 UTC client backend[35267] pg_regress/pltcl_queries ERROR: missing argument to -count or -array 2024-11-17 21:33:59.474 UTC client backend[35267] 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) 2024-11-17 21:33:59.474 UTC client backend[35267] pg_regress/pltcl_queries STATEMENT: select tcl_eval('spi_exec -count'); 2024-11-17 21:33:59.474 UTC client backend[35267] pg_regress/pltcl_queries ERROR: missing argument to -count or -array 2024-11-17 21:33:59.474 UTC client backend[35267] 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) 2024-11-17 21:33:59.474 UTC client backend[35267] pg_regress/pltcl_queries STATEMENT: select tcl_eval('spi_exec -array'); 2024-11-17 21:33:59.474 UTC client backend[35267] pg_regress/pltcl_queries ERROR: expected integer but got "abc" 2024-11-17 21:33:59.474 UTC client backend[35267] 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) 2024-11-17 21:33:59.474 UTC client backend[35267] pg_regress/pltcl_queries STATEMENT: select tcl_eval('spi_exec -count abc'); 2024-11-17 21:33:59.475 UTC client backend[35267] pg_regress/pltcl_queries ERROR: wrong # args: should be "query ?loop body?" 2024-11-17 21:33:59.475 UTC client backend[35267] 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) 2024-11-17 21:33:59.475 UTC client backend[35267] pg_regress/pltcl_queries STATEMENT: select tcl_eval('spi_exec query loop body toomuch'); 2024-11-17 21:33:59.475 UTC client backend[35267] pg_regress/pltcl_queries ERROR: pltcl: SPI_execute failed: SPI_ERROR_TRANSACTION 2024-11-17 21:33:59.475 UTC client backend[35267] 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) 2024-11-17 21:33:59.475 UTC client backend[35267] pg_regress/pltcl_queries STATEMENT: select tcl_eval('spi_exec "begin; rollback;"'); 2024-11-17 21:33:59.475 UTC client backend[35267] pg_regress/pltcl_queries ERROR: missing argument to -count or -array 2024-11-17 21:33:59.475 UTC client backend[35267] 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) 2024-11-17 21:33:59.475 UTC client backend[35267] pg_regress/pltcl_queries STATEMENT: select tcl_eval('spi_execp'); 2024-11-17 21:33:59.475 UTC client backend[35267] pg_regress/pltcl_queries ERROR: missing argument to -array, -count or -nulls 2024-11-17 21:33:59.475 UTC client backend[35267] 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) 2024-11-17 21:33:59.475 UTC client backend[35267] pg_regress/pltcl_queries STATEMENT: select tcl_eval('spi_execp -count'); 2024-11-17 21:33:59.475 UTC client backend[35267] pg_regress/pltcl_queries ERROR: missing argument to -array, -count or -nulls 2024-11-17 21:33:59.475 UTC client backend[35267] 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) 2024-11-17 21:33:59.475 UTC client backend[35267] pg_regress/pltcl_queries STATEMENT: select tcl_eval('spi_execp -array'); 2024-11-17 21:33:59.475 UTC client backend[35267] pg_regress/pltcl_queries ERROR: expected integer but got "abc" 2024-11-17 21:33:59.475 UTC client backend[35267] 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) 2024-11-17 21:33:59.475 UTC client backend[35267] pg_regress/pltcl_queries STATEMENT: select tcl_eval('spi_execp -count abc'); 2024-11-17 21:33:59.475 UTC client backend[35267] pg_regress/pltcl_queries ERROR: missing argument to -array, -count or -nulls 2024-11-17 21:33:59.475 UTC client backend[35267] 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) 2024-11-17 21:33:59.475 UTC client backend[35267] pg_regress/pltcl_queries STATEMENT: select tcl_eval('spi_execp -nulls'); 2024-11-17 21:33:59.475 UTC client backend[35267] pg_regress/pltcl_queries ERROR: invalid queryid '' 2024-11-17 21:33:59.475 UTC client backend[35267] 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) 2024-11-17 21:33:59.475 UTC client backend[35267] pg_regress/pltcl_queries STATEMENT: select tcl_eval('spi_execp ""'); 2024-11-17 21:33:59.475 UTC client backend[35267] pg_regress/pltcl_queries ERROR: wrong # args: should be "spi_prepare query argtypes" 2024-11-17 21:33:59.475 UTC client backend[35267] 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) 2024-11-17 21:33:59.475 UTC client backend[35267] pg_regress/pltcl_queries STATEMENT: select tcl_eval('spi_prepare'); 2024-11-17 21:33:59.476 UTC client backend[35267] pg_regress/pltcl_queries ERROR: type "b" does not exist 2024-11-17 21:33:59.476 UTC client backend[35267] 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) 2024-11-17 21:33:59.476 UTC client backend[35267] pg_regress/pltcl_queries STATEMENT: select tcl_eval('spi_prepare a b'); 2024-11-17 21:33:59.476 UTC client backend[35267] pg_regress/pltcl_queries ERROR: unmatched open brace in list 2024-11-17 21:33:59.476 UTC client backend[35267] 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) 2024-11-17 21:33:59.476 UTC client backend[35267] pg_regress/pltcl_queries STATEMENT: select tcl_eval('spi_prepare a "b {"'); 2024-11-17 21:33:59.477 UTC client backend[35267] pg_regress/pltcl_queries ERROR: wrong # args: should be "elog level msg" 2024-11-17 21:33:59.477 UTC client backend[35267] 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) 2024-11-17 21:33:59.477 UTC client backend[35267] pg_regress/pltcl_queries STATEMENT: select tcl_eval('elog'); 2024-11-17 21:33:59.477 UTC client backend[35267] pg_regress/pltcl_queries ERROR: bad priority "foo": must be DEBUG, LOG, INFO, NOTICE, WARNING, ERROR, or FATAL 2024-11-17 21:33:59.477 UTC client backend[35267] 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) 2024-11-17 21:33:59.477 UTC client backend[35267] pg_regress/pltcl_queries STATEMENT: select tcl_eval('elog foo bar'); 2024-11-17 21:33:59.477 UTC client backend[35267] pg_regress/pltcl_queries ERROR: forced error 2024-11-17 21:33:59.477 UTC client backend[35267] 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) 2024-11-17 21:33:59.477 UTC client backend[35267] pg_regress/pltcl_queries STATEMENT: select tcl_eval('error "forced error"'); 2024-11-17 21:33:59.478 UTC client backend[35267] pg_regress/pltcl_queries ERROR: error message 2024-11-17 21:33:59.478 UTC client backend[35267] 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) 2024-11-17 21:33:59.478 UTC client backend[35267] pg_regress/pltcl_queries STATEMENT: select tcl_spi_exec(true, 'error'); 2024-11-17 21:33:59.479 UTC client backend[35267] pg_regress/pltcl_queries ERROR: error message 2024-11-17 21:33:59.479 UTC client backend[35267] 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) 2024-11-17 21:33:59.479 UTC client backend[35267] pg_regress/pltcl_queries STATEMENT: select tcl_spi_exec(false, 'error'); 2024-11-17 21:33:59.621 UTC client backend[35273] pg_regress/pltcl_trigger ERROR: duplicate key '1', 'KEY1-3' for T_pkey2 2024-11-17 21:33:59.621 UTC client backend[35273] 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() 2024-11-17 21:33:59.621 UTC client backend[35273] pg_regress/pltcl_trigger STATEMENT: insert into T_pkey2 values (1, 'KEY1-3', 'should fail'); 2024-11-17 21:33:59.625 UTC client backend[35273] pg_regress/pltcl_trigger ERROR: key for t_dta1 not in t_pkey1 2024-11-17 21:33:59.625 UTC client backend[35273] 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() 2024-11-17 21:33:59.625 UTC client backend[35273] pg_regress/pltcl_trigger STATEMENT: insert into T_dta1 values ('trec 4', 1, 'key1-4'); 2024-11-17 21:33:59.627 UTC client backend[35273] pg_regress/pltcl_trigger ERROR: key for t_dta2 not in t_pkey2 2024-11-17 21:33:59.627 UTC client backend[35273] 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() 2024-11-17 21:33:59.627 UTC client backend[35273] pg_regress/pltcl_trigger STATEMENT: insert into T_dta2 values ('trec 4', 1, 'KEY1-4'); 2024-11-17 21:33:59.628 UTC client backend[35273] pg_regress/pltcl_trigger ERROR: key '1', 'key1-1 ' referenced by T_dta1 2024-11-17 21:33:59.628 UTC client backend[35273] 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() 2024-11-17 21:33:59.628 UTC client backend[35273] pg_regress/pltcl_trigger STATEMENT: update T_pkey1 set key2 = 'key1-9' where key1 = 1 and key2 = 'key1-1'; 2024-11-17 21:33:59.628 UTC client backend[35273] pg_regress/pltcl_trigger ERROR: key '1', 'key1-2 ' referenced by T_dta1 2024-11-17 21:33:59.628 UTC client backend[35273] 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() 2024-11-17 21:33:59.628 UTC client backend[35273] pg_regress/pltcl_trigger STATEMENT: delete from T_pkey1 where key1 = 1 and key2 = 'key1-2'; 2024-11-17 21:33:59.640 UTC client backend[35273] pg_regress/pltcl_trigger ERROR: argisnull cannot be used in triggers 2024-11-17 21:33:59.640 UTC client backend[35273] 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() 2024-11-17 21:33:59.640 UTC client backend[35273] pg_regress/pltcl_trigger STATEMENT: insert into trigger_test(test_argisnull) values(true); 2024-11-17 21:33:59.640 UTC client backend[35273] pg_regress/pltcl_trigger ERROR: return_null cannot be used in triggers 2024-11-17 21:33:59.640 UTC client backend[35273] 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() 2024-11-17 21:33:59.640 UTC client backend[35273] pg_regress/pltcl_trigger STATEMENT: insert into trigger_test(test_return_null) values(true); 2024-11-17 21:33:59.645 UTC client backend[35273] pg_regress/pltcl_trigger ERROR: cannot set generated column "j" 2024-11-17 21:33:59.645 UTC client backend[35273] pg_regress/pltcl_trigger STATEMENT: INSERT INTO trigger_test_generated (i) VALUES (1); 2024-11-17 21:33:59.668 UTC client backend[35279] pg_regress/pltcl_call ERROR: could not parse function return value: list element in braces followed by ")" instead of space 2024-11-17 21:33:59.668 UTC client backend[35279] pg_regress/pltcl_call STATEMENT: CALL test_proc10('abc'); 2024-11-17 21:33:59.687 UTC client backend[35283] pg_regress/pltcl_start_proc ERROR: function no_such_function() does not exist 2024-11-17 21:33:59.687 UTC client backend[35283] pg_regress/pltcl_start_proc CONTEXT: processing pltcl.start_proc parameter 2024-11-17 21:33:59.687 UTC client backend[35283] pg_regress/pltcl_start_proc STATEMENT: select tcl_int4add(1, 2); 2024-11-17 21:33:59.687 UTC client backend[35283] pg_regress/pltcl_start_proc ERROR: function no_such_function() does not exist 2024-11-17 21:33:59.687 UTC client backend[35283] pg_regress/pltcl_start_proc CONTEXT: processing pltcl.start_proc parameter 2024-11-17 21:33:59.687 UTC client backend[35283] pg_regress/pltcl_start_proc STATEMENT: select tcl_int4add(1, 2); 2024-11-17 21:33:59.689 UTC client backend[35283] pg_regress/pltcl_start_proc ERROR: function "public.tcl_initialize" must not be SECURITY DEFINER 2024-11-17 21:33:59.689 UTC client backend[35283] pg_regress/pltcl_start_proc CONTEXT: processing pltcl.start_proc parameter 2024-11-17 21:33:59.689 UTC client backend[35283] pg_regress/pltcl_start_proc STATEMENT: select tcl_int4add(1, 2); 2024-11-17 21:33:59.760 UTC client backend[35297] pg_regress/pltcl_transaction ERROR: invalid transaction termination 2024-11-17 21:33:59.760 UTC client backend[35297] 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() 2024-11-17 21:33:59.760 UTC client backend[35297] pg_regress/pltcl_transaction STATEMENT: SELECT transaction_test2(); 2024-11-17 21:33:59.760 UTC client backend[35297] pg_regress/pltcl_transaction ERROR: invalid transaction termination 2024-11-17 21:33:59.760 UTC client backend[35297] 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() 2024-11-17 21:33:59.760 UTC client backend[35297] pg_regress/pltcl_transaction STATEMENT: SELECT transaction_test3(); 2024-11-17 21:33:59.763 UTC client backend[35297] pg_regress/pltcl_transaction ERROR: cannot commit while a subtransaction is active 2024-11-17 21:33:59.763 UTC client backend[35297] 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() 2024-11-17 21:33:59.763 UTC client backend[35297] pg_regress/pltcl_transaction STATEMENT: CALL transaction_test4a(); 2024-11-17 21:33:59.765 UTC client backend[35297] pg_regress/pltcl_transaction ERROR: cannot roll back while a subtransaction is active 2024-11-17 21:33:59.765 UTC client backend[35297] 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() 2024-11-17 21:33:59.765 UTC client backend[35297] pg_regress/pltcl_transaction STATEMENT: CALL transaction_test4b(); 2024-11-17 21:33:59.768 UTC client backend[35297] pg_regress/pltcl_transaction ERROR: insert or update on table "testfk" violates foreign key constraint "testfk_f1_fkey" 2024-11-17 21:33:59.768 UTC client backend[35297] 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() 2024-11-17 21:33:59.768 UTC client backend[35297] pg_regress/pltcl_transaction STATEMENT: CALL transaction_testfk(); 2024-11-17 21:33:59.776 UTC postmaster[35244] LOG: received fast shutdown request 2024-11-17 21:33:59.776 UTC postmaster[35244] LOG: aborting any active transactions TRAP: failed Assert("(remainMask.mask | targetMask.mask) == BTYPE_MASK_ALL.mask"), File: "../src/backend/postmaster/postmaster.c", Line: 2887, PID: 35244 postgres(ExceptionalCondition+0x56)[0x55d07ca5f13d] postgres(+0xeb1cd8)[0x55d07c67bcd8] postgres(+0xeb222e)[0x55d07c67c22e] postgres(+0xeb30f0)[0x55d07c67d0f0] postgres(PostmasterMain+0x13f2)[0x55d07c67eb5f] postgres(main+0x2c1)[0x55d07c4b6b85] /lib/x86_64-linux-gnu/libc.so.6(+0x2724a)[0x7f82b8c4624a] /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0x85)[0x7f82b8c46305] postgres(_start+0x21)[0x55d07c066151]