Re: time stops within transaction

Поиск
Список
Период
Сортировка
От Alex Pilosov
Тема Re: time stops within transaction
Дата
Msg-id Pine.BSO.4.10.10010182222560.22422-100000@spider.pilosoft.com
обсуждение исходный текст
Ответ на Re: time stops within transaction  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: time stops within transaction  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Wed, 18 Oct 2000, Tom Lane wrote:

> I think what you are advocating is recomputing now() at each statement
> boundary within a transaction, but that's not as simple as it looks
> either.  Consider statement boundaries in an SQL function --- the
> function is probably being called from some outer statement, so
> advancing now() within the function would violate the spec constraint
> with respect to the outer statement.
Postgres doesn't have an idea of what a 'top-level' statement is? I.E.
statement as submitted by a client (libpq)?

-alex



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

Предыдущее
От: "Mikheev, Vadim"
Дата:
Сообщение: RE: AW: AW: Backup, restore & pg_dump
Следующее
От: Tom Lane
Дата:
Сообщение: Re: time stops within transaction