Re: please define 'statement' in the glossary

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: please define 'statement' in the glossary
Дата
Msg-id 690858.1752509326@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: please define 'statement' in the glossary  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: please define 'statement' in the glossary
Список pgsql-docs
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> Cannot readily test this presently but I wonder what the following produces:

> psql -c "begin; select statement_timestamp(), transaction_timestamp();
> select statement_timestamp(), transaction_timestamp(); commit; begin;
> select statement_timestamp(), transaction_timestamp(); commit;"

> Transaction timestamp should progress while statement timestamp should not,
> right?

AFAICT neither one progresses.  I think the reason is that (1)
statement timestamp is set by arrival of the command message
and (2) transaction timestamp is set by copying statement timestamp
at the moment of beginning a transaction.

            regards, tom lane



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