2024-12-27 05:16:37.256 UTC postmaster[33677] LOG:  starting PostgreSQL 18devel on x86_64-linux, compiled by gcc-12.2.0, 64-bit
2024-12-27 05:16:37.256 UTC postmaster[33677] LOG:  listening on Unix socket "/tmp/pg_regress-pEiiMC/.s.PGSQL.40000"
2024-12-27 05:16:37.261 UTC startup[33684] LOG:  database system was shut down at 2024-12-27 05:15:34 UTC
2024-12-27 05:16:37.265 UTC postmaster[33677] LOG:  database system is ready to accept connections
2024-12-27 05:16:37.478 UTC client backend[33752] pg_regress/plpgsql_array ERROR:  malformed array literal: "4"
2024-12-27 05:16:37.478 UTC client backend[33752] pg_regress/plpgsql_array DETAIL:  Array value must start with "{" or dimension information.
2024-12-27 05:16:37.478 UTC client backend[33752] pg_regress/plpgsql_array CONTEXT:  PL/pgSQL function inline_code_block line 2 at assignment
2024-12-27 05:16:37.478 UTC client backend[33752] pg_regress/plpgsql_array STATEMENT:  do $$ declare a int[];
	begin a[1:2] := 4; raise notice 'a = %', a; end$$;
2024-12-27 05:16:37.481 UTC client backend[33752] pg_regress/plpgsql_array ERROR:  cannot assign to field "i" of column "a" because its type complex[] is not a composite type at character 1
2024-12-27 05:16:37.481 UTC client backend[33752] pg_regress/plpgsql_array QUERY:  a[1:2].i := array[11,12]
2024-12-27 05:16:37.481 UTC client backend[33752] pg_regress/plpgsql_array CONTEXT:  PL/pgSQL function inline_code_block line 2 at assignment
2024-12-27 05:16:37.481 UTC client backend[33752] pg_regress/plpgsql_array STATEMENT:  do $$ declare a complex[];
	begin a[1:2].i := array[11,12]; raise notice 'a = %', a; end$$;
2024-12-27 05:16:37.502 UTC client backend[33752] pg_regress/plpgsql_array ERROR:  assignment source returned 0 columns
2024-12-27 05:16:37.502 UTC client backend[33752] pg_regress/plpgsql_array CONTEXT:  PL/pgSQL assignment "a := from onecol"
	PL/pgSQL function inline_code_block line 2 at assignment
2024-12-27 05:16:37.502 UTC client backend[33752] pg_regress/plpgsql_array STATEMENT:  do $$ declare a int[];
	begin a := from onecol; raise notice 'a = %', a; end$$;
2024-12-27 05:16:37.502 UTC client backend[33752] pg_regress/plpgsql_array ERROR:  assignment source returned 2 columns
2024-12-27 05:16:37.502 UTC client backend[33752] pg_regress/plpgsql_array CONTEXT:  PL/pgSQL assignment "a := f1, f1 from onecol"
	PL/pgSQL function inline_code_block line 2 at assignment
2024-12-27 05:16:37.502 UTC client backend[33752] pg_regress/plpgsql_array STATEMENT:  do $$ declare a int[];
	begin a := f1, f1 from onecol; raise notice 'a = %', a; end$$;
2024-12-27 05:16:37.503 UTC client backend[33752] pg_regress/plpgsql_array ERROR:  query returned more than one row
2024-12-27 05:16:37.503 UTC client backend[33752] pg_regress/plpgsql_array CONTEXT:  query: a := f1 from onecol
	PL/pgSQL function inline_code_block line 2 at assignment
2024-12-27 05:16:37.503 UTC client backend[33752] pg_regress/plpgsql_array STATEMENT:  do $$ declare a int[];
	begin a := f1 from onecol; raise notice 'a = %', a; end$$;
2024-12-27 05:16:37.504 UTC client backend[33752] pg_regress/plpgsql_array ERROR:  cannot subscript type real because it does not support subscripting at character 1
2024-12-27 05:16:37.504 UTC client backend[33752] pg_regress/plpgsql_array QUERY:  a[1] := 2
2024-12-27 05:16:37.504 UTC client backend[33752] pg_regress/plpgsql_array CONTEXT:  PL/pgSQL function inline_code_block line 2 at assignment
2024-12-27 05:16:37.504 UTC client backend[33752] pg_regress/plpgsql_array STATEMENT:  do $$ declare a real;
	begin a[1] := 2; raise notice 'a = %', a; end$$;
2024-12-27 05:16:37.506 UTC client backend[33752] pg_regress/plpgsql_array ERROR:  cannot subscript type double precision because it does not support subscripting at character 1
2024-12-27 05:16:37.506 UTC client backend[33752] pg_regress/plpgsql_array QUERY:  a.r[1] := 2
2024-12-27 05:16:37.506 UTC client backend[33752] pg_regress/plpgsql_array CONTEXT:  PL/pgSQL function inline_code_block line 2 at assignment
2024-12-27 05:16:37.506 UTC client backend[33752] pg_regress/plpgsql_array STATEMENT:  do $$ declare a complex;
	begin a.r[1] := 2; raise notice 'a = %', a; end$$;
2024-12-27 05:16:37.508 UTC client backend[33752] pg_regress/plpgsql_array ERROR:  could not find array type for data type pg_node_tree
2024-12-27 05:16:37.508 UTC client backend[33752] pg_regress/plpgsql_array CONTEXT:  compilation of PL/pgSQL function "inline_code_block" near line 4
2024-12-27 05:16:37.508 UTC client backend[33752] pg_regress/plpgsql_array STATEMENT:  do $$
	declare
	  v pg_node_tree;
	  v1 v%type[];
	begin
	end;
	$$;
2024-12-27 05:16:37.662 UTC client backend[33779] pg_regress/plpgsql_cache ERROR:  type of parameter 4 (double precision) does not match that when preparing the plan (integer)
2024-12-27 05:16:37.662 UTC client backend[33779] pg_regress/plpgsql_cache CONTEXT:  PL/pgSQL function c_sillyaddone(integer) line 1 at RETURN
2024-12-27 05:16:37.662 UTC client backend[33779] pg_regress/plpgsql_cache STATEMENT:  select c_sillyaddone(42);
2024-12-27 05:16:37.668 UTC client backend[33779] pg_regress/plpgsql_cache ERROR:  type of parameter 5 (numeric) does not match that when preparing the plan (integer)
2024-12-27 05:16:37.668 UTC client backend[33779] pg_regress/plpgsql_cache CONTEXT:  SQL statement "select pg_typeof(r.a)"
	PL/pgSQL function show_result_type(text) line 7 at SQL statement
2024-12-27 05:16:37.668 UTC client backend[33779] pg_regress/plpgsql_cache STATEMENT:  select show_result_type('select 2.0 as a');
2024-12-27 05:16:37.746 UTC client backend[33788] pg_regress/plpgsql_call ERROR:  RETURN cannot have a parameter in a procedure at character 71
2024-12-27 05:16:37.746 UTC client backend[33788] pg_regress/plpgsql_call STATEMENT:  CREATE PROCEDURE test_proc2()
	LANGUAGE plpgsql
	AS $$
	BEGIN
	    RETURN 5;
	END;
	$$;
2024-12-27 05:16:37.761 UTC client backend[33788] pg_regress/plpgsql_call ERROR:  procedure parameter "b" is an output parameter but corresponding argument is not writable
2024-12-27 05:16:37.761 UTC client backend[33788] pg_regress/plpgsql_call CONTEXT:  PL/pgSQL function inline_code_block line 6 at CALL
2024-12-27 05:16:37.761 UTC client backend[33788] pg_regress/plpgsql_call STATEMENT:  DO
	LANGUAGE plpgsql
	$$
	DECLARE
	    x int := 3;
	    y int := 4;
	BEGIN
	    CALL test_proc6(2, x + 1, y);  -- error
	    RAISE INFO 'x = %, y = %', x, y;
	END;
	$$;
2024-12-27 05:16:37.762 UTC client backend[33788] pg_regress/plpgsql_call ERROR:  variable "x" is declared CONSTANT
2024-12-27 05:16:37.762 UTC client backend[33788] pg_regress/plpgsql_call CONTEXT:  PL/pgSQL function inline_code_block line 6 at CALL
2024-12-27 05:16:37.762 UTC client backend[33788] pg_regress/plpgsql_call STATEMENT:  DO
	LANGUAGE plpgsql
	$$
	DECLARE
	    x constant int := 3;
	    y int := 4;
	BEGIN
	    CALL test_proc6(2, x, y);  -- error because x is constant
	END;
	$$;
2024-12-27 05:16:37.790 UTC client backend[33788] pg_regress/plpgsql_call ERROR:  procedure parameter "c" is an output parameter but corresponding argument is not writable
2024-12-27 05:16:37.790 UTC client backend[33788] pg_regress/plpgsql_call CONTEXT:  PL/pgSQL function inline_code_block line 5 at CALL
2024-12-27 05:16:37.790 UTC client backend[33788] pg_regress/plpgsql_call STATEMENT:  DO $$
	DECLARE _a int; _b int; _c int;
	BEGIN
	  _a := 10; _b := 30; _c := 50;
	  CALL test_proc8c(_a, _b);  -- fail, no output argument for c
	  RAISE NOTICE '_a: %, _b: %, _c: %', _a, _b, _c;
	END
	$$;
2024-12-27 05:16:37.790 UTC client backend[33788] pg_regress/plpgsql_call ERROR:  procedure parameter "c" is an output parameter but corresponding argument is not writable
2024-12-27 05:16:37.790 UTC client backend[33788] pg_regress/plpgsql_call CONTEXT:  PL/pgSQL function inline_code_block line 5 at CALL
2024-12-27 05:16:37.790 UTC client backend[33788] pg_regress/plpgsql_call STATEMENT:  DO $$
	DECLARE _a int; _b int; _c int;
	BEGIN
	  _a := 10; _b := 30; _c := 50;
	  CALL test_proc8c(_a, b => _b);  -- fail, no output argument for c
	  RAISE NOTICE '_a: %, _b: %, _c: %', _a, _b, _c;
	END
	$$;
2024-12-27 05:16:37.799 UTC client backend[33788] pg_regress/plpgsql_call ERROR:  procedure test_proc12(integer, integer, text[]) does not exist at character 6
2024-12-27 05:16:37.799 UTC client backend[33788] pg_regress/plpgsql_call HINT:  No procedure matches the given name and argument types. You might need to add explicit type casts.
2024-12-27 05:16:37.799 UTC client backend[33788] pg_regress/plpgsql_call QUERY:  CALL test_proc12(_a, _b, _c)
2024-12-27 05:16:37.799 UTC client backend[33788] pg_regress/plpgsql_call CONTEXT:  PL/pgSQL function inline_code_block line 5 at CALL
2024-12-27 05:16:37.799 UTC client backend[33788] pg_regress/plpgsql_call STATEMENT:  DO $$
	DECLARE _a int; _b int; _c text[];
	BEGIN
	  _a := 10;
	  CALL test_proc12(_a, _b, _c);  -- error
	  RAISE NOTICE '_a: %, _b: %, _c: %', _a, _b, _c;
	END
	$$;
2024-12-27 05:16:37.809 UTC client backend[33788] pg_regress/plpgsql_call ERROR:  procedure parameter "v_text" is an output parameter but corresponding argument is not writable
2024-12-27 05:16:37.809 UTC client backend[33788] pg_regress/plpgsql_call CONTEXT:  PL/pgSQL function inline_code_block line 6 at CALL
2024-12-27 05:16:37.809 UTC client backend[33788] pg_regress/plpgsql_call STATEMENT:  DO $$
	DECLARE
	  v_Text text;
	  v_cnt  integer := 42;
	BEGIN
	  CALL p1(v_cnt := v_cnt);  -- error, must supply something for v_Text
	  RAISE NOTICE '%', v_Text;
	END;
	$$;
