2024-11-21 04:50:00.072 UTC postmaster[15545] LOG:  starting PostgreSQL 18devel on x86_64-freebsd, compiled by clang-17.0.6, 64-bit
2024-11-21 04:50:00.072 UTC postmaster[15545] LOG:  listening on Unix socket "/tmp/pg_regress-5L5Dfn/.s.PGSQL.40001"
2024-11-21 04:50:00.076 UTC startup[15549] LOG:  database system was shut down at 2024-11-21 04:50:00 UTC
2024-11-21 04:50:00.077 UTC postmaster[15545] LOG:  database system is ready to accept connections
2024-11-21 04:50:00.155 UTC client backend[15563] pg_regress/plperl_setup ERROR:  permission denied to create extension "plperl"
2024-11-21 04:50:00.155 UTC client backend[15563] pg_regress/plperl_setup HINT:  Must have CREATE privilege on current database to create this extension.
2024-11-21 04:50:00.155 UTC client backend[15563] pg_regress/plperl_setup STATEMENT:  CREATE EXTENSION plperl;
2024-11-21 04:50:00.156 UTC client backend[15563] pg_regress/plperl_setup ERROR:  permission denied to create extension "plperlu"
2024-11-21 04:50:00.156 UTC client backend[15563] pg_regress/plperl_setup HINT:  Must be superuser to create this extension.
2024-11-21 04:50:00.156 UTC client backend[15563] pg_regress/plperl_setup STATEMENT:  CREATE EXTENSION plperlu;
2024-11-21 04:50:00.185 UTC client backend[15563] pg_regress/plperl_setup ERROR:  permission denied to create extension "plperlu"
2024-11-21 04:50:00.185 UTC client backend[15563] pg_regress/plperl_setup HINT:  Must be superuser to create this extension.
2024-11-21 04:50:00.185 UTC client backend[15563] pg_regress/plperl_setup STATEMENT:  CREATE EXTENSION plperlu;
2024-11-21 04:50:00.213 UTC client backend[15567] pg_regress/plperl_setup ERROR:  permission denied for language plperl
2024-11-21 04:50:00.213 UTC client backend[15567] pg_regress/plperl_setup STATEMENT:  CREATE FUNCTION foo2() returns int language plperl as '2;';
2024-11-21 04:50:00.228 UTC client backend[15567] pg_regress/plperl_setup ERROR:  cannot drop language plperl because extension plperl requires it
2024-11-21 04:50:00.228 UTC client backend[15567] pg_regress/plperl_setup HINT:  You can drop extension plperl instead.
2024-11-21 04:50:00.228 UTC client backend[15567] pg_regress/plperl_setup STATEMENT:  DROP LANGUAGE plperl CASCADE;
2024-11-21 04:50:00.268 UTC client backend[15571] pg_regress/plperl ERROR:  SETOF-composite-returning PL/Perl function must call return_next with reference to hash
2024-11-21 04:50:00.268 UTC client backend[15571] pg_regress/plperl CONTEXT:  PL/Perl function "perl_set"
2024-11-21 04:50:00.268 UTC client backend[15571] pg_regress/plperl STATEMENT:  SELECT perl_set();
2024-11-21 04:50:00.268 UTC client backend[15571] pg_regress/plperl ERROR:  SETOF-composite-returning PL/Perl function must call return_next with reference to hash
2024-11-21 04:50:00.268 UTC client backend[15571] pg_regress/plperl CONTEXT:  PL/Perl function "perl_set"
2024-11-21 04:50:00.268 UTC client backend[15571] pg_regress/plperl STATEMENT:  SELECT * FROM perl_set();
2024-11-21 04:50:00.270 UTC client backend[15571] pg_regress/plperl ERROR:  a column definition list is required for functions returning "record" at character 15
2024-11-21 04:50:00.270 UTC client backend[15571] pg_regress/plperl STATEMENT:  SELECT * FROM perl_record();
2024-11-21 04:50:00.271 UTC client backend[15571] pg_regress/plperl ERROR:  function returning record called in context that cannot accept type record
2024-11-21 04:50:00.271 UTC client backend[15571] pg_regress/plperl CONTEXT:  PL/Perl function "perl_record"
2024-11-21 04:50:00.271 UTC client backend[15571] pg_regress/plperl STATEMENT:  SELECT perl_record();
2024-11-21 04:50:00.271 UTC client backend[15571] pg_regress/plperl ERROR:  a column definition list is required for functions returning "record" at character 15
2024-11-21 04:50:00.271 UTC client backend[15571] pg_regress/plperl STATEMENT:  SELECT * FROM perl_record();
2024-11-21 04:50:00.272 UTC client backend[15571] pg_regress/plperl ERROR:  a column definition list is required for functions returning "record" at character 15
2024-11-21 04:50:00.272 UTC client backend[15571] pg_regress/plperl STATEMENT:  SELECT * FROM perl_record_set();
2024-11-21 04:50:00.272 UTC client backend[15571] pg_regress/plperl ERROR:  function returning record called in context that cannot accept type record
2024-11-21 04:50:00.272 UTC client backend[15571] pg_regress/plperl CONTEXT:  PL/Perl function "perl_record_set"
2024-11-21 04:50:00.272 UTC client backend[15571] pg_regress/plperl STATEMENT:  SELECT perl_record_set();
2024-11-21 04:50:00.272 UTC client backend[15571] pg_regress/plperl ERROR:  a column definition list is required for functions returning "record" at character 15
2024-11-21 04:50:00.272 UTC client backend[15571] pg_regress/plperl STATEMENT:  SELECT * FROM perl_record_set();
2024-11-21 04:50:00.272 UTC client backend[15571] pg_regress/plperl ERROR:  SETOF-composite-returning PL/Perl function must call return_next with reference to hash
2024-11-21 04:50:00.272 UTC client backend[15571] pg_regress/plperl CONTEXT:  PL/Perl function "perl_record_set"
2024-11-21 04:50:00.272 UTC client backend[15571] pg_regress/plperl STATEMENT:  SELECT * FROM perl_record_set() AS (f1 integer, f2 text, f3 text);
2024-11-21 04:50:00.273 UTC client backend[15571] pg_regress/plperl ERROR:  function returning record called in context that cannot accept type record
2024-11-21 04:50:00.273 UTC client backend[15571] pg_regress/plperl CONTEXT:  PL/Perl function "perl_record_set"
2024-11-21 04:50:00.273 UTC client backend[15571] pg_regress/plperl STATEMENT:  SELECT perl_record_set();
2024-11-21 04:50:00.273 UTC client backend[15571] pg_regress/plperl ERROR:  a column definition list is required for functions returning "record" at character 15
2024-11-21 04:50:00.273 UTC client backend[15571] pg_regress/plperl STATEMENT:  SELECT * FROM perl_record_set();
2024-11-21 04:50:00.277 UTC client backend[15571] pg_regress/plperl ERROR:  Perl hash contains nonexistent column "z"
2024-11-21 04:50:00.277 UTC client backend[15571] pg_regress/plperl CONTEXT:  PL/Perl function "foo_bad"
2024-11-21 04:50:00.277 UTC client backend[15571] pg_regress/plperl STATEMENT:  SELECT * FROM foo_bad();
2024-11-21 04:50:00.277 UTC client backend[15571] pg_regress/plperl ERROR:  malformed record literal: "42"
2024-11-21 04:50:00.277 UTC client backend[15571] pg_regress/plperl DETAIL:  Missing left parenthesis.
2024-11-21 04:50:00.277 UTC client backend[15571] pg_regress/plperl CONTEXT:  PL/Perl function "foo_bad"
2024-11-21 04:50:00.277 UTC client backend[15571] pg_regress/plperl STATEMENT:  SELECT * FROM foo_bad();
2024-11-21 04:50:00.278 UTC client backend[15571] pg_regress/plperl ERROR:  cannot convert Perl array to non-array type footype
2024-11-21 04:50:00.278 UTC client backend[15571] pg_regress/plperl CONTEXT:  PL/Perl function "foo_bad"
2024-11-21 04:50:00.278 UTC client backend[15571] pg_regress/plperl STATEMENT:  SELECT * FROM foo_bad();
2024-11-21 04:50:00.278 UTC client backend[15571] pg_regress/plperl ERROR:  set-returning PL/Perl function must return reference to array or use return_next
2024-11-21 04:50:00.278 UTC client backend[15571] pg_regress/plperl CONTEXT:  PL/Perl function "foo_set_bad"
2024-11-21 04:50:00.278 UTC client backend[15571] pg_regress/plperl STATEMENT:  SELECT * FROM foo_set_bad();
2024-11-21 04:50:00.279 UTC client backend[15571] pg_regress/plperl ERROR:  set-returning PL/Perl function must return reference to array or use return_next
2024-11-21 04:50:00.279 UTC client backend[15571] pg_regress/plperl CONTEXT:  PL/Perl function "foo_set_bad"
2024-11-21 04:50:00.279 UTC client backend[15571] pg_regress/plperl STATEMENT:  SELECT * FROM foo_set_bad();
2024-11-21 04:50:00.279 UTC client backend[15571] pg_regress/plperl ERROR:  SETOF-composite-returning PL/Perl function must call return_next with reference to hash
2024-11-21 04:50:00.279 UTC client backend[15571] pg_regress/plperl CONTEXT:  PL/Perl function "foo_set_bad"
2024-11-21 04:50:00.279 UTC client backend[15571] pg_regress/plperl STATEMENT:  SELECT * FROM foo_set_bad();
2024-11-21 04:50:00.280 UTC client backend[15571] pg_regress/plperl ERROR:  Perl hash contains nonexistent column "z"
2024-11-21 04:50:00.280 UTC client backend[15571] pg_regress/plperl CONTEXT:  PL/Perl function "foo_set_bad"
2024-11-21 04:50:00.280 UTC client backend[15571] pg_regress/plperl STATEMENT:  SELECT * FROM foo_set_bad();
2024-11-21 04:50:00.282 UTC client backend[15571] pg_regress/plperl ERROR:  value for domain orderedfootype violates check constraint "orderedfootype_check"
2024-11-21 04:50:00.282 UTC client backend[15571] pg_regress/plperl CONTEXT:  PL/Perl function "foo_ordered"
2024-11-21 04:50:00.282 UTC client backend[15571] pg_regress/plperl STATEMENT:  SELECT * FROM foo_ordered();
2024-11-21 04:50:00.283 UTC client backend[15571] pg_regress/plperl ERROR:  value for domain orderedfootype violates check constraint "orderedfootype_check"
2024-11-21 04:50:00.283 UTC client backend[15571] pg_regress/plperl CONTEXT:  PL/Perl function "foo_ordered_set"
2024-11-21 04:50:00.283 UTC client backend[15571] pg_regress/plperl STATEMENT:  SELECT * FROM foo_ordered_set();
2024-11-21 04:50:00.286 UTC client backend[15571] pg_regress/plperl ERROR:  value for domain orderedfootype violates check constraint "orderedfootype_check"
2024-11-21 04:50:00.286 UTC client backend[15571] pg_regress/plperl STATEMENT:  SELECT perl_get_cfield((12,11), 'x');
2024-11-21 04:50:00.287 UTC client backend[15571] pg_regress/plperl ERROR:  value for domain orderedfootype violates check constraint "orderedfootype_check"
2024-11-21 04:50:00.287 UTC client backend[15571] pg_regress/plperl STATEMENT:  SELECT perl_get_rfield((12,11)::orderedfootype, 'x');
2024-11-21 04:50:00.294 UTC client backend[15571] pg_regress/plperl ERROR:  type "does_not_exist" does not exist at line 2.
2024-11-21 04:50:00.294 UTC client backend[15571] pg_regress/plperl CONTEXT:  PL/Perl function "perl_spi_prepared_bad"
2024-11-21 04:50:00.294 UTC client backend[15571] pg_regress/plperl STATEMENT:  SELECT perl_spi_prepared_bad(4.35) as "double precision";
2024-11-21 04:50:00.296 UTC client backend[15571] pg_regress/plperl ERROR:  'system' trapped by operation mask at line 1.
2024-11-21 04:50:00.296 UTC client backend[15571] pg_regress/plperl CONTEXT:  PL/Perl anonymous code block
2024-11-21 04:50:00.296 UTC client backend[15571] pg_regress/plperl STATEMENT:  DO $$ system("/nonesuch"); $$ LANGUAGE plperl;
2024-11-21 04:50:00.296 UTC client backend[15571] pg_regress/plperl ERROR:  'quoted execution (``, qx)' trapped by operation mask at line 1.
2024-11-21 04:50:00.296 UTC client backend[15571] pg_regress/plperl CONTEXT:  PL/Perl anonymous code block
2024-11-21 04:50:00.296 UTC client backend[15571] pg_regress/plperl STATEMENT:  DO $$ qx("/nonesuch"); $$ LANGUAGE plperl;
2024-11-21 04:50:00.296 UTC client backend[15571] pg_regress/plperl ERROR:  'open' trapped by operation mask at line 1.
2024-11-21 04:50:00.296 UTC client backend[15571] pg_regress/plperl CONTEXT:  PL/Perl anonymous code block
2024-11-21 04:50:00.296 UTC client backend[15571] pg_regress/plperl STATEMENT:  DO $$ open my $fh, "</nonesuch"; $$ LANGUAGE plperl;
2024-11-21 04:50:00.296 UTC client backend[15571] pg_regress/plperl WARNING:  Caught: 'chdir' trapped by operation mask at line 1.
2024-11-21 04:50:00.296 UTC client backend[15571] pg_regress/plperl CONTEXT:  PL/Perl anonymous code block
2024-11-21 04:50:00.296 UTC client backend[15571] pg_regress/plperl ERROR:  Unable to load /dev/null into plperl at line 1.
2024-11-21 04:50:00.296 UTC client backend[15571] pg_regress/plperl CONTEXT:  PL/Perl anonymous code block
2024-11-21 04:50:00.296 UTC client backend[15571] pg_regress/plperl STATEMENT:  DO $$ warn do "/dev/null"; $$ LANGUAGE plperl;
2024-11-21 04:50:00.296 UTC client backend[15571] pg_regress/plperl ERROR:  Unable to load blib.pm into plperl at line 1.
	BEGIN failed--compilation aborted at line 1.
