From 28e858c0f951a5f86f43ba9b8922c64bba96d2e1 Mon Sep 17 00:00:00 2001 From: Alexander Korotkov Date: Sun, 25 Feb 2024 20:30:17 +0200 Subject: [PATCH] Improve documentation and GUC description for transaction_timeout Reported-by: Alexander Lakhin --- doc/src/sgml/config.sgml | 4 ++-- src/backend/utils/misc/guc_tables.c | 2 +- 2 files changed, 3 insertions(+), 3 deletions(-) diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index ff184003feb..36a2a5ce431 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -9167,7 +9167,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; Terminate any session that spans longer than the specified amount of - time in the transaction. The limit applies both to explicit transactions + time in a transaction. The limit applies both to explicit transactions (started with BEGIN) and to an implicitly started transaction corresponding to a single statement. If this value is specified without units, it is taken as milliseconds. @@ -9177,7 +9177,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; If transaction_timeout is shorter or equal to idle_in_transaction_session_timeout or statement_timeout - transaction_timeout will invalidate the longer timeout. + then the longer timeout is ignored. diff --git a/src/backend/utils/misc/guc_tables.c b/src/backend/utils/misc/guc_tables.c index 37be0669bba..527a2b27340 100644 --- a/src/backend/utils/misc/guc_tables.c +++ b/src/backend/utils/misc/guc_tables.c @@ -2589,7 +2589,7 @@ struct config_int ConfigureNamesInt[] = { {"transaction_timeout", PGC_USERSET, CLIENT_CONN_STATEMENT, - gettext_noop("Sets the maximum allowed time in a transaction with a session (not a prepared transaction)."), + gettext_noop("Sets the maximum allowed duration of any transaction within a session (not a prepared transaction)."), gettext_noop("A value of 0 turns off the timeout."), GUC_UNIT_MS }, -- 2.39.5