Re: Autocommit off - commits/rollbacks - Mailing list pgsql-general

From Jerry Sievers
Subject Re: Autocommit off - commits/rollbacks
Date
Msg-id 871v1qs82x.fsf@comcast.net
Whole thread Raw
In response to Re: Autocommit off - commits/rollbacks  (Craig Ringer <craig@postnewspapers.com.au>)
Responses Re: Autocommit off - commits/rollbacks  (tushar nehete <tpnehete@gmail.com>)
List pgsql-general
Craig Ringer <craig@postnewspapers.com.au> writes:

> On 03/14/2011 10:55 PM, Vogt, Michael wrote:
>
>> Hey all
>>
>> I have a question, using the autocommit off option in postgres.
>>
>> As starting position I use a table called xxx.configuration using a
>> unique id constraint.
>>
>> Why does postgres rollback the whole transaction after an error?
>
> It's a PostgreSQL limitation (or, arguably, optimization). When a

Well, any transactional RDBMS whatsoever should behave that way.  Hardly
a PostgreSQL exclusive feature :-)

--
Jerry Sievers
e: gsievers19@comcast.net
p: 305.321.1144

pgsql-general by date:

Previous
From: Jerry Sievers
Date:
Subject: Re: What could keep a connection / query alive?
Next
From: tushar nehete
Date:
Subject: Re: Autocommit off - commits/rollbacks