Re: Exposing the Xact commit order to the user - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Exposing the Xact commit order to the user
Date
Msg-id 15632.1274750465@sss.pgh.pa.us
Whole thread Raw
In response to Re: Exposing the Xact commit order to the user  (Florian Pflug <fgp@phlo.org>)
Responses Re: Exposing the Xact commit order to the user
List pgsql-hackers
Florian Pflug <fgp@phlo.org> writes:
> The subtle point here is whether you consider the view from the "outside" (in the sense of what a read-only
transactionstarted at an arbitrary time can or cannot observe), or from the "inside" (what updating transactions can
observeand might base their updates on).
 

> The former case is completely determined by the commit ordering of the transactions, while the latter is not -
otherwiseserializability wouldn't be such a hard problem.
 

BTW, doesn't all this logic fall in a heap as soon as you consider
read-committed transactions?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: ExecutorCheckPerms() hook
Next
From: Stephen Frost
Date:
Subject: Re: ExecutorCheckPerms() hook