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 по дате отправления: