Re: Resetting the lock_timeout value for a transaction

[Tom Lane <tgl@xxxxxxxxxxxxx>]

Marcelo Fernandes <marcefern7@xxxxxxxxx> 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