Horton

Re: SET transaction_timeout inside a transaction

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Quentin de Metz" <quentin@de.me.tz>
Cc: pgsql-novice@postgresql.org, amborodin@acm.org, aekorotkov@gmail.com, japinli@hotmail.com, zhjwpku@gmail.com
Date: 2025-09-19T20:21:00Z
Lists: pgsql-novice 
"Quentin de Metz" <quentin@de.me.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