2024-11-21 04:50:00.296 UTC client backend[15571] pg_regress/plperl CONTEXT:  PL/Perl anonymous code block
2024-11-21 04:50:00.296 UTC client backend[15571] pg_regress/plperl STATEMENT:  DO $$ use blib; $$ LANGUAGE plperl;
2024-11-21 04:50:00.296 UTC client backend[15571] pg_regress/plperl ERROR:  Can't use string ("foo") as a SCALAR ref while "strict refs" in use at line 1.
2024-11-21 04:50:00.296 UTC client backend[15571] pg_regress/plperl CONTEXT:  PL/Perl anonymous code block
2024-11-21 04:50:00.296 UTC client backend[15571] pg_regress/plperl STATEMENT:  DO $do$ use strict; my $name = "foo"; my $ref = $$name; $do$ LANGUAGE plperl;
2024-11-21 04:50:00.297 UTC client backend[15571] pg_regress/plperl ERROR:  Useless use of sort in void context at line 1.
2024-11-21 04:50:00.297 UTC client backend[15571] pg_regress/plperl CONTEXT:  PL/Perl anonymous code block
2024-11-21 04:50:00.297 UTC client backend[15571] pg_regress/plperl STATEMENT:  DO $do$ use warnings FATAL => qw(void) ; my @y; sort @y; 1; $do$ LANGUAGE plperl;
2024-11-21 04:50:00.298 UTC client backend[15571] pg_regress/plperl ERROR:  cannot convert Perl array to non-array type text
2024-11-21 04:50:00.298 UTC client backend[15571] pg_regress/plperl CONTEXT:  PL/Perl function "text_arrayref"
2024-11-21 04:50:00.298 UTC client backend[15571] pg_regress/plperl STATEMENT:  SELECT text_arrayref();
2024-11-21 04:50:00.298 UTC client backend[15571] pg_regress/plperl ERROR:  cannot convert Perl hash to non-composite type text
2024-11-21 04:50:00.298 UTC client backend[15571] pg_regress/plperl CONTEXT:  PL/Perl function "text_hashref"
2024-11-21 04:50:00.298 UTC client backend[15571] pg_regress/plperl STATEMENT:  SELECT text_hashref();
2024-11-21 04:50:00.299 UTC client backend[15571] pg_regress/plperl ERROR:  cannot convert Perl hash to non-composite type text
2024-11-21 04:50:00.299 UTC client backend[15571] pg_regress/plperl CONTEXT:  PL/Perl function "text_obj"
2024-11-21 04:50:00.299 UTC client backend[15571] pg_regress/plperl STATEMENT:  SELECT text_obj();
2024-11-21 04:50:00.321 UTC client backend[15575] pg_regress/plperl_lc ERROR:  invalid byte sequence for encoding "UTF8": 0x00
2024-11-21 04:50:00.321 UTC client backend[15575] pg_regress/plperl_lc CONTEXT:  PL/Perl function "perl_zerob"
2024-11-21 04:50:00.321 UTC client backend[15575] pg_regress/plperl_lc STATEMENT:  SELECT perl_zerob();
2024-11-21 04:50:00.371 UTC client backend[15578] pg_regress/plperl_trigger ERROR:  trigger functions can only be called as triggers
2024-11-21 04:50:00.371 UTC client backend[15578] pg_regress/plperl_trigger CONTEXT:  compilation of PL/Perl function "direct_trigger"
2024-11-21 04:50:00.371 UTC client backend[15578] pg_regress/plperl_trigger STATEMENT:  SELECT direct_trigger();
2024-11-21 04:50:00.383 UTC client backend[15578] pg_regress/plperl_trigger ERROR:  cannot set generated column "j"
2024-11-21 04:50:00.383 UTC client backend[15578] pg_regress/plperl_trigger CONTEXT:  PL/Perl function "generated_test_func1"
2024-11-21 04:50:00.383 UTC client backend[15578] pg_regress/plperl_trigger STATEMENT:  INSERT INTO trigger_test_generated (i) VALUES (1);
2024-11-21 04:50:00.460 UTC client backend[15588] pg_regress/plperl_elog WARNING:  implicit elog via warn at line 4.
2024-11-21 04:50:00.460 UTC client backend[15588] pg_regress/plperl_elog CONTEXT:  PL/Perl function "perl_warn"
2024-11-21 04:50:00.461 UTC client backend[15588] 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-11-21 04:50:00.461 UTC client backend[15588] pg_regress/plperl_elog CONTEXT:  compilation of PL/Perl function "uses_global"
2024-11-21 04:50:00.461 UTC client backend[15588] 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-11-21 04:50:00.461 UTC client backend[15588] pg_regress/plperl_elog ERROR:  function uses_global() does not exist at character 8
2024-11-21 04:50:00.461 UTC client backend[15588] pg_regress/plperl_elog HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2024-11-21 04:50:00.461 UTC client backend[15588] pg_regress/plperl_elog STATEMENT:  select uses_global();
2024-11-21 04:50:00.462 UTC client backend[15588] pg_regress/plperl_elog ERROR:  just die at line 2.
2024-11-21 04:50:00.462 UTC client backend[15588] pg_regress/plperl_elog CONTEXT:  PL/Perl function "just_die"
2024-11-21 04:50:00.462 UTC client backend[15588] pg_regress/plperl_elog STATEMENT:  select just_die();
2024-11-21 04:50:00.465 UTC client backend[15588] pg_regress/plperl_elog ERROR:  this message contains a no-break space at line 2.
2024-11-21 04:50:00.465 UTC client backend[15588] pg_regress/plperl_elog CONTEXT:  PL/Perl function "error_with_nbsp"
2024-11-21 04:50:00.465 UTC client backend[15588] pg_regress/plperl_elog STATEMENT:  select error_with_nbsp();
2024-11-21 04:50:00.518 UTC client backend[15593] pg_regress/plperl_util ERROR:  value for domain perl_foo_pos violates check constraint "perl_foo_pos_check"
2024-11-21 04:50:00.518 UTC client backend[15593] pg_regress/plperl_util CONTEXT:  PL/Perl function "perl_encode_typed_literal"
2024-11-21 04:50:00.518 UTC client backend[15593] pg_regress/plperl_util STATEMENT:  select perl_encode_typed_literal();
2024-11-21 04:50:00.540 UTC client backend[15597] pg_regress/plperl_init ERROR:  'system' trapped by operation mask at line 1.
2024-11-21 04:50:00.540 UTC client backend[15597] pg_regress/plperl_init CONTEXT:  while executing plperl.on_plperl_init
	PL/Perl anonymous code block
