Re: Resetting the lock_timeout value for a transaction

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Marcelo Fernandes <marcefern7(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Resetting the lock_timeout value for a transaction
Date: 2025-04-27 23:44:19
Message-ID: 579887.1745797459@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Marcelo Fernandes <marcefern7(at)gmail(dot)com> writes:
> I would have expected that the "RESET lock_timeout;" inside a transaction would
> only reset the value of lock_timeout for that specific transaction. Or else,
> there would be an equivalent "RESET LOCAL lock_timeout;" to be used for that.

We don't seem to have bothered with that exact syntax, but you
could spell it like

SET LOCAL lock_timeout TO DEFAULT;

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tim Starling 2025-04-28 04:55:58 Upsert error "column reference is ambiguous"
Previous Message Marcelo Fernandes 2025-04-27 23:28:41 Resetting the lock_timeout value for a transaction