public inbox for [email protected]
help / color / mirror / Atom feedFrom: David G. Johnston <[email protected]>
To: Quentin de Metz <[email protected]>
Cc: [email protected] <[email protected]>
Cc: [email protected] <[email protected]>
Cc: [email protected] <[email protected]>
Cc: [email protected] <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: SET transaction_timeout inside a transaction
Date: Fri, 19 Sep 2025 13:24:18 -0700
Message-ID: <CAKFQuwb_0kbQ=nSHE3QXWiemT_eJzoufMdh+9KttXQ8Vbpxq2g@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
On Friday, September 19, 2025, Quentin de Metz <[email protected]> wrote:
>
>
> It appears that changing the transaction_timeout when inside a transaction
> does not work as expected.
>
> Running the following script on master:
>
> SET transaction_timeout = '1s';
> BEGIN;
> SET transaction_timeout = '3s';
> SELECT pg_sleep(2);
It’s seems perfectly reasonable that as soon as a transaction begins it
sets up a timer using the then-current value of transaction_timeout. And
that changing the variable doesn’t affect any already established timers.
David J.
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: SET transaction_timeout inside a transaction
In-Reply-To: <CAKFQuwb_0kbQ=nSHE3QXWiemT_eJzoufMdh+9KttXQ8Vbpxq2g@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox