Re: Snapshot synchronization, again...

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Snapshot synchronization, again...
Дата
Msg-id 9087.1298332819@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Snapshot synchronization, again...  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: Snapshot synchronization, again...  (Alvaro Herrera <alvherre@commandprompt.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: validating foreign tables
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Snapshot synchronization, again...