Re: start of transaction (was: Re: [PERFORM] Help with

Поиск
Список
Период
Сортировка
От Hannu Krosing
Тема Re: start of transaction (was: Re: [PERFORM] Help with
Дата
Msg-id 1069064346.20092.27.camel@fuji.krosing.net
обсуждение исходный текст
Ответ на Re: start of transaction (was: Re: [PERFORM] Help with count(*))  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: start of transaction (was: Re: [PERFORM] Help with count(*))
Список pgsql-hackers
Bruce Momjian kirjutas E, 17.11.2003 kell 02:31:

> Defining now() as the first call seems pretty arbitrary to me.  I can't
> think of any time-based interface that has that API.  And what if a
> trigger called now() in an earlier query and you didn't even know about
> it.

That would be OK. The whole point of that previous discussion was to
have now() that returns the same value over the span of the whole
transaction.

It would be even better to have now() that returns the time current
transaction is COMMITted as this is the time other backend become aware
of it ;)

-----------
Hannu



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

Предыдущее
От: Hannu Krosing
Дата:
Сообщение: Re: start of transaction (was: Re: [PERFORM] Help with
Следующее
От: "Zeugswetter Andreas SB SD"
Дата:
Сообщение: Re: Background writer process