2024-12-27 05:16:37.887 UTC client backend[33811] pg_regress/plpgsql_control ERROR:  BY value of FOR loop must be greater than zero
2024-12-27 05:16:37.887 UTC client backend[33811] pg_regress/plpgsql_control CONTEXT:  PL/pgSQL function inline_code_block line 3 at FOR with integer loop variable
2024-12-27 05:16:37.887 UTC client backend[33811] pg_regress/plpgsql_control STATEMENT:  do $$
	begin
	  for i in 1..3 by 0 loop
	    raise notice '1..3 by 0: i = %', i;
	  end loop;
	end$$;
2024-12-27 05:16:37.888 UTC client backend[33811] pg_regress/plpgsql_control ERROR:  BY value of FOR loop must be greater than zero
2024-12-27 05:16:37.888 UTC client backend[33811] pg_regress/plpgsql_control CONTEXT:  PL/pgSQL function inline_code_block line 3 at FOR with integer loop variable
2024-12-27 05:16:37.888 UTC client backend[33811] pg_regress/plpgsql_control STATEMENT:  do $$
	begin
	  for i in 1..3 by -1 loop
	    raise notice '1..3 by -1: i = %', i;
	  end loop;
	end$$;
2024-12-27 05:16:37.888 UTC client backend[33811] pg_regress/plpgsql_control ERROR:  BY value of FOR loop must be greater than zero
2024-12-27 05:16:37.888 UTC client backend[33811] pg_regress/plpgsql_control CONTEXT:  PL/pgSQL function inline_code_block line 3 at FOR with integer loop variable
2024-12-27 05:16:37.888 UTC client backend[33811] pg_regress/plpgsql_control STATEMENT:  do $$
	begin
	  for i in reverse 1..3 by -1 loop
	    raise notice 'reverse 1..3 by -1: i = %', i;
	  end loop;
	end$$;
2024-12-27 05:16:37.914 UTC client backend[33811] pg_regress/plpgsql_control ERROR:  CONTINUE cannot be used outside a loop at character 78
2024-12-27 05:16:37.914 UTC client backend[33811] pg_regress/plpgsql_control STATEMENT:  create function continue_error1() returns void as $$
	begin
	    begin
	        continue;
	    end;
	end;
	$$ language plpgsql;
2024-12-27 05:16:37.914 UTC client backend[33811] pg_regress/plpgsql_control ERROR:  EXIT cannot be used outside a loop, unless it has a label at character 74
2024-12-27 05:16:37.914 UTC client backend[33811] pg_regress/plpgsql_control STATEMENT:  create function exit_error1() returns void as $$
	begin
	    begin
	        exit;
	    end;
	end;
	$$ language plpgsql;
2024-12-27 05:16:37.914 UTC client backend[33811] pg_regress/plpgsql_control ERROR:  there is no label "no_such_label" attached to any block or loop enclosing this statement at character 104
2024-12-27 05:16:37.914 UTC client backend[33811] pg_regress/plpgsql_control STATEMENT:  create function continue_error2() returns void as $$
	begin
	    begin
	        loop
	            continue no_such_label;
	        end loop;
	    end;
	end;
	$$ language plpgsql;
2024-12-27 05:16:37.915 UTC client backend[33811] pg_regress/plpgsql_control ERROR:  there is no label "no_such_label" attached to any block or loop enclosing this statement at character 96
2024-12-27 05:16:37.915 UTC client backend[33811] pg_regress/plpgsql_control STATEMENT:  create function exit_error2() returns void as $$
	begin
	    begin
	        loop
	            exit no_such_label;
	        end loop;
	    end;
	end;
	$$ language plpgsql;
2024-12-27 05:16:37.915 UTC client backend[33811] pg_regress/plpgsql_control ERROR:  block label "begin_block1" cannot be used in CONTINUE at character 125
2024-12-27 05:16:37.915 UTC client backend[33811] pg_regress/plpgsql_control STATEMENT:  create function continue_error3() returns void as $$
	begin
	    <<begin_block1>>
	    begin
	        loop
	            continue begin_block1;
	        end loop;
	    end;
	end;
	$$ language plpgsql;
2024-12-27 05:16:37.919 UTC client backend[33811] pg_regress/plpgsql_control ERROR:  end label "flbl1" specified for unlabeled block at character 101
2024-12-27 05:16:37.919 UTC client backend[33811] pg_regress/plpgsql_control STATEMENT:  create function end_label2() returns void as $$
	begin
	  for _i in 1 .. 10 loop
	    exit;
	  end loop flbl1;
	end;
	$$ language plpgsql;
2024-12-27 05:16:37.921 UTC client backend[33811] pg_regress/plpgsql_control ERROR:  end label "outer_label" differs from block's label "inner_label" at character 135
2024-12-27 05:16:37.921 UTC client backend[33811] pg_regress/plpgsql_control STATEMENT:  create function end_label3() returns void as $$
	<<outer_label>>
	begin
	  <<inner_label>>
	  for _i in 1 .. 10 loop
	    exit;
	  end loop outer_label;
	end;
	$$ language plpgsql;
2024-12-27 05:16:37.921 UTC client backend[33811] pg_regress/plpgsql_control ERROR:  end label "outer_label" specified for unlabeled block at character 117
2024-12-27 05:16:37.921 UTC client backend[33811] pg_regress/plpgsql_control STATEMENT:  create function end_label4() returns void as $$
	<<outer_label>>
	begin
	  for _i in 1 .. 10 loop
	    exit;
	  end loop outer_label;
	end;
	$$ language plpgsql;
2024-12-27 05:16:37.936 UTC client backend[33811] pg_regress/plpgsql_control ERROR:  case not found
2024-12-27 05:16:37.936 UTC client backend[33811] pg_regress/plpgsql_control HINT:  CASE statement is missing ELSE part.
2024-12-27 05:16:37.936 UTC client backend[33811] pg_regress/plpgsql_control CONTEXT:  PL/pgSQL function case_test(bigint) line 5 at CASE
2024-12-27 05:16:37.936 UTC client backend[33811] pg_regress/plpgsql_control STATEMENT:  select case_test(5);
2024-12-27 05:16:37.940 UTC client backend[33811] pg_regress/plpgsql_control ERROR:  case not found
2024-12-27 05:16:37.940 UTC client backend[33811] pg_regress/plpgsql_control HINT:  CASE statement is missing ELSE part.
2024-12-27 05:16:37.940 UTC client backend[33811] pg_regress/plpgsql_control CONTEXT:  PL/pgSQL function case_test(bigint) line 5 at CASE
2024-12-27 05:16:37.940 UTC client backend[33811] pg_regress/plpgsql_control STATEMENT:  select case_test(13);
2024-12-27 05:16:38.047 UTC client backend[33855] pg_regress/plpgsql_copy ERROR:  cannot COPY to/from client in PL/pgSQL
2024-12-27 05:16:38.047 UTC client backend[33855] pg_regress/plpgsql_copy CONTEXT:  PL/pgSQL function inline_code_block line 3 at SQL statement
2024-12-27 05:16:38.047 UTC client backend[33855] pg_regress/plpgsql_copy STATEMENT:  DO LANGUAGE plpgsql $$
	BEGIN
	  COPY copy1 TO stdout;
	END;
	$$;
2024-12-27 05:16:38.047 UTC client backend[33855] pg_regress/plpgsql_copy ERROR:  cannot COPY to/from client in PL/pgSQL
2024-12-27 05:16:38.047 UTC client backend[33855] pg_regress/plpgsql_copy CONTEXT:  PL/pgSQL function inline_code_block line 3 at SQL statement
2024-12-27 05:16:38.047 UTC client backend[33855] pg_regress/plpgsql_copy STATEMENT:  DO LANGUAGE plpgsql $$
	BEGIN
	  COPY copy1 FROM stdin;
	END;
	$$;
2024-12-27 05:16:38.047 UTC client backend[33855] pg_regress/plpgsql_copy ERROR:  cannot COPY to/from client in PL/pgSQL
2024-12-27 05:16:38.047 UTC client backend[33855] pg_regress/plpgsql_copy CONTEXT:  PL/pgSQL function inline_code_block line 3 at EXECUTE
2024-12-27 05:16:38.047 UTC client backend[33855] pg_regress/plpgsql_copy STATEMENT:  DO LANGUAGE plpgsql $$
	BEGIN
	  EXECUTE 'COPY copy1 TO stdout';
	END;
	$$;
2024-12-27 05:16:38.048 UTC client backend[33855] pg_regress/plpgsql_copy ERROR:  cannot COPY to/from client in PL/pgSQL
2024-12-27 05:16:38.048 UTC client backend[33855] pg_regress/plpgsql_copy CONTEXT:  PL/pgSQL function inline_code_block line 3 at EXECUTE
2024-12-27 05:16:38.048 UTC client backend[33855] pg_regress/plpgsql_copy STATEMENT:  DO LANGUAGE plpgsql $$
	BEGIN
	  EXECUTE 'COPY copy1 FROM stdin';
	END;
	$$;
