Re: clock_timestamp() and transaction_timestamp() function

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: clock_timestamp() and transaction_timestamp() function
Дата
Msg-id 200312011553.hB1FrWv18540@candle.pha.pa.us
обсуждение исходный текст
Ответ на clock_timestamp() and transaction_timestamp() function  ("Wang Mike" <itlist@msn.com>)
Список pgsql-patches
Tom Lane wrote:
> Peter Eisentraut <peter_e@gmx.net> writes:
> > Tom Lane writes:
> >> This is a nonstarter, as is the previous proposal to have a single
> >> function with an explicit parameter that selects the behavior.  The
> >> reason is that any such function would have to be treated as completely
> >> non-optimizable.
>
> > Why?  We would just need to ensure that the mode cannot be changed at
> > critical times.
>
> "critical time" being anywhere within a session, I guess?  Either that
> or keep track of whether any cached plans depend on the stability
> assumption.

Ewe, that isn't going to work --- making the value unchangable during the
session.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: clock_timestamp() and transaction_timestamp() function
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: clock_timestamp() and transaction_timestamp() function