2024-11-21 04:50:00.540 UTC client backend[15597] pg_regress/plperl_init STATEMENT:  DO $$ warn 42 $$ language plperl;
2024-11-21 04:50:00.547 UTC client backend[15598] pg_regress/plperl_init WARNING:  permission denied to set parameter "plperl.on_plperl_init"
2024-11-21 04:50:00.558 UTC client backend[15598] pg_regress/plperl_init WARNING:  42 at line 1.
2024-11-21 04:50:00.558 UTC client backend[15598] pg_regress/plperl_init CONTEXT:  PL/Perl anonymous code block
2024-11-21 04:50:00.558 UTC client backend[15598] pg_regress/plperl_init ERROR:  permission denied to set parameter "plperl.on_plperl_init"
2024-11-21 04:50:00.558 UTC client backend[15598] pg_regress/plperl_init STATEMENT:  SET SESSION plperl.on_plperl_init = 'test';
2024-11-21 04:50:00.573 UTC client backend[15602] pg_regress/plperlu WARNING:  42 at line 1.
2024-11-21 04:50:00.573 UTC client backend[15602] pg_regress/plperlu CONTEXT:  PL/Perl anonymous code block
2024-11-21 04:50:00.600 UTC client backend[15605] pg_regress/plperl_array ERROR:  number of array dimensions exceeds the maximum allowed (6) at character 25
2024-11-21 04:50:00.600 UTC client backend[15605] 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-11-21 04:50:00.600 UTC client backend[15605] 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-11-21 04:50:00.600 UTC client backend[15605] pg_regress/plperl_array DETAIL:  Multidimensional arrays must have sub-arrays with matching dimensions.
2024-11-21 04:50:00.600 UTC client backend[15605] pg_regress/plperl_array STATEMENT:  select plperl_sum_array('{{{1,2,3}, {4,5,6,7}}, {{7,8,9}, {10, 11, 12}}}');
2024-11-21 04:50:00.609 UTC client backend[15605] pg_regress/plperl_array ERROR:  multidimensional arrays must have array expressions with matching dimensions
2024-11-21 04:50:00.609 UTC client backend[15605] pg_regress/plperl_array CONTEXT:  PL/Perl function "plperl_md_array_out"
2024-11-21 04:50:00.609 UTC client backend[15605] pg_regress/plperl_array STATEMENT:  select plperl_md_array_out();
2024-11-21 04:50:00.609 UTC client backend[15605] pg_regress/plperl_array ERROR:  multidimensional arrays must have array expressions with matching dimensions
2024-11-21 04:50:00.609 UTC client backend[15605] pg_regress/plperl_array CONTEXT:  PL/Perl function "plperl_md_array_out"
2024-11-21 04:50:00.609 UTC client backend[15605] pg_regress/plperl_array STATEMENT:  select plperl_md_array_out();
2024-11-21 04:50:00.609 UTC client backend[15605] pg_regress/plperl_array ERROR:  multidimensional arrays must have array expressions with matching dimensions
2024-11-21 04:50:00.609 UTC client backend[15605] pg_regress/plperl_array CONTEXT:  PL/Perl function "plperl_md_array_out"
2024-11-21 04:50:00.609 UTC client backend[15605] pg_regress/plperl_array STATEMENT:  select plperl_md_array_out();
2024-11-21 04:50:00.610 UTC client backend[15605] pg_regress/plperl_array ERROR:  multidimensional arrays must have array expressions with matching dimensions
2024-11-21 04:50:00.610 UTC client backend[15605] pg_regress/plperl_array CONTEXT:  PL/Perl function "plperl_md_array_out"
2024-11-21 04:50:00.610 UTC client backend[15605] pg_regress/plperl_array STATEMENT:  select plperl_md_array_out();
2024-11-21 04:50:00.686 UTC client backend[15614] pg_regress/plperl_transaction ERROR:  invalid transaction termination at line 5.
2024-11-21 04:50:00.686 UTC client backend[15614] pg_regress/plperl_transaction CONTEXT:  PL/Perl function "transaction_test2"
2024-11-21 04:50:00.686 UTC client backend[15614] pg_regress/plperl_transaction STATEMENT:  SELECT transaction_test2();
2024-11-21 04:50:00.687 UTC client backend[15614] pg_regress/plperl_transaction ERROR:  invalid transaction termination at line 5. at line 2.
2024-11-21 04:50:00.687 UTC client backend[15614] pg_regress/plperl_transaction CONTEXT:  PL/Perl function "transaction_test3"
2024-11-21 04:50:00.687 UTC client backend[15614] pg_regress/plperl_transaction STATEMENT:  SELECT transaction_test3();
2024-11-21 04:50:00.688 UTC client backend[15614] pg_regress/plperl_transaction ERROR:  invalid transaction termination at line 1. at line 2.
2024-11-21 04:50:00.688 UTC client backend[15614] pg_regress/plperl_transaction CONTEXT:  PL/Perl function "transaction_test4"
2024-11-21 04:50:00.688 UTC client backend[15614] pg_regress/plperl_transaction STATEMENT:  SELECT transaction_test4();
2024-11-21 04:50:00.694 UTC client backend[15614] pg_regress/plperl_transaction ERROR:  division by zero at line 5.
2024-11-21 04:50:00.694 UTC client backend[15614] pg_regress/plperl_transaction CONTEXT:  PL/Perl anonymous code block
2024-11-21 04:50:00.694 UTC client backend[15614] 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-11-21 04:50:00.704 UTC client backend[15614] pg_regress/plperl_transaction ERROR:  insert or update on table "testfk" violates foreign key constraint "testfk_f1_fkey" at line 4.
2024-11-21 04:50:00.704 UTC client backend[15614] pg_regress/plperl_transaction CONTEXT:  PL/Perl anonymous code block
2024-11-21 04:50:00.704 UTC client backend[15614] 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-11-21 04:50:00.743 UTC client backend[15618] pg_regress/plperl_env WARNING:  attempted alteration of $ENV{TEST_PLPERL_ENV_FOO} at line 12.
2024-11-21 04:50:00.743 UTC client backend[15618] pg_regress/plperl_env CONTEXT:  PL/Perl anonymous code block
2024-11-21 04:50:00.751 UTC postmaster[15545] LOG:  received fast shutdown request
2024-11-21 04:50:00.751 UTC postmaster[15545] 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: 15545
0xa9fc22 <ExceptionalCondition+0x72> at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres
0x89ce37 <PostmasterStateMachine+0x3a7> at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres
0x89b339 <ServerLoop+0x419> at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres
0x89a70b <PostmasterMain+0x11cb> at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres