Re: Statement-level rollback

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>
Cc: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Statement-level rollback
Date: 2017-03-06 18:24:00
Message-ID: CA+TgmobcjrzFMt=FpT3sWobkpMR6O4tVGxdVPyCRr_hHtx0zgA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-jdbc

On Fri, Mar 3, 2017 at 2:15 AM, Tsunakawa, Takayuki
<tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com> wrote:
> From: pgsql-hackers-owner(at)postgresql(dot)org
>> [mailto:pgsql-hackers-owner(at)postgresql(dot)org] On Behalf Of Peter Eisentraut
>> On 2/28/17 02:39, Tsunakawa, Takayuki wrote:
>> > I'd like to propose statement-level rollback feature. To repeat myself,
>> this is requested for users to migrate from other DBMSs to PostgreSQL. They
>> expect that a failure of one SQL statement should not abort the entire
>> transaction and their apps (client programs and stored procedures) can
>> continue the transaction with a different SQL statement.
>>
>> Can you provide some references on how other systems provide this feature?
>
> Oracle doesn't.

Really?

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2017-03-06 18:34:49 pgsql: Remove objname/objargs split for referring to objects
Previous Message Robert Haas 2017-03-06 18:21:58 Re: Patch to implement pg_current_logfile() function

Browse pgsql-jdbc by date

  From Date Subject
Next Message Tsunakawa, Takayuki 2017-03-07 00:33:18 Re: Statement-level rollback
Previous Message Dave Cramer 2017-03-06 11:50:54 Re: Problem updating driver to 42.0.0