2024-12-27 05:16:38.253 UTC client backend[33894] pg_regress/plpgsql_domain ERROR:  value for domain booltrue violates check constraint "booltrue_check"
2024-12-27 05:16:38.253 UTC client backend[33894] pg_regress/plpgsql_domain STATEMENT:  SELECT * FROM test_argresult_booltrue(false, true);
2024-12-27 05:16:38.253 UTC client backend[33894] pg_regress/plpgsql_domain ERROR:  value for domain booltrue violates check constraint "booltrue_check"
2024-12-27 05:16:38.253 UTC client backend[33894] pg_regress/plpgsql_domain CONTEXT:  PL/pgSQL function test_argresult_booltrue(booltrue,boolean) while casting return value to function's return type
2024-12-27 05:16:38.253 UTC client backend[33894] pg_regress/plpgsql_domain STATEMENT:  SELECT * FROM test_argresult_booltrue(true, false);
2024-12-27 05:16:38.253 UTC client backend[33894] pg_regress/plpgsql_domain ERROR:  value for domain booltrue violates check constraint "booltrue_check"
2024-12-27 05:16:38.253 UTC client backend[33894] pg_regress/plpgsql_domain CONTEXT:  PL/pgSQL function test_assign_booltrue(boolean,boolean) line 2 during statement block local variable initialization
2024-12-27 05:16:38.253 UTC client backend[33894] pg_regress/plpgsql_domain STATEMENT:  SELECT * FROM test_assign_booltrue(false, true);
2024-12-27 05:16:38.254 UTC client backend[33894] pg_regress/plpgsql_domain ERROR:  value for domain booltrue violates check constraint "booltrue_check"
2024-12-27 05:16:38.254 UTC client backend[33894] pg_regress/plpgsql_domain CONTEXT:  PL/pgSQL function test_assign_booltrue(boolean,boolean) line 4 at assignment
2024-12-27 05:16:38.254 UTC client backend[33894] pg_regress/plpgsql_domain STATEMENT:  SELECT * FROM test_assign_booltrue(true, false);
2024-12-27 05:16:38.267 UTC client backend[33894] pg_regress/plpgsql_domain ERROR:  value for domain uint2 violates check constraint "uint2_check"
2024-12-27 05:16:38.267 UTC client backend[33894] pg_regress/plpgsql_domain CONTEXT:  PL/pgSQL function test_argresult_uint2(uint2,integer) while casting return value to function's return type
2024-12-27 05:16:38.267 UTC client backend[33894] pg_regress/plpgsql_domain STATEMENT:  SELECT * FROM test_argresult_uint2(100::uint2, -50);
2024-12-27 05:16:38.268 UTC client backend[33894] pg_regress/plpgsql_domain ERROR:  value for domain uint2 violates check constraint "uint2_check"
2024-12-27 05:16:38.268 UTC client backend[33894] pg_regress/plpgsql_domain CONTEXT:  PL/pgSQL function test_assign_uint2(integer,integer) line 4 at assignment
2024-12-27 05:16:38.268 UTC client backend[33894] pg_regress/plpgsql_domain STATEMENT:  SELECT * FROM test_assign_uint2(100, -50);
2024-12-27 05:16:38.268 UTC client backend[33894] pg_regress/plpgsql_domain ERROR:  value for domain uint2 violates check constraint "uint2_check"
2024-12-27 05:16:38.268 UTC client backend[33894] pg_regress/plpgsql_domain CONTEXT:  PL/pgSQL function test_assign_uint2(integer,integer) line 2 during statement block local variable initialization
2024-12-27 05:16:38.268 UTC client backend[33894] pg_regress/plpgsql_domain STATEMENT:  SELECT * FROM test_assign_uint2(-100, 50);
2024-12-27 05:16:38.269 UTC client backend[33894] pg_regress/plpgsql_domain ERROR:  domain nnint does not allow null values
2024-12-27 05:16:38.269 UTC client backend[33894] pg_regress/plpgsql_domain STATEMENT:  SELECT * FROM test_argresult_nnint(null, 20);
2024-12-27 05:16:38.269 UTC client backend[33894] pg_regress/plpgsql_domain ERROR:  domain nnint does not allow null values
2024-12-27 05:16:38.269 UTC client backend[33894] pg_regress/plpgsql_domain CONTEXT:  PL/pgSQL function test_argresult_nnint(nnint,integer) while casting return value to function's return type
2024-12-27 05:16:38.269 UTC client backend[33894] pg_regress/plpgsql_domain STATEMENT:  SELECT * FROM test_argresult_nnint(10, null);
2024-12-27 05:16:38.270 UTC client backend[33894] pg_regress/plpgsql_domain ERROR:  domain nnint does not allow null values
2024-12-27 05:16:38.270 UTC client backend[33894] pg_regress/plpgsql_domain CONTEXT:  PL/pgSQL function test_assign_nnint(integer,integer) line 2 during statement block local variable initialization
2024-12-27 05:16:38.270 UTC client backend[33894] pg_regress/plpgsql_domain STATEMENT:  SELECT * FROM test_assign_nnint(null, 20);
2024-12-27 05:16:38.270 UTC client backend[33894] pg_regress/plpgsql_domain ERROR:  domain nnint does not allow null values
2024-12-27 05:16:38.270 UTC client backend[33894] pg_regress/plpgsql_domain CONTEXT:  PL/pgSQL function test_assign_nnint(integer,integer) line 4 at assignment
2024-12-27 05:16:38.270 UTC client backend[33894] pg_regress/plpgsql_domain STATEMENT:  SELECT * FROM test_assign_nnint(10, null);
2024-12-27 05:16:38.305 UTC client backend[33894] pg_regress/plpgsql_domain ERROR:  value for domain ordered_pair_domain violates check constraint "ordered_pair_domain_check"
2024-12-27 05:16:38.305 UTC client backend[33894] pg_regress/plpgsql_domain CONTEXT:  PL/pgSQL function test_argresult_array_domain_check_violation() while casting return value to function's return type
2024-12-27 05:16:38.305 UTC client backend[33894] pg_regress/plpgsql_domain STATEMENT:  SELECT * FROM test_argresult_array_domain_check_violation();
2024-12-27 05:16:38.307 UTC client backend[33894] pg_regress/plpgsql_domain ERROR:  value for domain ordered_pair_domain violates check constraint "ordered_pair_domain_check"
2024-12-27 05:16:38.307 UTC client backend[33894] pg_regress/plpgsql_domain CONTEXT:  PL/pgSQL function test_assign_ordered_pair_domain(integer,integer,integer) line 4 at assignment
2024-12-27 05:16:38.307 UTC client backend[33894] pg_regress/plpgsql_domain STATEMENT:  SELECT * FROM test_assign_ordered_pair_domain(1,2,0);
2024-12-27 05:16:38.307 UTC client backend[33894] pg_regress/plpgsql_domain ERROR:  value for domain ordered_pair_domain violates check constraint "ordered_pair_domain_check"
2024-12-27 05:16:38.307 UTC client backend[33894] pg_regress/plpgsql_domain CONTEXT:  PL/pgSQL function test_assign_ordered_pair_domain(integer,integer,integer) line 2 during statement block local variable initialization
2024-12-27 05:16:38.307 UTC client backend[33894] pg_regress/plpgsql_domain STATEMENT:  SELECT * FROM test_assign_ordered_pair_domain(2,1,3);
2024-12-27 05:16:38.315 UTC client backend[33894] pg_regress/plpgsql_domain ERROR:  value for domain uint2 violates check constraint "uint2_check"
2024-12-27 05:16:38.315 UTC client backend[33894] pg_regress/plpgsql_domain CONTEXT:  PL/pgSQL function test_build_uint2_array(smallint) while casting return value to function's return type
2024-12-27 05:16:38.315 UTC client backend[33894] pg_regress/plpgsql_domain STATEMENT:  select test_build_uint2_array(-1::int2);
2024-12-27 05:16:38.316 UTC client backend[33894] pg_regress/plpgsql_domain ERROR:  value for domain ordered_pair_domain violates check constraint "ordered_pair_domain_check"
2024-12-27 05:16:38.316 UTC client backend[33894] pg_regress/plpgsql_domain CONTEXT:  PL/pgSQL function test_argresult_domain_array(integer[]) line 3 at RETURN
2024-12-27 05:16:38.316 UTC client backend[33894] pg_regress/plpgsql_domain STATEMENT:  select test_argresult_domain_array(array[4,2]);
2024-12-27 05:16:38.316 UTC client backend[33894] pg_regress/plpgsql_domain ERROR:  value for domain ordered_pair_domain violates check constraint "ordered_pair_domain_check"
2024-12-27 05:16:38.316 UTC client backend[33894] pg_regress/plpgsql_domain STATEMENT:  select test_argresult_domain_array2(array[4,2]);
2024-12-27 05:16:38.347 UTC client backend[33894] pg_regress/plpgsql_domain ERROR:  domain nnint does not allow null values
2024-12-27 05:16:38.347 UTC client backend[33894] pg_regress/plpgsql_domain CONTEXT:  PL/pgSQL function test_result_nnint_container(integer,integer) line 3 at RETURN
2024-12-27 05:16:38.347 UTC client backend[33894] pg_regress/plpgsql_domain STATEMENT:  SELECT test_result_nnint_container(3, null);
2024-12-27 05:16:38.359 UTC client backend[33894] pg_regress/plpgsql_domain ERROR:  domain nnint does not allow null values
2024-12-27 05:16:38.359 UTC client backend[33894] pg_regress/plpgsql_domain CONTEXT:  PL/pgSQL function test_assign_nnint_container(integer,integer,integer) line 4 at assignment
2024-12-27 05:16:38.359 UTC client backend[33894] pg_regress/plpgsql_domain STATEMENT:  SELECT * FROM test_assign_nnint_container(1,2,null);
2024-12-27 05:16:38.359 UTC client backend[33894] pg_regress/plpgsql_domain ERROR:  domain nnint does not allow null values
2024-12-27 05:16:38.359 UTC client backend[33894] pg_regress/plpgsql_domain CONTEXT:  PL/pgSQL function test_assign_nnint_container(integer,integer,integer) line 2 during statement block local variable initialization
2024-12-27 05:16:38.359 UTC client backend[33894] pg_regress/plpgsql_domain STATEMENT:  SELECT * FROM test_assign_nnint_container(1,null,3);
2024-12-27 05:16:38.362 UTC client backend[33894] pg_regress/plpgsql_domain ERROR:  domain nnint does not allow null values
2024-12-27 05:16:38.362 UTC client backend[33894] pg_regress/plpgsql_domain CONTEXT:  PL/pgSQL function test_assign_nnint_container2(integer,integer,integer) line 4 at assignment
2024-12-27 05:16:38.362 UTC client backend[33894] pg_regress/plpgsql_domain STATEMENT:  SELECT * FROM test_assign_nnint_container2(1,2,null);
2024-12-27 05:16:38.370 UTC client backend[33894] pg_regress/plpgsql_domain ERROR:  value for domain ordered_named_pair violates check constraint "ordered_named_pair_check"
2024-12-27 05:16:38.370 UTC client backend[33894] pg_regress/plpgsql_domain STATEMENT:  SELECT read_ordered_named_pair(row(2, 1));
2024-12-27 05:16:38.373 UTC client backend[33894] pg_regress/plpgsql_domain ERROR:  value for domain ordered_named_pair violates check constraint "ordered_named_pair_check"
2024-12-27 05:16:38.373 UTC client backend[33894] pg_regress/plpgsql_domain CONTEXT:  PL/pgSQL function build_ordered_named_pair(integer,integer) while casting return value to function's return type
2024-12-27 05:16:38.373 UTC client backend[33894] pg_regress/plpgsql_domain STATEMENT:  SELECT build_ordered_named_pair(2,1);
2024-12-27 05:16:38.375 UTC client backend[33894] pg_regress/plpgsql_domain ERROR:  value for domain ordered_named_pair violates check constraint "ordered_named_pair_check"
2024-12-27 05:16:38.375 UTC client backend[33894] pg_regress/plpgsql_domain CONTEXT:  PL/pgSQL function test_assign_ordered_named_pair(integer,integer,integer) line 4 at assignment
2024-12-27 05:16:38.375 UTC client backend[33894] pg_regress/plpgsql_domain STATEMENT:  SELECT * FROM test_assign_ordered_named_pair(1,2,0);
2024-12-27 05:16:38.375 UTC client backend[33894] pg_regress/plpgsql_domain ERROR:  value for domain ordered_named_pair violates check constraint "ordered_named_pair_check"
2024-12-27 05:16:38.375 UTC client backend[33894] pg_regress/plpgsql_domain CONTEXT:  PL/pgSQL function test_assign_ordered_named_pair(integer,integer,integer) line 2 during statement block local variable initialization
2024-12-27 05:16:38.375 UTC client backend[33894] pg_regress/plpgsql_domain STATEMENT:  SELECT * FROM test_assign_ordered_named_pair(2,1,3);
2024-12-27 05:16:38.383 UTC client backend[33894] pg_regress/plpgsql_domain ERROR:  value for domain ordered_named_pair violates check constraint "ordered_named_pair_check"
2024-12-27 05:16:38.383 UTC client backend[33894] pg_regress/plpgsql_domain CONTEXT:  PL/pgSQL function build_ordered_named_pairs(integer,integer) while casting return value to function's return type
2024-12-27 05:16:38.383 UTC client backend[33894] pg_regress/plpgsql_domain STATEMENT:  SELECT build_ordered_named_pairs(2,1);
2024-12-27 05:16:38.387 UTC client backend[33894] pg_regress/plpgsql_domain ERROR:  value for domain ordered_named_pair violates check constraint "ordered_named_pair_check"
2024-12-27 05:16:38.387 UTC client backend[33894] pg_regress/plpgsql_domain CONTEXT:  PL/pgSQL function test_assign_ordered_named_pairs(integer,integer,integer) line 2 during statement block local variable initialization
2024-12-27 05:16:38.387 UTC client backend[33894] pg_regress/plpgsql_domain STATEMENT:  SELECT * FROM test_assign_ordered_named_pairs(2,1,3);
2024-12-27 05:16:38.529 UTC client backend[33927] pg_regress/plpgsql_misc ERROR:  variable "foo" does not exist
2024-12-27 05:16:38.529 UTC client backend[33927] pg_regress/plpgsql_misc CONTEXT:  compilation of PL/pgSQL function "inline_code_block" near line 1
2024-12-27 05:16:38.529 UTC client backend[33927] pg_regress/plpgsql_misc STATEMENT:  do $$ declare x foo%type; begin end $$;
2024-12-27 05:16:38.529 UTC client backend[33927] pg_regress/plpgsql_misc ERROR:  variable "notice" does not exist
2024-12-27 05:16:38.529 UTC client backend[33927] pg_regress/plpgsql_misc CONTEXT:  compilation of PL/pgSQL function "inline_code_block" near line 1
2024-12-27 05:16:38.529 UTC client backend[33927] pg_regress/plpgsql_misc STATEMENT:  do $$ declare x notice%type; begin end $$;
2024-12-27 05:16:38.529 UTC client backend[33927] pg_regress/plpgsql_misc ERROR:  relation "foo" does not exist
2024-12-27 05:16:38.529 UTC client backend[33927] pg_regress/plpgsql_misc CONTEXT:  compilation of PL/pgSQL function "inline_code_block" near line 1
2024-12-27 05:16:38.529 UTC client backend[33927] pg_regress/plpgsql_misc STATEMENT:  do $$ declare x foo.bar%type; begin end $$;
2024-12-27 05:16:38.529 UTC client backend[33927] pg_regress/plpgsql_misc ERROR:  schema "foo" does not exist
2024-12-27 05:16:38.529 UTC client backend[33927] pg_regress/plpgsql_misc CONTEXT:  compilation of PL/pgSQL function "inline_code_block" near line 1
2024-12-27 05:16:38.529 UTC client backend[33927] pg_regress/plpgsql_misc STATEMENT:  do $$ declare x foo.bar.baz%type; begin end $$;
2024-12-27 05:16:38.529 UTC client backend[33927] pg_regress/plpgsql_misc ERROR:  relation "public.foo" does not exist
2024-12-27 05:16:38.529 UTC client backend[33927] pg_regress/plpgsql_misc CONTEXT:  compilation of PL/pgSQL function "inline_code_block" near line 1
2024-12-27 05:16:38.529 UTC client backend[33927] pg_regress/plpgsql_misc STATEMENT:  do $$ declare x public.foo.bar%type; begin end $$;
2024-12-27 05:16:38.529 UTC client backend[33927] pg_regress/plpgsql_misc ERROR:  column "zed" of relation "misc_table" does not exist
2024-12-27 05:16:38.529 UTC client backend[33927] pg_regress/plpgsql_misc CONTEXT:  compilation of PL/pgSQL function "inline_code_block" near line 1
2024-12-27 05:16:38.529 UTC client backend[33927] pg_regress/plpgsql_misc STATEMENT:  do $$ declare x public.misc_table.zed%type; begin end $$;
2024-12-27 05:16:38.529 UTC client backend[33927] pg_regress/plpgsql_misc ERROR:  relation "foo" does not exist
2024-12-27 05:16:38.529 UTC client backend[33927] pg_regress/plpgsql_misc CONTEXT:  compilation of PL/pgSQL function "inline_code_block" near line 1
2024-12-27 05:16:38.529 UTC client backend[33927] pg_regress/plpgsql_misc STATEMENT:  do $$ declare x foo%rowtype; begin end $$;
2024-12-27 05:16:38.529 UTC client backend[33927] pg_regress/plpgsql_misc ERROR:  relation "notice" does not exist
2024-12-27 05:16:38.529 UTC client backend[33927] pg_regress/plpgsql_misc CONTEXT:  compilation of PL/pgSQL function "inline_code_block" near line 1
2024-12-27 05:16:38.529 UTC client backend[33927] pg_regress/plpgsql_misc STATEMENT:  do $$ declare x notice%rowtype; begin end $$;
2024-12-27 05:16:38.529 UTC client backend[33927] pg_regress/plpgsql_misc ERROR:  schema "foo" does not exist
2024-12-27 05:16:38.529 UTC client backend[33927] pg_regress/plpgsql_misc CONTEXT:  compilation of PL/pgSQL function "inline_code_block" near line 1
2024-12-27 05:16:38.529 UTC client backend[33927] pg_regress/plpgsql_misc STATEMENT:  do $$ declare x foo.bar%rowtype; begin end $$;
2024-12-27 05:16:38.529 UTC client backend[33927] pg_regress/plpgsql_misc ERROR:  cross-database references are not implemented: "foo.bar.baz"
2024-12-27 05:16:38.529 UTC client backend[33927] pg_regress/plpgsql_misc CONTEXT:  compilation of PL/pgSQL function "inline_code_block" near line 1
2024-12-27 05:16:38.529 UTC client backend[33927] pg_regress/plpgsql_misc STATEMENT:  do $$ declare x foo.bar.baz%rowtype; begin end $$;
2024-12-27 05:16:38.530 UTC client backend[33927] pg_regress/plpgsql_misc ERROR:  relation "public.foo" does not exist
2024-12-27 05:16:38.530 UTC client backend[33927] pg_regress/plpgsql_misc CONTEXT:  compilation of PL/pgSQL function "inline_code_block" near line 1
2024-12-27 05:16:38.530 UTC client backend[33927] pg_regress/plpgsql_misc STATEMENT:  do $$ declare x public.foo%rowtype; begin end $$;
2024-12-27 05:16:38.668 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  returned record type does not match expected record type
2024-12-27 05:16:38.668 UTC client backend[33935] pg_regress/plpgsql_record DETAIL:  Returned type integer does not match expected type bigint in column 1.
2024-12-27 05:16:38.668 UTC client backend[33935] pg_regress/plpgsql_record CONTEXT:  PL/pgSQL function retc(integer) while casting return value to function's return type
2024-12-27 05:16:38.668 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  select retc(42);
2024-12-27 05:16:38.671 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  returned record type does not match expected record type
2024-12-27 05:16:38.671 UTC client backend[33935] pg_regress/plpgsql_record DETAIL:  Number of returned columns (3) does not match expected column count (2).
2024-12-27 05:16:38.671 UTC client backend[33935] pg_regress/plpgsql_record CONTEXT:  PL/pgSQL function retc(integer) while casting return value to function's return type
2024-12-27 05:16:38.671 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  select retc(42);
2024-12-27 05:16:38.679 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  returned record type does not match expected record type
2024-12-27 05:16:38.679 UTC client backend[33935] pg_regress/plpgsql_record DETAIL:  Returned type integer does not match expected type bigint in column 1.
2024-12-27 05:16:38.679 UTC client backend[33935] pg_regress/plpgsql_record CONTEXT:  PL/pgSQL function retc(integer) while casting return value to function's return type
2024-12-27 05:16:38.679 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  select retc(42);
2024-12-27 05:16:38.679 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  returned record type does not match expected record type
2024-12-27 05:16:38.679 UTC client backend[33935] pg_regress/plpgsql_record DETAIL:  Number of returned columns (3) does not match expected column count (2).
2024-12-27 05:16:38.679 UTC client backend[33935] pg_regress/plpgsql_record CONTEXT:  PL/pgSQL function retc(integer) while casting return value to function's return type
2024-12-27 05:16:38.679 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  select retc(42);
2024-12-27 05:16:38.692 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  record "c" has no field "x"
2024-12-27 05:16:38.692 UTC client backend[33935] pg_regress/plpgsql_record CONTEXT:  PL/pgSQL assignment "c.x = 1"
	PL/pgSQL function inline_code_block line 1 at assignment
