Re: Snapshot synchronization, again... - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Snapshot synchronization, again...
Date
Msg-id 9087.1298332819@sss.pgh.pa.us
Whole thread Raw
In response to Re: Snapshot synchronization, again...  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Snapshot synchronization, again...  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Actually this seems rather difficult to do, because in order to invoke
> the function that imports the snapshot, you have to call SELECT, which
> acquires a snapshot beforehand.  So when we actually import the
> passed-in snapshot, there's already a snapshot set.  This is odious but 
> I don't see a way around that -- other than adding special grammar
> support which seems overkill.

No, I don't think it is.  The alternative is semantics that are
at least exceedingly ugly, and very possibly flat-out broken.
To take just one point, you have no way at all of preventing the
transaction from having done something else using its original
snapshot.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: validating foreign tables
Next
From: Alvaro Herrera
Date:
Subject: Re: Snapshot synchronization, again...