Re: SET transaction_timeout inside a transaction

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Quentin de Metz" <quentin(at)de(dot)me(dot)tz>
Cc: pgsql-novice(at)postgresql(dot)org, amborodin(at)acm(dot)org, aekorotkov(at)gmail(dot)com, japinli(at)hotmail(dot)com, zhjwpku(at)gmail(dot)com
Subject: Re: SET transaction_timeout inside a transaction
Date: 2025-09-19 20:21:00
Message-ID: 2164653.1758313260@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Quentin de Metz" <quentin(at)de(dot)me(dot)tz> writes:
> It appears that changing the transaction_timeout when inside a transaction does not work as expected.

The effective value is whatever it was at transaction start, because
that's when the transaction timeout time is determined.

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Bzzzz 2025-09-19 20:21:49 Re: SET transaction_timeout inside a transaction
Previous Message Quentin de Metz 2025-09-19 20:12:59 SET transaction_timeout inside a transaction