From: | hstenger(at)adinet(dot)com(dot)uy |
---|---|
To: | Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: AW: Now PostgreSQL recovers from errors within trns |
Date: | 2000-08-11 02:00:40 |
Message-ID: | 39935E48.7410C100@adinet.com.uy |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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(at)ieee(dot)org
Montevideo, Uruguay. | hstenger(at)adinet(dot)com(dot)uy
----------------------+------------------------
Visit UYLUG Web Site: http://www.linux.org.uy
-----------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2000-08-11 02:02:13 | Re: Arrays and foreign keys |
Previous Message | Chris Bitmead | 2000-08-11 01:42:59 | Re: Arrays and foreign keys |