Re: Changing behavior of BEGIN...sleep...do something...COMMIT

Поиск
Список
Период
Сортировка
От Jon Jensen
Тема Re: Changing behavior of BEGIN...sleep...do something...COMMIT
Дата
Msg-id Pine.LNX.4.50.0303290452550.3394-100000@louche.swelter.net
обсуждение исходный текст
Ответ на Changing behavior of BEGIN...sleep...do something...COMMIT  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Fri, 28 Mar 2003, Tom Lane wrote:

> It seems to me that it'd be fairly easy to make BEGIN cause only
> a local state change in the backend; the actual transaction need not
> start until the first subsequent command is received.
[snip]
> In a very real sense, the transaction snapshot defines "when the
> transaction starts" --- so shouldn't now() agree?
> 
> If we did both of these things, then the negatives of doing an early
> BEGIN would pretty much vanish, and we'd not need to complain that these
> client libraries are broken.
> 
> Comments?

Both ideas sound like a win to me.

Jon



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Changing behavior of BEGIN...sleep...do something...COMMIT
Следующее
От: "Key88 SF"
Дата:
Сообщение: extract(timezone_hour) problem