Ottavio Campana wrote:
> What would you to in order to be sure that one function or a part of it
> is atomically executed?
would it be correct something like? or how would you write this?
create or replace function my_function () returs integer as
$$
declare
...
status boolean;
...
begin
...
loop
begin
set transaction isolation level serializable;
...
do_something();
...
status := true;
exception serialization_failure
status := false;
end;
if status then exit;
end loop;
...
return 0;
end
$$ language plpgsql
--
Non c'e' piu' forza nella normalita', c'e' solo monotonia.