Hi

When I tested some hypothesis I wrote buggy code. It was surprise how fast
I lost all free memory

do $$
begin
  for i in 1..3000000
  loop
    begin
      -- do some error
      if i then end if;
    exception when others then
      -- do nothing
    end;
  end loop;
end;
$$;

problem is somewhere in implicit casting inside IF statement. When I use
explicit casting -

  IF i::boolean THEN

then there is not memory leak.

Regards

Pavel

Reply via email to