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