2024-12-27 05:16:38.692 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  do $$ declare c two_int8s; begin c.x = 1; end $$;
2024-12-27 05:16:38.692 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  record "c" has no field "x"
2024-12-27 05:16:38.692 UTC client backend[33935] pg_regress/plpgsql_record CONTEXT:  PL/pgSQL assignment "c.x = 1"
	PL/pgSQL function inline_code_block line 1 at assignment
2024-12-27 05:16:38.692 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  do $$ declare c nested_int8s; begin c.x = 1; end $$;
2024-12-27 05:16:38.693 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  record "c" has no field "x"
2024-12-27 05:16:38.693 UTC client backend[33935] pg_regress/plpgsql_record CONTEXT:  PL/pgSQL assignment "c.x.q1 = 1"
	PL/pgSQL function inline_code_block line 1 at assignment
2024-12-27 05:16:38.693 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  do $$ declare c nested_int8s; begin c.x.q1 = 1; end $$;
2024-12-27 05:16:38.693 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  cannot assign to field "x" of column "c" because there is no such column in data type two_int8s at character 1
2024-12-27 05:16:38.693 UTC client backend[33935] pg_regress/plpgsql_record QUERY:  c.c2.x = 1
2024-12-27 05:16:38.693 UTC client backend[33935] pg_regress/plpgsql_record CONTEXT:  PL/pgSQL function inline_code_block line 1 at assignment
2024-12-27 05:16:38.693 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  do $$ declare c nested_int8s; begin c.c2.x = 1; end $$;
2024-12-27 05:16:38.693 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  "d.c2.x" is not a known variable at character 37
2024-12-27 05:16:38.693 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  do $$ declare c nested_int8s; begin d.c2.x = 1; end $$;
2024-12-27 05:16:38.694 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  record "c" has no field "x"
2024-12-27 05:16:38.694 UTC client backend[33935] pg_regress/plpgsql_record CONTEXT:  PL/pgSQL assignment "b.c.x = 1"
	PL/pgSQL function inline_code_block line 1 at assignment
2024-12-27 05:16:38.694 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  do $$ <<b>> declare c two_int8s; begin b.c.x = 1; end $$;
2024-12-27 05:16:38.694 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  record "c" has no field "x"
2024-12-27 05:16:38.694 UTC client backend[33935] pg_regress/plpgsql_record CONTEXT:  PL/pgSQL assignment "b.c.x = 1"
	PL/pgSQL function inline_code_block line 1 at assignment
2024-12-27 05:16:38.694 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  do $$ <<b>> declare c nested_int8s; begin b.c.x = 1; end $$;
2024-12-27 05:16:38.695 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  record "c" has no field "x"
2024-12-27 05:16:38.695 UTC client backend[33935] pg_regress/plpgsql_record CONTEXT:  PL/pgSQL assignment "b.c.x.q1 = 1"
	PL/pgSQL function inline_code_block line 1 at assignment
2024-12-27 05:16:38.695 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  do $$ <<b>> declare c nested_int8s; begin b.c.x.q1 = 1; end $$;
2024-12-27 05:16:38.695 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  cannot assign to field "x" of column "b" because there is no such column in data type two_int8s at character 1
2024-12-27 05:16:38.695 UTC client backend[33935] pg_regress/plpgsql_record QUERY:  b.c.c2.x = 1
2024-12-27 05:16:38.695 UTC client backend[33935] pg_regress/plpgsql_record CONTEXT:  PL/pgSQL function inline_code_block line 1 at assignment
2024-12-27 05:16:38.695 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  do $$ <<b>> declare c nested_int8s; begin b.c.c2.x = 1; end $$;
2024-12-27 05:16:38.695 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  "b.d.c2" is not a known variable at character 43
2024-12-27 05:16:38.695 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  do $$ <<b>> declare c nested_int8s; begin b.d.c2.x = 1; end $$;
2024-12-27 05:16:38.728 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  record "r1" has no field "nosuchfield"
2024-12-27 05:16:38.728 UTC client backend[33935] pg_regress/plpgsql_record CONTEXT:  PL/pgSQL expression "r1.nosuchfield"
	PL/pgSQL function inline_code_block line 7 at RAISE
