On 11/14/17 17:40, legrand legrand wrote:
> will that kind of statement (that is permitted with Oracle but gives errors
> ora-1555 snapshot too old) be permitted ?
>
> begin
> for c in (select id from tab where cond='blabla')
> loop
> update tab set x=1 where id=c.id;
> commit;
> end loop;
> end;
Hmm, that currently results in
ERROR: cannot commit while a portal is pinned
You say this fails in Oracle too. Are we supposed to make this work
somehow?
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services