2024-12-27 05:16:41.602 UTC postmaster[34097] LOG: starting PostgreSQL 18devel on x86_64-linux, compiled by gcc-12.2.0, 64-bit 2024-12-27 05:16:41.602 UTC postmaster[34097] LOG: listening on Unix socket "/tmp/pg_regress-UKkjUk/.s.PGSQL.40001" 2024-12-27 05:16:41.609 UTC client backend[34102] [unknown] FATAL: the database system is starting up 2024-12-27 05:16:41.611 UTC startup[34101] LOG: database system was shut down at 2024-12-27 05:15:34 UTC 2024-12-27 05:16:41.614 UTC postmaster[34097] LOG: database system is ready to accept connections 2024-12-27 05:16:41.803 UTC client backend[34114] pg_regress/plperl_setup ERROR: permission denied to create extension "plperl" 2024-12-27 05:16:41.803 UTC client backend[34114] pg_regress/plperl_setup HINT: Must have CREATE privilege on current database to create this extension. 2024-12-27 05:16:41.803 UTC client backend[34114] pg_regress/plperl_setup STATEMENT: CREATE EXTENSION plperl; 2024-12-27 05:16:41.803 UTC client backend[34114] pg_regress/plperl_setup ERROR: permission denied to create extension "plperlu" 2024-12-27 05:16:41.803 UTC client backend[34114] pg_regress/plperl_setup HINT: Must be superuser to create this extension. 2024-12-27 05:16:41.803 UTC client backend[34114] pg_regress/plperl_setup STATEMENT: CREATE EXTENSION plperlu; 2024-12-27 05:16:41.843 UTC client backend[34114] pg_regress/plperl_setup ERROR: permission denied to create extension "plperlu" 2024-12-27 05:16:41.843 UTC client backend[34114] pg_regress/plperl_setup HINT: Must be superuser to create this extension. 2024-12-27 05:16:41.843 UTC client backend[34114] pg_regress/plperl_setup STATEMENT: CREATE EXTENSION plperlu; 2024-12-27 05:16:41.874 UTC client backend[34116] pg_regress/plperl_setup ERROR: permission denied for language plperl 2024-12-27 05:16:41.874 UTC client backend[34116] pg_regress/plperl_setup STATEMENT: CREATE FUNCTION foo2() returns int language plperl as '2;'; 2024-12-27 05:16:41.892 UTC client backend[34116] pg_regress/plperl_setup ERROR: cannot drop language plperl because extension plperl requires it 2024-12-27 05:16:41.892 UTC client backend[34116] pg_regress/plperl_setup HINT: You can drop extension plperl instead. 2024-12-27 05:16:41.892 UTC client backend[34116] pg_regress/plperl_setup STATEMENT: DROP LANGUAGE plperl CASCADE; 2024-12-27 05:16:41.945 UTC client backend[34128] pg_regress/plperl ERROR: SETOF-composite-returning PL/Perl function must call return_next with reference to hash 2024-12-27 05:16:41.945 UTC client backend[34128] pg_regress/plperl CONTEXT: PL/Perl function "perl_set" 2024-12-27 05:16:41.945 UTC client backend[34128] pg_regress/plperl STATEMENT: SELECT perl_set(); 2024-12-27 05:16:41.945 UTC client backend[34128] pg_regress/plperl ERROR: SETOF-composite-returning PL/Perl function must call return_next with reference to hash 2024-12-27 05:16:41.945 UTC client backend[34128] pg_regress/plperl CONTEXT: PL/Perl function "perl_set" 2024-12-27 05:16:41.945 UTC client backend[34128] pg_regress/plperl STATEMENT: SELECT * FROM perl_set(); 2024-12-27 05:16:41.946 UTC client backend[34128] pg_regress/plperl ERROR: a column definition list is required for functions returning "record" at character 15 2024-12-27 05:16:41.946 UTC client backend[34128] pg_regress/plperl STATEMENT: SELECT * FROM perl_record(); 2024-12-27 05:16:41.947 UTC client backend[34128] pg_regress/plperl ERROR: function returning record called in context that cannot accept type record 2024-12-27 05:16:41.947 UTC client backend[34128] pg_regress/plperl CONTEXT: PL/Perl function "perl_record" 2024-12-27 05:16:41.947 UTC client backend[34128] pg_regress/plperl STATEMENT: SELECT perl_record(); 2024-12-27 05:16:41.947 UTC client backend[34128] pg_regress/plperl ERROR: a column definition list is required for functions returning "record" at character 15 2024-12-27 05:16:41.947 UTC client backend[34128] pg_regress/plperl STATEMENT: SELECT * FROM perl_record(); 2024-12-27 05:16:41.948 UTC client backend[34128] pg_regress/plperl ERROR: a column definition list is required for functions returning "record" at character 15 2024-12-27 05:16:41.948 UTC client backend[34128] pg_regress/plperl STATEMENT: SELECT * FROM perl_record_set(); 2024-12-27 05:16:41.948 UTC client backend[34128] pg_regress/plperl ERROR: function returning record called in context that cannot accept type record 2024-12-27 05:16:41.948 UTC client backend[34128] pg_regress/plperl CONTEXT: PL/Perl function "perl_record_set" 2024-12-27 05:16:41.948 UTC client backend[34128] pg_regress/plperl STATEMENT: SELECT perl_record_set(); 2024-12-27 05:16:41.948 UTC client backend[34128] pg_regress/plperl ERROR: a column definition list is required for functions returning "record" at character 15 2024-12-27 05:16:41.948 UTC client backend[34128] pg_regress/plperl STATEMENT: SELECT * FROM perl_record_set(); 2024-12-27 05:16:41.948 UTC client backend[34128] pg_regress/plperl ERROR: SETOF-composite-returning PL/Perl function must call return_next with reference to hash 2024-12-27 05:16:41.948 UTC client backend[34128] pg_regress/plperl CONTEXT: PL/Perl function "perl_record_set" 2024-12-27 05:16:41.948 UTC client backend[34128] pg_regress/plperl STATEMENT: SELECT * FROM perl_record_set() AS (f1 integer, f2 text, f3 text); 2024-12-27 05:16:41.949 UTC client backend[34128] pg_regress/plperl ERROR: function returning record called in context that cannot accept type record 2024-12-27 05:16:41.949 UTC client backend[34128] pg_regress/plperl CONTEXT: PL/Perl function "perl_record_set" 2024-12-27 05:16:41.949 UTC client backend[34128] pg_regress/plperl STATEMENT: SELECT perl_record_set(); 2024-12-27 05:16:41.949 UTC client backend[34128] pg_regress/plperl ERROR: a column definition list is required for functions returning "record" at character 15 2024-12-27 05:16:41.949 UTC client backend[34128] pg_regress/plperl STATEMENT: SELECT * FROM perl_record_set(); 2024-12-27 05:16:41.952 UTC client backend[34128] pg_regress/plperl ERROR: Perl hash contains nonexistent column "z" 2024-12-27 05:16:41.952 UTC client backend[34128] pg_regress/plperl CONTEXT: PL/Perl function "foo_bad" 2024-12-27 05:16:41.952 UTC client backend[34128] pg_regress/plperl STATEMENT: SELECT * FROM foo_bad(); 2024-12-27 05:16:41.953 UTC client backend[34128] pg_regress/plperl ERROR: malformed record literal: "42" 2024-12-27 05:16:41.953 UTC client backend[34128] pg_regress/plperl DETAIL: Missing left parenthesis. 2024-12-27 05:16:41.953 UTC client backend[34128] pg_regress/plperl CONTEXT: PL/Perl function "foo_bad" 2024-12-27 05:16:41.953 UTC client backend[34128] pg_regress/plperl STATEMENT: SELECT * FROM foo_bad(); 2024-12-27 05:16:41.954 UTC client backend[34128] pg_regress/plperl ERROR: cannot convert Perl array to non-array type footype 2024-12-27 05:16:41.954 UTC client backend[34128] pg_regress/plperl CONTEXT: PL/Perl function "foo_bad" 2024-12-27 05:16:41.954 UTC client backend[34128] pg_regress/plperl STATEMENT: SELECT * FROM foo_bad(); 2024-12-27 05:16:41.954 UTC client backend[34128] pg_regress/plperl ERROR: set-returning PL/Perl function must return reference to array or use return_next 2024-12-27 05:16:41.954 UTC client backend[34128] pg_regress/plperl CONTEXT: PL/Perl function "foo_set_bad" 2024-12-27 05:16:41.954 UTC client backend[34128] pg_regress/plperl STATEMENT: SELECT * FROM foo_set_bad(); 2024-12-27 05:16:41.955 UTC client backend[34128] pg_regress/plperl ERROR: set-returning PL/Perl function must return reference to array or use return_next 2024-12-27 05:16:41.955 UTC client backend[34128] pg_regress/plperl CONTEXT: PL/Perl function "foo_set_bad" 2024-12-27 05:16:41.955 UTC client backend[34128] pg_regress/plperl STATEMENT: SELECT * FROM foo_set_bad(); 2024-12-27 05:16:41.955 UTC client backend[34128] pg_regress/plperl ERROR: SETOF-composite-returning PL/Perl function must call return_next with reference to hash 2024-12-27 05:16:41.955 UTC client backend[34128] pg_regress/plperl CONTEXT: PL/Perl function "foo_set_bad" 2024-12-27 05:16:41.955 UTC client backend[34128] pg_regress/plperl STATEMENT: SELECT * FROM foo_set_bad(); 2024-12-27 05:16:41.956 UTC client backend[34128] pg_regress/plperl ERROR: Perl hash contains nonexistent column "z" 2024-12-27 05:16:41.956 UTC client backend[34128] pg_regress/plperl CONTEXT: PL/Perl function "foo_set_bad" 2024-12-27 05:16:41.956 UTC client backend[34128] pg_regress/plperl STATEMENT: SELECT * FROM foo_set_bad(); 2024-12-27 05:16:41.957 UTC client backend[34128] pg_regress/plperl ERROR: value for domain orderedfootype violates check constraint "orderedfootype_check" 2024-12-27 05:16:41.957 UTC client backend[34128] pg_regress/plperl CONTEXT: PL/Perl function "foo_ordered" 2024-12-27 05:16:41.957 UTC client backend[34128] pg_regress/plperl STATEMENT: SELECT * FROM foo_ordered(); 2024-12-27 05:16:41.958 UTC client backend[34128] pg_regress/plperl ERROR: value for domain orderedfootype violates check constraint "orderedfootype_check" 2024-12-27 05:16:41.958 UTC client backend[34128] pg_regress/plperl CONTEXT: PL/Perl function "foo_ordered_set" 2024-12-27 05:16:41.958 UTC client backend[34128] pg_regress/plperl STATEMENT: SELECT * FROM foo_ordered_set(); 2024-12-27 05:16:41.960 UTC client backend[34128] pg_regress/plperl ERROR: value for domain orderedfootype violates check constraint "orderedfootype_check" 2024-12-27 05:16:41.960 UTC client backend[34128] pg_regress/plperl STATEMENT: SELECT perl_get_cfield((12,11), 'x'); 2024-12-27 05:16:41.961 UTC client backend[34128] pg_regress/plperl ERROR: value for domain orderedfootype violates check constraint "orderedfootype_check" 2024-12-27 05:16:41.961 UTC client backend[34128] pg_regress/plperl STATEMENT: SELECT perl_get_rfield((12,11)::orderedfootype, 'x'); 2024-12-27 05:16:41.967 UTC client backend[34128] pg_regress/plperl ERROR: type "does_not_exist" does not exist at line 2. 2024-12-27 05:16:41.967 UTC client backend[34128] pg_regress/plperl CONTEXT: PL/Perl function "perl_spi_prepared_bad" 2024-12-27 05:16:41.967 UTC client backend[34128] pg_regress/plperl STATEMENT: SELECT perl_spi_prepared_bad(4.35) as "double precision"; 2024-12-27 05:16:41.969 UTC client backend[34128] pg_regress/plperl ERROR: 'system' trapped by operation mask at line 1. 2024-12-27 05:16:41.969 UTC client backend[34128] pg_regress/plperl CONTEXT: PL/Perl anonymous code block 2024-12-27 05:16:41.969 UTC client backend[34128] pg_regress/plperl STATEMENT: DO $$ system("/nonesuch"); $$ LANGUAGE plperl; 2024-12-27 05:16:41.969 UTC client backend[34128] pg_regress/plperl ERROR: 'quoted execution (``, qx)' trapped by operation mask at line 1. 2024-12-27 05:16:41.969 UTC client backend[34128] pg_regress/plperl CONTEXT: PL/Perl anonymous code block 2024-12-27 05:16:41.969 UTC client backend[34128] pg_regress/plperl STATEMENT: DO $$ qx("/nonesuch"); $$ LANGUAGE plperl; 2024-12-27 05:16:41.969 UTC client backend[34128] pg_regress/plperl ERROR: 'open' trapped by operation mask at line 1. 2024-12-27 05:16:41.969 UTC client backend[34128] pg_regress/plperl CONTEXT: PL/Perl anonymous code block 2024-12-27 05:16:41.969 UTC client backend[34128] pg_regress/plperl STATEMENT: DO $$ open my $fh, " qw(void) ; my @y; sort @y; 1; $do$ LANGUAGE plperl; 2024-12-27 05:16:41.971 UTC client backend[34128] pg_regress/plperl ERROR: cannot convert Perl array to non-array type text 2024-12-27 05:16:41.971 UTC client backend[34128] pg_regress/plperl CONTEXT: PL/Perl function "text_arrayref" 2024-12-27 05:16:41.971 UTC client backend[34128] pg_regress/plperl STATEMENT: SELECT text_arrayref(); 2024-12-27 05:16:41.971 UTC client backend[34128] pg_regress/plperl ERROR: cannot convert Perl hash to non-composite type text 2024-12-27 05:16:41.971 UTC client backend[34128] pg_regress/plperl CONTEXT: PL/Perl function "text_hashref" 2024-12-27 05:16:41.971 UTC client backend[34128] pg_regress/plperl STATEMENT: SELECT text_hashref(); 2024-12-27 05:16:41.972 UTC client backend[34128] pg_regress/plperl ERROR: cannot convert Perl hash to non-composite type text 2024-12-27 05:16:41.972 UTC client backend[34128] pg_regress/plperl CONTEXT: PL/Perl function "text_obj" 2024-12-27 05:16:41.972 UTC client backend[34128] pg_regress/plperl STATEMENT: SELECT text_obj(); 2024-12-27 05:16:42.012 UTC client backend[34139] pg_regress/plperl_lc ERROR: invalid byte sequence for encoding "UTF8": 0x00 2024-12-27 05:16:42.012 UTC client backend[34139] pg_regress/plperl_lc CONTEXT: PL/Perl function "perl_zerob" 2024-12-27 05:16:42.012 UTC client backend[34139] pg_regress/plperl_lc STATEMENT: SELECT perl_zerob(); 2024-12-27 05:16:42.069 UTC client backend[34144] pg_regress/plperl_trigger ERROR: trigger functions can only be called as triggers 2024-12-27 05:16:42.069 UTC client backend[34144] pg_regress/plperl_trigger CONTEXT: compilation of PL/Perl function "direct_trigger" 2024-12-27 05:16:42.069 UTC client backend[34144] pg_regress/plperl_trigger STATEMENT: SELECT direct_trigger(); 2024-12-27 05:16:42.077 UTC client backend[34144] pg_regress/plperl_trigger ERROR: cannot set generated column "j" 2024-12-27 05:16:42.077 UTC client backend[34144] pg_regress/plperl_trigger CONTEXT: PL/Perl function "generated_test_func1" 2024-12-27 05:16:42.077 UTC client backend[34144] pg_regress/plperl_trigger STATEMENT: INSERT INTO trigger_test_generated (i) VALUES (1); 2024-12-27 05:16:42.140 UTC client backend[34154] pg_regress/plperl_elog WARNING: implicit elog via warn at line 4. 2024-12-27 05:16:42.140 UTC client backend[34154] pg_regress/plperl_elog CONTEXT: PL/Perl function "perl_warn" 2024-12-27 05:16:42.140 UTC client backend[34154] pg_regress/plperl_elog ERROR: Global symbol "$global" requires explicit package name (did you forget to declare "my $global"?) at line 3. Global symbol "$other_global" requires explicit package name (did you forget to declare "my $other_global"?) at line 4. 2024-12-27 05:16:42.140 UTC client backend[34154] pg_regress/plperl_elog CONTEXT: compilation of PL/Perl function "uses_global" 2024-12-27 05:16:42.140 UTC client backend[34154] pg_regress/plperl_elog STATEMENT: create or replace function uses_global() returns text language plperl as $$ $global = 1; $other_global = 2; return 'uses_global worked'; $$; 2024-12-27 05:16:42.140 UTC client backend[34154] pg_regress/plperl_elog ERROR: function uses_global() does not exist at character 8 2024-12-27 05:16:42.140 UTC client backend[34154] pg_regress/plperl_elog HINT: No function matches the given name and argument types. You might need to add explicit type casts. 2024-12-27 05:16:42.140 UTC client backend[34154] pg_regress/plperl_elog STATEMENT: select uses_global(); 2024-12-27 05:16:42.142 UTC client backend[34154] pg_regress/plperl_elog ERROR: just die at line 2. 2024-12-27 05:16:42.142 UTC client backend[34154] pg_regress/plperl_elog CONTEXT: PL/Perl function "just_die" 2024-12-27 05:16:42.142 UTC client backend[34154] pg_regress/plperl_elog STATEMENT: select just_die(); 2024-12-27 05:16:42.144 UTC client backend[34154] pg_regress/plperl_elog ERROR: this message contains a no-break space at line 2. 2024-12-27 05:16:42.144 UTC client backend[34154] pg_regress/plperl_elog CONTEXT: PL/Perl function "error_with_nbsp" 2024-12-27 05:16:42.144 UTC client backend[34154] pg_regress/plperl_elog STATEMENT: select error_with_nbsp(); 2024-12-27 05:16:42.181 UTC client backend[34164] pg_regress/plperl_util ERROR: value for domain perl_foo_pos violates check constraint "perl_foo_pos_check" 2024-12-27 05:16:42.181 UTC client backend[34164] pg_regress/plperl_util CONTEXT: PL/Perl function "perl_encode_typed_literal" 2024-12-27 05:16:42.181 UTC client backend[34164] pg_regress/plperl_util STATEMENT: select perl_encode_typed_literal(); 2024-12-27 05:16:42.212 UTC client backend[34168] pg_regress/plperl_init ERROR: 'system' trapped by operation mask at line 1. 2024-12-27 05:16:42.212 UTC client backend[34168] pg_regress/plperl_init CONTEXT: while executing plperl.on_plperl_init PL/Perl anonymous code block 2024-12-27 05:16:42.212 UTC client backend[34168] pg_regress/plperl_init STATEMENT: DO $$ warn 42 $$ language plperl; 2024-12-27 05:16:42.228 UTC client backend[34170] pg_regress/plperl_init WARNING: permission denied to set parameter "plperl.on_plperl_init" 2024-12-27 05:16:42.239 UTC client backend[34170] pg_regress/plperl_init WARNING: 42 at line 1. 2024-12-27 05:16:42.239 UTC client backend[34170] pg_regress/plperl_init CONTEXT: PL/Perl anonymous code block 2024-12-27 05:16:42.239 UTC client backend[34170] pg_regress/plperl_init ERROR: permission denied to set parameter "plperl.on_plperl_init" 2024-12-27 05:16:42.239 UTC client backend[34170] pg_regress/plperl_init STATEMENT: SET SESSION plperl.on_plperl_init = 'test'; 2024-12-27 05:16:42.264 UTC client backend[34175] pg_regress/plperlu WARNING: 42 at line 1. 2024-12-27 05:16:42.264 UTC client backend[34175] pg_regress/plperlu CONTEXT: PL/Perl anonymous code block 2024-12-27 05:16:42.295 UTC client backend[34179] pg_regress/plperl_array ERROR: number of array dimensions exceeds the maximum allowed (6) at character 25 2024-12-27 05:16:42.295 UTC client backend[34179] pg_regress/plperl_array STATEMENT: select plperl_sum_array('{{{{{{{1,2},{3,4}},{{5,6},{7,8}}},{{{9,10},{11,12}}, {{13,14},{15,16}}}}, {{{{17,18},{19,20}},{{21,22},{23,24}}},{{{25,26},{27,28}},{{29,30},{31,32}}}}}, {{{{{1,2},{3,4}},{{5,6},{7,8}}},{{{9,10},{11,12}},{{13,14},{15,16}}}}, {{{{17,18},{19,20}},{{21,22},{23,24}}},{{{25,26},{27,28}},{{29,30},{31,32}}}}}}, {{{{{{1,2},{3,4}},{{5,6},{7,8}}},{{{9,10},{11,12}},{{13,14},{15,16}}}}, {{{{17,18},{19,20}},{{21,22},{23,24}}},{{{25,26},{27,28}},{{29,30},{31,32}}}}}, {{{{{1,2},{3,4}},{{5,6},{7,8}}},{{{9,10},{11,12}},{{13,14},{15,16}}}}, {{{{17,18},{19,20}},{{21,22},{23,24}}},{{{25,26},{27,28}},{{29,30},{31,32}}}}}}}' ); 2024-12-27 05:16:42.295 UTC client backend[34179] pg_regress/plperl_array ERROR: malformed array literal: "{{{1,2,3}, {4,5,6,7}}, {{7,8,9}, {10, 11, 12}}}" at character 25 2024-12-27 05:16:42.295 UTC client backend[34179] pg_regress/plperl_array DETAIL: Multidimensional arrays must have sub-arrays with matching dimensions. 2024-12-27 05:16:42.295 UTC client backend[34179] pg_regress/plperl_array STATEMENT: select plperl_sum_array('{{{1,2,3}, {4,5,6,7}}, {{7,8,9}, {10, 11, 12}}}'); 2024-12-27 05:16:42.303 UTC client backend[34179] pg_regress/plperl_array ERROR: multidimensional arrays must have array expressions with matching dimensions 2024-12-27 05:16:42.303 UTC client backend[34179] pg_regress/plperl_array CONTEXT: PL/Perl function "plperl_md_array_out" 2024-12-27 05:16:42.303 UTC client backend[34179] pg_regress/plperl_array STATEMENT: select plperl_md_array_out(); 2024-12-27 05:16:42.303 UTC client backend[34179] pg_regress/plperl_array ERROR: multidimensional arrays must have array expressions with matching dimensions 2024-12-27 05:16:42.303 UTC client backend[34179] pg_regress/plperl_array CONTEXT: PL/Perl function "plperl_md_array_out" 2024-12-27 05:16:42.303 UTC client backend[34179] pg_regress/plperl_array STATEMENT: select plperl_md_array_out(); 2024-12-27 05:16:42.304 UTC client backend[34179] pg_regress/plperl_array ERROR: multidimensional arrays must have array expressions with matching dimensions 2024-12-27 05:16:42.304 UTC client backend[34179] pg_regress/plperl_array CONTEXT: PL/Perl function "plperl_md_array_out" 2024-12-27 05:16:42.304 UTC client backend[34179] pg_regress/plperl_array STATEMENT: select plperl_md_array_out(); 2024-12-27 05:16:42.304 UTC client backend[34179] pg_regress/plperl_array ERROR: multidimensional arrays must have array expressions with matching dimensions 2024-12-27 05:16:42.304 UTC client backend[34179] pg_regress/plperl_array CONTEXT: PL/Perl function "plperl_md_array_out" 2024-12-27 05:16:42.304 UTC client backend[34179] pg_regress/plperl_array STATEMENT: select plperl_md_array_out(); 2024-12-27 05:16:42.402 UTC client backend[34189] pg_regress/plperl_transaction ERROR: invalid transaction termination at line 5. 2024-12-27 05:16:42.402 UTC client backend[34189] pg_regress/plperl_transaction CONTEXT: PL/Perl function "transaction_test2" 2024-12-27 05:16:42.402 UTC client backend[34189] pg_regress/plperl_transaction STATEMENT: SELECT transaction_test2(); 2024-12-27 05:16:42.403 UTC client backend[34189] pg_regress/plperl_transaction ERROR: invalid transaction termination at line 5. at line 2. 2024-12-27 05:16:42.403 UTC client backend[34189] pg_regress/plperl_transaction CONTEXT: PL/Perl function "transaction_test3" 2024-12-27 05:16:42.403 UTC client backend[34189] pg_regress/plperl_transaction STATEMENT: SELECT transaction_test3(); 2024-12-27 05:16:42.404 UTC client backend[34189] pg_regress/plperl_transaction ERROR: invalid transaction termination at line 1. at line 2. 2024-12-27 05:16:42.404 UTC client backend[34189] pg_regress/plperl_transaction CONTEXT: PL/Perl function "transaction_test4" 2024-12-27 05:16:42.404 UTC client backend[34189] pg_regress/plperl_transaction STATEMENT: SELECT transaction_test4(); 2024-12-27 05:16:42.409 UTC client backend[34189] pg_regress/plperl_transaction ERROR: division by zero at line 5. 2024-12-27 05:16:42.409 UTC client backend[34189] pg_regress/plperl_transaction CONTEXT: PL/Perl anonymous code block 2024-12-27 05:16:42.409 UTC client backend[34189] pg_regress/plperl_transaction STATEMENT: DO LANGUAGE plperl $$ my $sth = spi_query("SELECT * FROM test2 ORDER BY x"); my $row; while (defined($row = spi_fetchrow($sth))) { spi_exec_query("INSERT INTO test1 (a) VALUES (12/(" . $row->{x} . "-2))"); spi_commit(); } $$; 2024-12-27 05:16:42.417 UTC client backend[34189] pg_regress/plperl_transaction ERROR: insert or update on table "testfk" violates foreign key constraint "testfk_f1_fkey" at line 4. 2024-12-27 05:16:42.417 UTC client backend[34189] pg_regress/plperl_transaction CONTEXT: PL/Perl anonymous code block 2024-12-27 05:16:42.417 UTC client backend[34189] pg_regress/plperl_transaction STATEMENT: DO LANGUAGE plperl $$ # this insert will fail during commit: spi_exec_query("INSERT INTO testfk VALUES (0)"); spi_commit(); elog(WARNING, 'should not get here'); $$; 2024-12-27 05:16:42.465 UTC client backend[34194] pg_regress/plperl_env WARNING: attempted alteration of $ENV{TEST_PLPERL_ENV_FOO} at line 12. 2024-12-27 05:16:42.465 UTC client backend[34194] pg_regress/plperl_env CONTEXT: PL/Perl anonymous code block 2024-12-27 05:16:42.485 UTC postmaster[34097] LOG: received fast shutdown request 2024-12-27 05:16:42.485 UTC postmaster[34097] 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: 34097 postgres(ExceptionalCondition+0x56)[0x558ffbc678b5] postgres(+0xeced62)[0x558ffb87dd62] postgres(+0xecf2b8)[0x558ffb87e2b8] postgres(+0xed017a)[0x558ffb87f17a] postgres(PostmasterMain+0x13f0)[0x558ffb880bd9] postgres(main+0x28d)[0x558ffb6b5061] /lib/x86_64-linux-gnu/libc.so.6(+0x2724a)[0x7f853c64624a] /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0x85)[0x7f853c646305] postgres(_start+0x21)[0x558ffb260141]