2024-12-27 05:16:38.728 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  do $$
	declare r1 two_int8s;
	begin
	  raise notice 'r1.q1 = %', r1.q1;
	  raise notice 'r1.q2 = %', r1.q2;
	  raise notice 'r1 = %', r1;
	  raise notice 'r1.nosuchfield = %', r1.nosuchfield;
	end$$;
2024-12-27 05:16:38.728 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  record "r1" is not assigned yet
2024-12-27 05:16:38.728 UTC client backend[33935] pg_regress/plpgsql_record DETAIL:  The tuple structure of a not-yet-assigned record is indeterminate.
2024-12-27 05:16:38.728 UTC client backend[33935] pg_regress/plpgsql_record CONTEXT:  PL/pgSQL expression "r1.f1"
	PL/pgSQL function inline_code_block line 5 at RAISE
2024-12-27 05:16:38.728 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  do $$
	declare r1 record;
	begin
	  raise notice 'r1 = %', r1;
	  raise notice 'r1.f1 = %', r1.f1;
	  raise notice 'r1.f2 = %', r1.f2;
	  raise notice 'r1 = %', r1;
	end$$;
2024-12-27 05:16:38.731 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  record "r1" has no field "nosuchfield"
2024-12-27 05:16:38.731 UTC client backend[33935] pg_regress/plpgsql_record CONTEXT:  PL/pgSQL expression "r1.nosuchfield"
	PL/pgSQL function inline_code_block line 9 at RAISE
2024-12-27 05:16:38.731 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  do $$
	declare r1 record;
	begin
	  raise notice 'r1 = %', r1;
	  r1 := row(1,2);
	  raise notice 'r1.f1 = %', r1.f1;
	  raise notice 'r1.f2 = %', r1.f2;
	  raise notice 'r1 = %', r1;
	  raise notice 'r1.nosuchfield = %', r1.nosuchfield;
	end$$;
2024-12-27 05:16:38.736 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  variable "r1" has pseudo-type record[]
2024-12-27 05:16:38.736 UTC client backend[33935] pg_regress/plpgsql_record CONTEXT:  compilation of PL/pgSQL function "inline_code_block" near line 2
2024-12-27 05:16:38.736 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  do $$
	declare r1 record[];
	begin
	end$$;
2024-12-27 05:16:38.737 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  variable "r2" has pseudo-type record[]
2024-12-27 05:16:38.737 UTC client backend[33935] pg_regress/plpgsql_record CONTEXT:  compilation of PL/pgSQL function "inline_code_block" near line 3
2024-12-27 05:16:38.737 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  do $$
	declare r1 record;
	        r2 r1%type[];
	begin
	end$$;
2024-12-27 05:16:38.753 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  returned record type does not match expected record type
2024-12-27 05:16:38.753 UTC client backend[33935] pg_regress/plpgsql_record DETAIL:  Number of returned columns (2) does not match expected column count (3).
2024-12-27 05:16:38.753 UTC client backend[33935] pg_regress/plpgsql_record CONTEXT:  PL/pgSQL function returnsrecord(integer) while casting return value to function's return type
2024-12-27 05:16:38.753 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  select * from returnsrecord(42) as r(x int, y int, z int);
2024-12-27 05:16:38.753 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  returned record type does not match expected record type
2024-12-27 05:16:38.753 UTC client backend[33935] pg_regress/plpgsql_record DETAIL:  Returned type integer does not match expected type bigint in column 2.
2024-12-27 05:16:38.753 UTC client backend[33935] pg_regress/plpgsql_record CONTEXT:  PL/pgSQL function returnsrecord(integer) while casting return value to function's return type
2024-12-27 05:16:38.753 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  select * from returnsrecord(42) as r(x int, y bigint);
2024-12-27 05:16:38.754 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  returned record type does not match expected record type
2024-12-27 05:16:38.754 UTC client backend[33935] pg_regress/plpgsql_record DETAIL:  Number of returned columns (2) does not match expected column count (3).
2024-12-27 05:16:38.754 UTC client backend[33935] pg_regress/plpgsql_record CONTEXT:  PL/pgSQL function returnsrecord(integer) while casting return value to function's return type
2024-12-27 05:16:38.754 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  select * from returnsrecord(42) as r(x int, y int, z int);
2024-12-27 05:16:38.754 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  returned record type does not match expected record type
2024-12-27 05:16:38.754 UTC client backend[33935] pg_regress/plpgsql_record DETAIL:  Returned type integer does not match expected type bigint in column 2.
2024-12-27 05:16:38.754 UTC client backend[33935] pg_regress/plpgsql_record CONTEXT:  PL/pgSQL function returnsrecord(integer) while casting return value to function's return type
2024-12-27 05:16:38.754 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  select * from returnsrecord(42) as r(x int, y bigint);
2024-12-27 05:16:38.758 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  returned record type does not match expected record type
2024-12-27 05:16:38.758 UTC client backend[33935] pg_regress/plpgsql_record DETAIL:  Number of returned columns (2) does not match expected column count (3).
2024-12-27 05:16:38.758 UTC client backend[33935] pg_regress/plpgsql_record CONTEXT:  PL/pgSQL function returnsrecord(integer) while casting return value to function's return type
2024-12-27 05:16:38.758 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  select * from returnsrecord(42) as r(x int, y int, z int);
2024-12-27 05:16:38.758 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  returned record type does not match expected record type
2024-12-27 05:16:38.758 UTC client backend[33935] pg_regress/plpgsql_record DETAIL:  Returned type integer does not match expected type bigint in column 2.
2024-12-27 05:16:38.758 UTC client backend[33935] pg_regress/plpgsql_record CONTEXT:  PL/pgSQL function returnsrecord(integer) while casting return value to function's return type
2024-12-27 05:16:38.758 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  select * from returnsrecord(42) as r(x int, y bigint);
2024-12-27 05:16:38.759 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  returned record type does not match expected record type
2024-12-27 05:16:38.759 UTC client backend[33935] pg_regress/plpgsql_record DETAIL:  Number of returned columns (2) does not match expected column count (3).
2024-12-27 05:16:38.759 UTC client backend[33935] pg_regress/plpgsql_record CONTEXT:  PL/pgSQL function returnsrecord(integer) while casting return value to function's return type
2024-12-27 05:16:38.759 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  select * from returnsrecord(42) as r(x int, y int, z int);
2024-12-27 05:16:38.759 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  returned record type does not match expected record type
2024-12-27 05:16:38.759 UTC client backend[33935] pg_regress/plpgsql_record DETAIL:  Returned type integer does not match expected type bigint in column 2.
2024-12-27 05:16:38.759 UTC client backend[33935] pg_regress/plpgsql_record CONTEXT:  PL/pgSQL function returnsrecord(integer) while casting return value to function's return type
2024-12-27 05:16:38.759 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  select * from returnsrecord(42) as r(x int, y bigint);
2024-12-27 05:16:38.763 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  function getf1(integer) does not exist at character 8
2024-12-27 05:16:38.763 UTC client backend[33935] pg_regress/plpgsql_record HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2024-12-27 05:16:38.763 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  select getf1(1);
2024-12-27 05:16:38.763 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  record "x" has no field "f1"
2024-12-27 05:16:38.763 UTC client backend[33935] pg_regress/plpgsql_record CONTEXT:  PL/pgSQL expression "x.f1"
	PL/pgSQL function getf1(record) line 1 at RETURN
2024-12-27 05:16:38.763 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  select getf1(row(1,2)::two_int8s);
2024-12-27 05:16:38.764 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  could not identify column "f2" in record data type at character 1
2024-12-27 05:16:38.764 UTC client backend[33935] pg_regress/plpgsql_record QUERY:  $1.f2
2024-12-27 05:16:38.764 UTC client backend[33935] pg_regress/plpgsql_record CONTEXT:  PL/pgSQL function getf2(record) line 1 at RETURN
2024-12-27 05:16:38.764 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  select getf2(row(1,2));
2024-12-27 05:16:38.786 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  record "r" is not assigned yet
2024-12-27 05:16:38.786 UTC client backend[33935] pg_regress/plpgsql_record DETAIL:  The tuple structure of a not-yet-assigned record is indeterminate.
2024-12-27 05:16:38.786 UTC client backend[33935] pg_regress/plpgsql_record CONTEXT:  PL/pgSQL function returnssetofholes() line 4 at RETURN NEXT
2024-12-27 05:16:38.786 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  select returnssetofholes();
2024-12-27 05:16:38.788 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  returned record type does not match expected record type
2024-12-27 05:16:38.788 UTC client backend[33935] pg_regress/plpgsql_record DETAIL:  Number of returned columns (3) does not match expected column count (2).
2024-12-27 05:16:38.788 UTC client backend[33935] pg_regress/plpgsql_record CONTEXT:  PL/pgSQL function returnssetofholes() line 3 at RETURN NEXT
2024-12-27 05:16:38.788 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  select returnssetofholes();
2024-12-27 05:16:38.803 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  record "r" has no field "f1"
2024-12-27 05:16:38.803 UTC client backend[33935] pg_regress/plpgsql_record CONTEXT:  PL/pgSQL function sillyaddone(integer) line 1 at assignment
2024-12-27 05:16:38.803 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  select sillyaddone(42);
2024-12-27 05:16:38.804 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  record "x" has no field "f3"
2024-12-27 05:16:38.804 UTC client backend[33935] pg_regress/plpgsql_record CONTEXT:  PL/pgSQL expression "x.f3"
	PL/pgSQL function getf3(mutable) line 1 at RETURN
2024-12-27 05:16:38.804 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  select getf3(null::mutable);
2024-12-27 05:16:38.816 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  record "x" has no field "f3"
2024-12-27 05:16:38.816 UTC client backend[33935] pg_regress/plpgsql_record CONTEXT:  PL/pgSQL function getf3(mutable) line 1 at RETURN
2024-12-27 05:16:38.816 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  select getf3(null::mutable);
2024-12-27 05:16:38.819 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  type "mutable2" does not exist at character 12
2024-12-27 05:16:38.819 UTC client backend[33935] pg_regress/plpgsql_record QUERY:   declare r mutable2; begin r.f1 := $1; return r.f1 + 2; end 
2024-12-27 05:16:38.819 UTC client backend[33935] pg_regress/plpgsql_record CONTEXT:  compilation of PL/pgSQL function "sillyaddtwo" near line 1
2024-12-27 05:16:38.819 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  select sillyaddtwo(42);
2024-12-27 05:16:38.842 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  type "mutable2" does not exist
2024-12-27 05:16:38.842 UTC client backend[33935] pg_regress/plpgsql_record CONTEXT:  PL/pgSQL function sillyaddtwo(integer) line 1 at assignment
2024-12-27 05:16:38.842 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  select sillyaddtwo(42);
2024-12-27 05:16:38.880 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  value for domain ordered_int8s violates check constraint "ordered_int8s_check"
2024-12-27 05:16:38.880 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  select read_ordered_int8s(row(2, 1));
2024-12-27 05:16:38.887 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  value for domain ordered_int8s violates check constraint "ordered_int8s_check"
2024-12-27 05:16:38.887 UTC client backend[33935] pg_regress/plpgsql_record CONTEXT:  PL/pgSQL function build_ordered_int8s(bigint,bigint) while casting return value to function's return type
2024-12-27 05:16:38.887 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  select build_ordered_int8s(2,1);
2024-12-27 05:16:38.891 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  value for domain ordered_int8s violates check constraint "ordered_int8s_check"
2024-12-27 05:16:38.891 UTC client backend[33935] pg_regress/plpgsql_record CONTEXT:  PL/pgSQL function build_ordered_int8s_2(bigint,bigint) while casting return value to function's return type
2024-12-27 05:16:38.891 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  select build_ordered_int8s_2(2,1);
2024-12-27 05:16:38.892 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  value for domain ordered_int8s violates check constraint "ordered_int8s_check"
2024-12-27 05:16:38.892 UTC client backend[33935] pg_regress/plpgsql_record CONTEXT:  PL/pgSQL function build_ordered_int8s_3(bigint,bigint) while casting return value to function's return type
2024-12-27 05:16:38.892 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  select build_ordered_int8s_3(2,1);
2024-12-27 05:16:38.894 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  value for domain ordered_int8s violates check constraint "ordered_int8s_check"
2024-12-27 05:16:38.894 UTC client backend[33935] pg_regress/plpgsql_record CONTEXT:  PL/pgSQL function build_ordered_int8s_4(bigint,bigint) line 2 at assignment
2024-12-27 05:16:38.894 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  select build_ordered_int8s_4(2,1);
2024-12-27 05:16:38.904 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  value for domain ordered_int8s violates check constraint "ordered_int8s_check"
2024-12-27 05:16:38.904 UTC client backend[33935] pg_regress/plpgsql_record CONTEXT:  PL/pgSQL function build_ordered_int8s_a(bigint,bigint) while casting return value to function's return type
2024-12-27 05:16:38.904 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  select build_ordered_int8s_a(2,1);
2024-12-27 05:16:38.904 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  value for domain ordered_int8s violates check constraint "ordered_int8s_check"
2024-12-27 05:16:38.904 UTC client backend[33935] pg_regress/plpgsql_record CONTEXT:  PL/pgSQL function inline_code_block line 7 at assignment
2024-12-27 05:16:38.904 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  do $$
	declare r ordered_int8s;
	begin
	  r.q1 := null;
	  r.q2 := 43;
	  r.q1 := 42;
	  r.q2 := 41;  -- fail
	end$$;
