Marcelo Fernandes 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 bothe
Hi folks,
I have been using:
-- Setting the SESSION lock timeout to 10 seconds
SET lock_timeout = '10s';
-- Setting the TRANSACTION lock timeout to 20 seconds
BEGIN;
SET LOCAL lock_timeout = '20s';
COMMIT;
However, I have been caught by the behaviour of "RESET lock_timeout;" when
in
