Re: procedures and transactions

> On Feb 20, 2019, at 10:07 AM, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> wrote:
>
> You can run SET TRANSACTION ISOLATION LEVEL in a procedure.

I tried that before but I get this error:

create or replace procedure t_test(n integer)
as $$
begin
set transaction isolation level serializable;
raise notice 'current isolation level: %', (select current_setting('transaction_isolation'));
raise notice 'current txid: %', (select txid_current());
end;
$$ language plpgsql;

mydb=# call t_test(1);
ERROR: SET TRANSACTION ISOLATION LEVEL must be called before any query
CONTEXT: SQL statement "SET transaction isolation level serializable"