2024-12-27 05:16:38.907 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  value for domain ordered_int8s violates check constraint "ordered_int8s_check"
2024-12-27 05:16:38.907 UTC client backend[33935] pg_regress/plpgsql_record CONTEXT:  PL/pgSQL function inline_code_block line 7 at assignment
2024-12-27 05:16:38.907 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  do $$
	declare r ordered_int8s;
	begin
	  r := null;
	  r := row(null,null);
	  r := row(1,2);
	  r := row(2,1);  -- fail
	end$$;
2024-12-27 05:16:38.908 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  value for domain ordered_int8s violates check constraint "ordered_int8s_check"
2024-12-27 05:16:38.908 UTC client backend[33935] pg_regress/plpgsql_record CONTEXT:  PL/pgSQL function inline_code_block line 4 at FOR over SELECT rows
2024-12-27 05:16:38.908 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  do $$
	declare r ordered_int8s;
	begin
	  for r in values (1,2),(3,4),(6,5) loop
	    raise notice 'r = %', r;
	  end loop;
	end$$;
2024-12-27 05:16:39.029 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  value for domain ordered_texts violates check constraint "ordered_texts_check"
2024-12-27 05:16:39.029 UTC client backend[33935] pg_regress/plpgsql_record CONTEXT:  PL/pgSQL function inline_code_block line 4 at FOR over SELECT rows
2024-12-27 05:16:39.029 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  do $$
	declare d ordered_texts;
	begin
	  for d in select a, b from sometable loop
	    raise notice 'succeeded at "%"', d.f1;
	  end loop;
	end$$;
2024-12-27 05:16:39.032 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  value for domain ordered_texts violates check constraint "ordered_texts_check"
2024-12-27 05:16:39.032 UTC client backend[33935] pg_regress/plpgsql_record CONTEXT:  PL/pgSQL function inline_code_block line 6 at assignment
2024-12-27 05:16:39.032 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  do $$
	declare r record; d ordered_texts;
	begin
	  for r in select * from sometable loop
	    raise notice 'processing row %', r.id;
	    d := row(r.a, r.b);
	  end loop;
	end$$;
2024-12-27 05:16:39.040 UTC client backend[33935] pg_regress/plpgsql_record ERROR:  value for domain ordered_texts violates check constraint "ordered_texts_check"
2024-12-27 05:16:39.040 UTC client backend[33935] pg_regress/plpgsql_record CONTEXT:  PL/pgSQL function inline_code_block line 8 at assignment
2024-12-27 05:16:39.040 UTC client backend[33935] pg_regress/plpgsql_record STATEMENT:  do $$
	declare r record; d ordered_texts;
	begin
	  for r in select * from sometable loop
	    raise notice 'processing row %', r.id;
	    d := null;
	    d.f1 := r.a;
	    d.f2 := r.b;
	  end loop;
	end$$;
2024-12-27 05:16:39.248 UTC client backend[33976] pg_regress/plpgsql_simple ERROR:  division by zero
2024-12-27 05:16:39.248 UTC client backend[33976] pg_regress/plpgsql_simple CONTEXT:  SQL function "simplesql" during inlining
	SQL statement "select simplesql()"
	PL/pgSQL function simplecaller() line 4 at SQL statement
2024-12-27 05:16:39.248 UTC client backend[33976] pg_regress/plpgsql_simple STATEMENT:  select simplecaller();
2024-12-27 05:16:39.399 UTC client backend[33986] pg_regress/plpgsql_transaction ERROR:  invalid transaction termination
2024-12-27 05:16:39.399 UTC client backend[33986] pg_regress/plpgsql_transaction CONTEXT:  PL/pgSQL function transaction_test1(integer,text) line 6 at COMMIT
2024-12-27 05:16:39.399 UTC client backend[33986] pg_regress/plpgsql_transaction STATEMENT:  CALL transaction_test1(9, 'error');
2024-12-27 05:16:39.399 UTC client backend[33986] pg_regress/plpgsql_transaction ERROR:  invalid transaction termination
2024-12-27 05:16:39.399 UTC client backend[33986] pg_regress/plpgsql_transaction CONTEXT:  PL/pgSQL function inline_code_block line 1 at COMMIT
2024-12-27 05:16:39.399 UTC client backend[33986] pg_regress/plpgsql_transaction STATEMENT:  DO LANGUAGE plpgsql $$ BEGIN COMMIT; END $$;
2024-12-27 05:16:39.401 UTC client backend[33986] pg_regress/plpgsql_transaction ERROR:  invalid transaction termination
2024-12-27 05:16:39.401 UTC client backend[33986] pg_regress/plpgsql_transaction CONTEXT:  PL/pgSQL function transaction_test2() line 6 at COMMIT
2024-12-27 05:16:39.401 UTC client backend[33986] pg_regress/plpgsql_transaction STATEMENT:  SELECT transaction_test2();
2024-12-27 05:16:39.403 UTC client backend[33986] pg_regress/plpgsql_transaction ERROR:  invalid transaction termination
2024-12-27 05:16:39.403 UTC client backend[33986] pg_regress/plpgsql_transaction CONTEXT:  PL/pgSQL function transaction_test1(integer,text) line 6 at COMMIT
	SQL statement "CALL transaction_test1(9, 'error')"
	PL/pgSQL function transaction_test3() line 3 at CALL
2024-12-27 05:16:39.403 UTC client backend[33986] pg_regress/plpgsql_transaction STATEMENT:  SELECT transaction_test3();
2024-12-27 05:16:39.403 UTC client backend[33986] pg_regress/plpgsql_transaction ERROR:  invalid transaction termination
2024-12-27 05:16:39.403 UTC client backend[33986] pg_regress/plpgsql_transaction CONTEXT:  PL/pgSQL function inline_code_block line 1 at COMMIT
	SQL statement "DO LANGUAGE plpgsql $x$ BEGIN COMMIT; END $x$"
	PL/pgSQL function transaction_test4() line 3 at EXECUTE
2024-12-27 05:16:39.403 UTC client backend[33986] pg_regress/plpgsql_transaction STATEMENT:  SELECT transaction_test4();
2024-12-27 05:16:39.405 UTC client backend[33986] pg_regress/plpgsql_transaction ERROR:  invalid transaction termination
2024-12-27 05:16:39.405 UTC client backend[33986] pg_regress/plpgsql_transaction CONTEXT:  PL/pgSQL function transaction_test5() line 3 at COMMIT
2024-12-27 05:16:39.405 UTC client backend[33986] pg_regress/plpgsql_transaction STATEMENT:  CALL transaction_test5();
2024-12-27 05:16:39.405 UTC client backend[33986] pg_regress/plpgsql_transaction ERROR:  invalid transaction termination
2024-12-27 05:16:39.405 UTC client backend[33986] pg_regress/plpgsql_transaction CONTEXT:  PL/pgSQL function transaction_test5b() line 3 at COMMIT
2024-12-27 05:16:39.405 UTC client backend[33986] pg_regress/plpgsql_transaction STATEMENT:  CALL transaction_test5b();
2024-12-27 05:16:39.429 UTC client backend[33986] pg_regress/plpgsql_transaction ERROR:  invalid transaction termination
2024-12-27 05:16:39.429 UTC client backend[33986] pg_regress/plpgsql_transaction CONTEXT:  PL/pgSQL function transaction_test1(integer,text) line 6 at COMMIT
	SQL statement "CALL transaction_test1(10, $x$baz$x$)"
	PL/pgSQL function transaction_test8() line 3 at EXECUTE
2024-12-27 05:16:39.429 UTC client backend[33986] pg_regress/plpgsql_transaction STATEMENT:  CALL transaction_test8();
2024-12-27 05:16:39.451 UTC client backend[33986] pg_regress/plpgsql_transaction ERROR:  division by zero
2024-12-27 05:16:39.451 UTC client backend[33986] pg_regress/plpgsql_transaction CONTEXT:  SQL statement "INSERT INTO test1 (a) VALUES (12/(r.x-2))"
	PL/pgSQL function inline_code_block line 6 at SQL statement
2024-12-27 05:16:39.451 UTC client backend[33986] pg_regress/plpgsql_transaction STATEMENT:  DO LANGUAGE plpgsql $$
	DECLARE
	    r RECORD;
	BEGIN
	    FOR r IN SELECT * FROM test2 ORDER BY x LOOP
	        INSERT INTO test1 (a) VALUES (12/(r.x-2));
	        COMMIT;
	    END LOOP;
	END;
	$$;
2024-12-27 05:16:39.479 UTC client backend[33986] pg_regress/plpgsql_transaction ERROR:  cannot perform transaction commands inside a cursor loop that is not read-only
2024-12-27 05:16:39.479 UTC client backend[33986] pg_regress/plpgsql_transaction CONTEXT:  PL/pgSQL function inline_code_block line 7 at ROLLBACK
2024-12-27 05:16:39.479 UTC client backend[33986] pg_regress/plpgsql_transaction STATEMENT:  DO LANGUAGE plpgsql $$
	DECLARE
	    r RECORD;
	BEGIN
	    FOR r IN UPDATE test2 SET x = x * 2 RETURNING x LOOP
	        INSERT INTO test1 (a) VALUES (r.x);
	        ROLLBACK;
	    END LOOP;
	END;
	$$;
2024-12-27 05:16:39.513 UTC client backend[33986] pg_regress/plpgsql_transaction ERROR:  cannot commit while a subtransaction is active
2024-12-27 05:16:39.513 UTC client backend[33986] pg_regress/plpgsql_transaction CONTEXT:  PL/pgSQL function inline_code_block line 5 at COMMIT
2024-12-27 05:16:39.513 UTC client backend[33986] pg_regress/plpgsql_transaction STATEMENT:  DO LANGUAGE plpgsql $$
	BEGIN
	    BEGIN
	        INSERT INTO test1 (a) VALUES (1);
	        COMMIT;
	        INSERT INTO test1 (a) VALUES (1/0);
	        COMMIT;
	    EXCEPTION
	        WHEN division_by_zero THEN
	            RAISE NOTICE 'caught division_by_zero';
	    END;
	END;
	$$;
