AW: AW: AW: [HACKERS] TRANSACTIONS

From: Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at>
To: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "'hackers'" <pgsql-hackers(at)postgreSQL(dot)org>
Subject: AW: AW: AW: [HACKERS] TRANSACTIONS
Date: 2000-02-24 16:53:54
Message-ID: 219F68D65015D011A8E000006F8590C604AF7CFA@sdexcsrv1.f000.d0188.sd.spardat.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> > 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.

Yes, the only difference seems to be, that the changes need not
be sync'd to disk, and you only need one level of nesting as long
as the user is not presented the ability to use nested tx.

Andreas

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2000-02-24 17:03:00 Re: [HACKERS] Re: [BUGS] First experiences with Postgresql 7.0
Previous Message Don Baccus 2000-02-24 16:51:46 Re: AW: AW: [HACKERS] TRANSACTIONS