Re: Lock! - Mailing list pgsql-admin

From Tom Lane
Subject Re: Lock!
Date
Msg-id 15774.1066231612@sss.pgh.pa.us
Whole thread Raw
In response to Re: Lock!  (Ang Chin Han <angch@bytecraft.com.my>)
List pgsql-admin
Ang Chin Han <angch@bytecraft.com.my> writes:
> Just remember to reset STATEMENT_TIMEOUT to zero or your default before
> any slow queries in that transaction.

Also, you can use "SET LOCAL ..." to constrain the effects of the SET
command; this is probably safer than trying to remember to reset the
variable when you're done.

            regards, tom lane

pgsql-admin by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: working with users
Next
From: Naomi Walker
Date:
Subject: 7.3.2 to 7.3.4 upgrade