2024-12-27 05:16:39.515 UTC client backend[33986] pg_regress/plpgsql_transaction ERROR:  cannot roll back while a subtransaction is active
2024-12-27 05:16:39.515 UTC client backend[33986] pg_regress/plpgsql_transaction CONTEXT:  PL/pgSQL function inline_code_block line 5 at ROLLBACK
2024-12-27 05:16:39.515 UTC client backend[33986] pg_regress/plpgsql_transaction STATEMENT:  DO LANGUAGE plpgsql $$
	BEGIN
	    BEGIN
	        INSERT INTO test1 (a) VALUES (1);
	        ROLLBACK;
	        INSERT INTO test1 (a) VALUES (1/0);
	        ROLLBACK;
	    EXCEPTION
	        WHEN division_by_zero THEN
	            RAISE NOTICE 'caught division_by_zero';
	    END;
	END;
	$$;
2024-12-27 05:16:39.556 UTC client backend[33986] pg_regress/plpgsql_transaction ERROR:  duplicate key value violates unique constraint "test3_y_key"
2024-12-27 05:16:39.556 UTC client backend[33986] pg_regress/plpgsql_transaction DETAIL:  Key (y)=(1) already exists.
2024-12-27 05:16:39.556 UTC client backend[33986] pg_regress/plpgsql_transaction CONTEXT:  PL/pgSQL function inline_code_block line 9 at COMMIT
2024-12-27 05:16:39.556 UTC client backend[33986] pg_regress/plpgsql_transaction STATEMENT:  DO LANGUAGE plpgsql $$
	BEGIN
	    CREATE TABLE test3 (y int UNIQUE DEFERRABLE INITIALLY DEFERRED);
	    COMMIT;
	    INSERT INTO test3 (y) VALUES (1);
	    COMMIT;
	    INSERT INTO test3 (y) VALUES (1);
	    INSERT INTO test3 (y) VALUES (2);
	    COMMIT;
	    INSERT INTO test3 (y) VALUES (3);  -- won't get here
	END;
	$$;
2024-12-27 05:16:39.575 UTC client backend[33986] pg_regress/plpgsql_transaction ERROR:  division by zero
2024-12-27 05:16:39.575 UTC client backend[33986] pg_regress/plpgsql_transaction CONTEXT:  PL/pgSQL function cursor_fail_during_commit() line 6 at COMMIT
2024-12-27 05:16:39.575 UTC client backend[33986] pg_regress/plpgsql_transaction STATEMENT:  CALL cursor_fail_during_commit();
2024-12-27 05:16:39.592 UTC client backend[33986] pg_regress/plpgsql_transaction ERROR:  division by zero
2024-12-27 05:16:39.592 UTC client backend[33986] pg_regress/plpgsql_transaction CONTEXT:  PL/pgSQL function cursor_fail_during_rollback() line 6 at ROLLBACK
2024-12-27 05:16:39.592 UTC client backend[33986] pg_regress/plpgsql_transaction STATEMENT:  CALL cursor_fail_during_rollback();
2024-12-27 05:16:39.600 UTC client backend[33986] pg_regress/plpgsql_transaction ERROR:  SET TRANSACTION ISOLATION LEVEL must be called before any query
2024-12-27 05:16:39.600 UTC client backend[33986] pg_regress/plpgsql_transaction CONTEXT:  SQL statement "SET TRANSACTION ISOLATION LEVEL REPEATABLE READ"
	PL/pgSQL function inline_code_block line 3 at SQL statement
2024-12-27 05:16:39.600 UTC client backend[33986] pg_regress/plpgsql_transaction STATEMENT:  DO LANGUAGE plpgsql $$
	BEGIN
	    SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;
	END;
	$$;
2024-12-27 05:16:39.600 UTC client backend[33986] pg_regress/plpgsql_transaction ERROR:  unsupported transaction command in PL/pgSQL
2024-12-27 05:16:39.600 UTC client backend[33986] pg_regress/plpgsql_transaction CONTEXT:  PL/pgSQL function inline_code_block line 3 at SQL statement
2024-12-27 05:16:39.600 UTC client backend[33986] pg_regress/plpgsql_transaction STATEMENT:  DO LANGUAGE plpgsql $$
	BEGIN
	    SAVEPOINT foo;
	END;
	$$;
2024-12-27 05:16:39.600 UTC client backend[33986] pg_regress/plpgsql_transaction ERROR:  EXECUTE of transaction commands is not implemented
2024-12-27 05:16:39.600 UTC client backend[33986] pg_regress/plpgsql_transaction CONTEXT:  PL/pgSQL function inline_code_block line 3 at EXECUTE
2024-12-27 05:16:39.600 UTC client backend[33986] pg_regress/plpgsql_transaction STATEMENT:  DO LANGUAGE plpgsql $$
	BEGIN
	    EXECUTE 'COMMIT';
	END;
	$$;
2024-12-27 05:16:39.764 UTC client backend[34005] pg_regress/plpgsql_trap ERROR:  -100 is less than zero
2024-12-27 05:16:39.764 UTC client backend[34005] pg_regress/plpgsql_trap CONTEXT:  PL/pgSQL function trap_zero_divide(integer) line 12 at RAISE
2024-12-27 05:16:39.764 UTC client backend[34005] pg_regress/plpgsql_trap STATEMENT:  select trap_zero_divide(-100);
2024-12-27 05:16:40.811 UTC client backend[34005] pg_regress/plpgsql_trap LOG:  temporary file: path "base/pgsql_tmp/pgsql_tmp34005.0", size 32186368
2024-12-27 05:16:40.811 UTC client backend[34005] pg_regress/plpgsql_trap CONTEXT:  PL/pgSQL function trap_timeout() line 6 during exception cleanup
2024-12-27 05:16:40.811 UTC client backend[34005] pg_regress/plpgsql_trap STATEMENT:  select trap_timeout();
2024-12-27 05:16:40.811 UTC client backend[34005] pg_regress/plpgsql_trap ERROR:  end of function
2024-12-27 05:16:40.811 UTC client backend[34005] pg_regress/plpgsql_trap CONTEXT:  PL/pgSQL function trap_timeout() line 15 at RAISE
2024-12-27 05:16:40.811 UTC client backend[34005] pg_regress/plpgsql_trap STATEMENT:  select trap_timeout();
2024-12-27 05:16:40.817 UTC client backend[34005] pg_regress/plpgsql_trap ERROR:  insert or update on table "leaf" violates foreign key constraint "leaf_f1_fkey"
2024-12-27 05:16:40.817 UTC client backend[34005] pg_regress/plpgsql_trap DETAIL:  Key (f1)=(2) is not present in table "root".
2024-12-27 05:16:40.817 UTC client backend[34005] pg_regress/plpgsql_trap STATEMENT:  insert into leaf values(2);
2024-12-27 05:16:40.819 UTC client backend[34005] pg_regress/plpgsql_trap ERROR:  insert or update on table "leaf" violates foreign key constraint "leaf_f1_fkey"
2024-12-27 05:16:40.819 UTC client backend[34005] pg_regress/plpgsql_trap DETAIL:  Key (f1)=(2) is not present in table "root".
2024-12-27 05:16:40.819 UTC client backend[34005] pg_regress/plpgsql_trap STATEMENT:  set constraints all immediate;
2024-12-27 05:16:40.820 UTC client backend[34005] pg_regress/plpgsql_trap ERROR:  insert or update on table "leaf" violates foreign key constraint "leaf_f1_fkey"
2024-12-27 05:16:40.820 UTC client backend[34005] pg_regress/plpgsql_trap DETAIL:  Key (f1)=(2) is not present in table "root".
2024-12-27 05:16:40.820 UTC client backend[34005] pg_regress/plpgsql_trap STATEMENT:  commit;
2024-12-27 05:16:40.886 UTC client backend[34040] pg_regress/plpgsql_varprops ERROR:  variable "x" is declared CONSTANT at character 39
2024-12-27 05:16:40.886 UTC client backend[34040] pg_regress/plpgsql_varprops STATEMENT:  do $$
	declare x constant int;
	begin
	  x := 42;  -- fail
	end$$;
2024-12-27 05:16:40.886 UTC client backend[34040] pg_regress/plpgsql_varprops ERROR:  variable "x" is declared CONSTANT at character 50
2024-12-27 05:16:40.886 UTC client backend[34040] pg_regress/plpgsql_varprops STATEMENT:  do $$
	declare x constant int; y int;
	begin
	  for x, y in select 1, 2 loop  -- fail
	  end loop;
	end$$;
2024-12-27 05:16:40.887 UTC client backend[34040] pg_regress/plpgsql_varprops ERROR:  variable "x" is declared CONSTANT at character 41
2024-12-27 05:16:40.887 UTC client backend[34040] pg_regress/plpgsql_varprops STATEMENT:  do $$
	declare x constant int[];
	begin
	  x[1] := 42;  -- fail
	end$$;
2024-12-27 05:16:40.887 UTC client backend[34040] pg_regress/plpgsql_varprops ERROR:  syntax error at or near "[" at character 53
2024-12-27 05:16:40.887 UTC client backend[34040] pg_regress/plpgsql_varprops STATEMENT:  do $$
	declare x constant int[]; y int;
	begin
	  for x[1], y in select 1, 2 loop  -- fail (currently, unsupported syntax)
	  end loop;
	end$$;
2024-12-27 05:16:40.887 UTC client backend[34040] pg_regress/plpgsql_varprops ERROR:  variable "x" is declared CONSTANT at character 46
2024-12-27 05:16:40.887 UTC client backend[34040] pg_regress/plpgsql_varprops STATEMENT:  do $$
	declare x constant var_record;
	begin
	  x.f1 := 42;  -- fail
	end$$;
2024-12-27 05:16:40.887 UTC client backend[34040] pg_regress/plpgsql_varprops ERROR:  variable "x" is declared CONSTANT at character 57
2024-12-27 05:16:40.887 UTC client backend[34040] pg_regress/plpgsql_varprops STATEMENT:  do $$
	declare x constant var_record; y int;
	begin
	  for x.f1, y in select 1, 2 loop  -- fail
	  end loop;
	end$$;
2024-12-27 05:16:40.888 UTC client backend[34040] pg_regress/plpgsql_varprops ERROR:  division by zero
2024-12-27 05:16:40.888 UTC client backend[34040] pg_regress/plpgsql_varprops CONTEXT:  PL/pgSQL expression "1/0"
	PL/pgSQL function inline_code_block line 2 during statement block local variable initialization
2024-12-27 05:16:40.888 UTC client backend[34040] pg_regress/plpgsql_varprops STATEMENT:  do $$
	declare x int := 1/0;  -- fail
	begin
	  raise notice 'x = %', x;
	end$$;
2024-12-27 05:16:40.888 UTC client backend[34040] pg_regress/plpgsql_varprops ERROR:  variable "x" must have a default value, since it's declared NOT NULL at character 21
2024-12-27 05:16:40.888 UTC client backend[34040] pg_regress/plpgsql_varprops STATEMENT:  do $$
	declare x int not null;  -- fail
	begin
	  raise notice 'x = %', x;
	end$$;
