Re: synchronized snapshots

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: synchronized snapshots
Дата
Msg-id 1314211122.17771.3.camel@vanquo.pezone.net
обсуждение исходный текст
Ответ на Re: synchronized snapshots  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
On lör, 2011-08-20 at 09:56 -0400, Bruce Momjian wrote:
> Peter Eisentraut wrote:
> > On tis, 2011-08-16 at 20:35 -0400, Tom Lane wrote:
> > > In fact, now that I think about it, setting the transaction snapshot
> > > from a utility statement would be functionally useful because then you
> > > could take locks beforehand.
> > 
> > Another issue is that in some client interfaces, BEGIN and COMMIT are
> > hidden behind API calls, which cannot easily be changed or equipped with
> > new parameters.  So in order to have this functionality available
> > through those interfaces, we'd need a separately callable command.
> 
> How do they set a transaction to SERIALIZABLE?  Seem the same syntax
> should be used here.

The API typically has parameters to set the isolation level, since
that's a standardized property.




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: Should I implement DROP INDEX CONCURRENTLY?
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: "make -j4 world" falls over