Marcelo Fernandes <marcefe...@gmail.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
