> You don't. All of a function takes place inside a transaction. If
> there is no explicit transaction already, an implicit one will have been
> started.
If it is true, then the following function why causes sometimes a "duplicate
row"' error?
begin
if exists(select session_data from session where session_id= $1 ) then
update session set session_data= $2, session_exp=now() + interval ''10
minutes'' where session_id= $1 ;
return 0;
else
insert into session(session_id, session_exp, session_data) values ($1 ,
now() + interval ''10 minutes'' , $2);
return 1;
end if;
end;
Maybe because of the current isolation level?
Thanks: MaFa
