Re: Autocommit off - commits/rollbacks

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