do $$begin

-- Provoke error in worker. The original message CONTEXT contains a worker

-- PID that must be hidden in the test output. PL/pgSQL conveniently

-- substitutes its own CONTEXT.

select stringu1::int2 from tenk1 where unique1 = 1;

-- PID that must be hidden in the test output.

perform stringu1::int2 from tenk1 where unique1 = 1;

exception

when others then

raise 'SQLERRM: %', sqlerrm;

end$$;

ERROR: invalid input syntax for integer: "BAAAAA"

CONTEXT: SQL statement "select stringu1::int2 from tenk1 where unique1 = 1"

PL/pgSQL function inline_code_block line 5 at SQL statement

ERROR: SQLERRM: invalid input syntax for integer: "BAAAAA"

CONTEXT: PL/pgSQL function inline_code_block line 7 at RAISE

rollback;

do $$begin

select stringu1::int2from tenk1where unique1=1;

perform stringu1::int2from tenk1where unique1=1;

exception

when others then

raise'SQLERRM: %', sqlerrm;

end$$;

rollback;