2024-12-27 05:16:40.889 UTC client backend[34040] pg_regress/plpgsql_varprops ERROR:  null value cannot be assigned to variable "x" declared NOT NULL
2024-12-27 05:16:40.889 UTC client backend[34040] pg_regress/plpgsql_varprops CONTEXT:  PL/pgSQL function inline_code_block line 5 at assignment
2024-12-27 05:16:40.889 UTC client backend[34040] pg_regress/plpgsql_varprops STATEMENT:  do $$
	declare x int not null := 42;
	begin
	  raise notice 'x = %', x;
	  x := null;  -- fail
	end$$;
2024-12-27 05:16:40.889 UTC client backend[34040] pg_regress/plpgsql_varprops ERROR:  null value cannot be assigned to variable "x" declared NOT NULL
2024-12-27 05:16:40.889 UTC client backend[34040] pg_regress/plpgsql_varprops CONTEXT:  PL/pgSQL function inline_code_block line 2 during statement block local variable initialization
2024-12-27 05:16:40.889 UTC client backend[34040] pg_regress/plpgsql_varprops STATEMENT:  do $$
	declare x int not null := null;  -- fail
	begin
	  raise notice 'x = %', x;
	end$$;
2024-12-27 05:16:40.889 UTC client backend[34040] pg_regress/plpgsql_varprops ERROR:  variable "x" must have a default value, since it's declared NOT NULL at character 24
2024-12-27 05:16:40.889 UTC client backend[34040] pg_regress/plpgsql_varprops STATEMENT:  do $$
	declare x record not null;  -- fail
	begin
	  raise notice 'x = %', x;
	end$$;
2024-12-27 05:16:40.889 UTC client backend[34040] pg_regress/plpgsql_varprops ERROR:  null value cannot be assigned to variable "x" declared NOT NULL
2024-12-27 05:16:40.889 UTC client backend[34040] pg_regress/plpgsql_varprops CONTEXT:  PL/pgSQL function inline_code_block line 7 at assignment
2024-12-27 05:16:40.889 UTC client backend[34040] pg_regress/plpgsql_varprops STATEMENT:  do $$
	declare x record not null := row(42);
	begin
	  raise notice 'x = %', x;
	  x := row(null);  -- ok
	  raise notice 'x = %', x;
	  x := null;  -- fail
	end$$;
2024-12-27 05:16:40.889 UTC client backend[34040] pg_regress/plpgsql_varprops ERROR:  null value cannot be assigned to variable "x" declared NOT NULL
2024-12-27 05:16:40.889 UTC client backend[34040] pg_regress/plpgsql_varprops CONTEXT:  PL/pgSQL function inline_code_block line 2 during statement block local variable initialization
2024-12-27 05:16:40.889 UTC client backend[34040] pg_regress/plpgsql_varprops STATEMENT:  do $$
	declare x record not null := null;  -- fail
	begin
	  raise notice 'x = %', x;
	end$$;
2024-12-27 05:16:40.890 UTC client backend[34040] pg_regress/plpgsql_varprops ERROR:  variable "x" must have a default value, since it's declared NOT NULL at character 28
2024-12-27 05:16:40.890 UTC client backend[34040] pg_regress/plpgsql_varprops STATEMENT:  do $$
	declare x var_record not null;  -- fail
	begin
	  raise notice 'x = %', x;
	end$$;
2024-12-27 05:16:40.890 UTC client backend[34040] pg_regress/plpgsql_varprops ERROR:  null value cannot be assigned to variable "x" declared NOT NULL
2024-12-27 05:16:40.890 UTC client backend[34040] pg_regress/plpgsql_varprops CONTEXT:  PL/pgSQL function inline_code_block line 7 at assignment
2024-12-27 05:16:40.890 UTC client backend[34040] pg_regress/plpgsql_varprops STATEMENT:  do $$
	declare x var_record not null := row(41,42);
	begin
	  raise notice 'x = %', x;
	  x := row(null,null);  -- ok
	  raise notice 'x = %', x;
	  x := null;  -- fail
	end$$;
2024-12-27 05:16:40.890 UTC client backend[34040] pg_regress/plpgsql_varprops ERROR:  null value cannot be assigned to variable "x" declared NOT NULL
2024-12-27 05:16:40.890 UTC client backend[34040] pg_regress/plpgsql_varprops CONTEXT:  PL/pgSQL function inline_code_block line 2 during statement block local variable initialization
2024-12-27 05:16:40.890 UTC client backend[34040] pg_regress/plpgsql_varprops STATEMENT:  do $$
	declare x var_record not null := null;  -- fail
	begin
	  raise notice 'x = %', x;
	end$$;
2024-12-27 05:16:40.891 UTC client backend[34040] pg_regress/plpgsql_varprops ERROR:  domain int_nn does not allow null values
2024-12-27 05:16:40.891 UTC client backend[34040] pg_regress/plpgsql_varprops CONTEXT:  PL/pgSQL function inline_code_block line 2 during statement block local variable initialization
2024-12-27 05:16:40.891 UTC client backend[34040] pg_regress/plpgsql_varprops STATEMENT:  do $$
	declare x int_nn;  -- fail
	begin
	  raise notice 'x = %', x;
	end$$;
2024-12-27 05:16:40.891 UTC client backend[34040] pg_regress/plpgsql_varprops ERROR:  domain int_nn does not allow null values
2024-12-27 05:16:40.891 UTC client backend[34040] pg_regress/plpgsql_varprops CONTEXT:  PL/pgSQL function inline_code_block line 2 during statement block local variable initialization
2024-12-27 05:16:40.891 UTC client backend[34040] pg_regress/plpgsql_varprops STATEMENT:  do $$
	declare x int_nn := null;  -- fail
	begin
	  raise notice 'x = %', x;
	end$$;
2024-12-27 05:16:40.892 UTC client backend[34040] pg_regress/plpgsql_varprops ERROR:  domain int_nn does not allow null values
2024-12-27 05:16:40.892 UTC client backend[34040] pg_regress/plpgsql_varprops CONTEXT:  PL/pgSQL function inline_code_block line 5 at assignment
2024-12-27 05:16:40.892 UTC client backend[34040] pg_regress/plpgsql_varprops STATEMENT:  do $$
	declare x int_nn := 42;
	begin
	  raise notice 'x = %', x;
	  x := null;  -- fail
	end$$;
2024-12-27 05:16:40.892 UTC client backend[34040] pg_regress/plpgsql_varprops ERROR:  domain var_record_nn does not allow null values
2024-12-27 05:16:40.892 UTC client backend[34040] pg_regress/plpgsql_varprops CONTEXT:  PL/pgSQL function inline_code_block line 2 during statement block local variable initialization
2024-12-27 05:16:40.892 UTC client backend[34040] pg_regress/plpgsql_varprops STATEMENT:  do $$
	declare x var_record_nn;  -- fail
	begin
	  raise notice 'x = %', x;
	end$$;
2024-12-27 05:16:40.892 UTC client backend[34040] pg_regress/plpgsql_varprops ERROR:  domain var_record_nn does not allow null values
2024-12-27 05:16:40.892 UTC client backend[34040] pg_regress/plpgsql_varprops CONTEXT:  PL/pgSQL function inline_code_block line 2 during statement block local variable initialization
2024-12-27 05:16:40.892 UTC client backend[34040] pg_regress/plpgsql_varprops STATEMENT:  do $$
	declare x var_record_nn := null;  -- fail
	begin
	  raise notice 'x = %', x;
	end$$;
2024-12-27 05:16:40.892 UTC client backend[34040] pg_regress/plpgsql_varprops ERROR:  domain var_record_nn does not allow null values
2024-12-27 05:16:40.892 UTC client backend[34040] pg_regress/plpgsql_varprops CONTEXT:  PL/pgSQL function inline_code_block line 6 at assignment
2024-12-27 05:16:40.892 UTC client backend[34040] pg_regress/plpgsql_varprops STATEMENT:  do $$
	declare x var_record_nn := row(1,2);
	begin
	  raise notice 'x = %', x;
	  x := row(null,null);  -- ok
	  x := null;  -- fail
	end$$;
2024-12-27 05:16:40.892 UTC client backend[34040] pg_regress/plpgsql_varprops ERROR:  value for domain var_record_colnn violates check constraint "var_record_colnn_check"
2024-12-27 05:16:40.892 UTC client backend[34040] pg_regress/plpgsql_varprops CONTEXT:  PL/pgSQL function inline_code_block line 2 during statement block local variable initialization
2024-12-27 05:16:40.892 UTC client backend[34040] pg_regress/plpgsql_varprops STATEMENT:  do $$
	declare x var_record_colnn;  -- fail
	begin
	  raise notice 'x = %', x;
	end$$;
2024-12-27 05:16:40.893 UTC client backend[34040] pg_regress/plpgsql_varprops ERROR:  value for domain var_record_colnn violates check constraint "var_record_colnn_check"
2024-12-27 05:16:40.893 UTC client backend[34040] pg_regress/plpgsql_varprops CONTEXT:  PL/pgSQL function inline_code_block line 2 during statement block local variable initialization
2024-12-27 05:16:40.893 UTC client backend[34040] pg_regress/plpgsql_varprops STATEMENT:  do $$
	declare x var_record_colnn := null;  -- fail
	begin
	  raise notice 'x = %', x;
	end$$;
2024-12-27 05:16:40.893 UTC client backend[34040] pg_regress/plpgsql_varprops ERROR:  value for domain var_record_colnn violates check constraint "var_record_colnn_check"
2024-12-27 05:16:40.893 UTC client backend[34040] pg_regress/plpgsql_varprops CONTEXT:  PL/pgSQL function inline_code_block line 2 during statement block local variable initialization
2024-12-27 05:16:40.893 UTC client backend[34040] pg_regress/plpgsql_varprops STATEMENT:  do $$
	declare x var_record_colnn := row(1,null);  -- fail
	begin
	  raise notice 'x = %', x;
	end$$;
2024-12-27 05:16:40.893 UTC client backend[34040] pg_regress/plpgsql_varprops ERROR:  value for domain var_record_colnn violates check constraint "var_record_colnn_check"
2024-12-27 05:16:40.893 UTC client backend[34040] pg_regress/plpgsql_varprops CONTEXT:  PL/pgSQL function inline_code_block line 5 at assignment
2024-12-27 05:16:40.893 UTC client backend[34040] pg_regress/plpgsql_varprops STATEMENT:  do $$
	declare x var_record_colnn := row(1,2);
	begin
	  raise notice 'x = %', x;
	  x := null;  -- fail
	end$$;
2024-12-27 05:16:40.893 UTC client backend[34040] pg_regress/plpgsql_varprops ERROR:  value for domain var_record_colnn violates check constraint "var_record_colnn_check"
2024-12-27 05:16:40.893 UTC client backend[34040] pg_regress/plpgsql_varprops CONTEXT:  PL/pgSQL function inline_code_block line 5 at assignment
2024-12-27 05:16:40.893 UTC client backend[34040] pg_regress/plpgsql_varprops STATEMENT:  do $$
	declare x var_record_colnn := row(1,2);
	begin
	  raise notice 'x = %', x;
	  x := row(null,null);  -- fail
	end$$;
2024-12-27 05:16:40.908 UTC postmaster[33677] LOG:  received fast shutdown request
2024-12-27 05:16:40.909 UTC postmaster[33677] 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: 33677
postgres(ExceptionalCondition+0x56)[0x5567579e18b5]
postgres(+0xeced62)[0x5567575f7d62]
postgres(+0xecf2b8)[0x5567575f82b8]
postgres(+0xed017a)[0x5567575f917a]
postgres(PostmasterMain+0x13f0)[0x5567575fabd9]
postgres(main+0x28d)[0x55675742f061]
/lib/x86_64-linux-gnu/libc.so.6(+0x2724a)[0x7fed0404624a]
/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0x85)[0x7fed04046305]
postgres(_start+0x21)[0x556756fda141]