Zeugswetter Andreas SB wrote:
> > Ok, maybe I exagerated, but kind of solves my problem.
> > GeneXus, my CASE tool,
> > will send begin/commit pairs, so I must 'recover'
> > automatically. I aimed
> > DB2-like behaviour, which I was told, aborts on errors within
> > transactions, but
> > remains in a runnable state. Don't you consider it valueable
> > whatsoever?
>
> DB/2 only aborts the one single statement inside this transaction.
> What you did will rollback everything since the last begin work,
> and thus is rather dangerous.
Ok, I understand. About this, when PostgreSQL has nested transactions, is it
already planned that every single statement runs within its own transaction, so
that if it goes bad, it doesn't abort the sorounding transaction?
Does anybody know where I can find more info on Write Ahead Log, i.e. when it
will be ready, and what its features will be?
Thanks.
Regards,
Haroldo.
--
----------------------+------------------------Haroldo Stenger | hstenger@ieee.orgMontevideo, Uruguay. |
hstenger@adinet.com.uy
----------------------+------------------------Visit UYLUG Web Site: http://www.linux.org.uy
-----------------------------------------------