Обсуждение: AW: AW: AW: [HACKERS] 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. 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
Hi, Does anyone know how to teach netscape navigators mail client to recognize additional (national) forms of Re: I often miss Andreases answers as they are neither threaded nor sorted together with others in in my mailreader. ;( It does recognize Re: and ignores it when sorting -------------- Hannu
> -----Original Message----- > From: owner-pgsql-hackers@postgreSQL.org > [mailto:owner-pgsql-hackers@postgreSQL.org]On Behalf Of Zeugswetter > > > > 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. > Hmm,what do you want now ? Note that (f)sync is irrelevant at all. Partial rollback is the problem of only the backend to be rollbacked except locking. Vadim has already planned savepoints functionality instead of nested tx. I have never heard objections to the proposal. I could see little difference between the implementation of rollback to arbitrary savepoints and the implemention of rollback only to the savepoint implicitly placed immediately before current statement. Do you want another hack ? Regards. Hiroshi Inoue Inoue@tpf.co.jp
Hannu Krosing <hannu@tm.ee> writes: > Does anyone know how to teach netscape navigators mail client to > recognize additional (national) forms of Re: The right solution is for people who use Microsoft Outlook to upgrade to the latest version, where Microsoft (incredible as it sounds) has fixed this bug. Outlook now generates the correct "Re: " prefix. -tih -- Popularity is the hallmark of mediocrity. --Niles Crane, "Frasier"