Postgres Pro
Downloads
Home   >   mailing lists

Re: Resetting the lock_timeout value for a transaction - Mailing list pgsql-general

From Tom Lane
Subject Re: Resetting the lock_timeout value for a transaction
Date
Msg-id 579887.1745797459@sss.pgh.pa.us
Whole thread Raw
In response to Resetting the lock_timeout value for a transaction  (Marcelo Fernandes <marcefern7@gmail.com>)
List pgsql-general
Tree view 
Marcelo Fernandes <marcefern7@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

pgsql-general by date:

Previous
From: Marcelo Fernandes
Date:
Subject: Resetting the lock_timeout value for a transaction
Next
From: Tim Starling
Date:
Subject: Upsert error "column reference is ambiguous"