Re: AW: AW: [HACKERS] TRANSACTIONS - Mailing list pgsql-hackers

From Tom Lane
Subject Re: AW: AW: [HACKERS] TRANSACTIONS
Date
Msg-id 22110.951410398@sss.pgh.pa.us
Whole thread Raw
In response to AW: AW: [HACKERS] TRANSACTIONS  (Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>)
List pgsql-hackers
Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at> writes:
>> I find this hard to believe, and even harder to believe that it's
>> mandated by the standard.  What you're essentially claiming is that
>> everyone but us has nested transactions

> They don't necessarily have nested tx, although some have.
> All they provide is atomicity of single statements.

If it looks like a duck, walks like a duck, and quacks like a duck,
it's a duck no matter what it's called.  How would you provide atomicity
of a single statement without a transaction-equivalent implementation?
That statement might be affecting many tuples in several different
tables.  It's not noticeably easier to roll back one statement than
a whole sequence of them.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Minor problems reloading dump in 7.0beta1
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Re: [BUGS] First experiences with Postgresql 7.0