Re: Lock!

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ang Chin Han <angch(at)bytecraft(dot)com(dot)my>
Cc: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>, Szabó Péter <matyee(at)westel900(dot)net>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Lock!
Date: 2003-10-15 15:26:52
Message-ID: 15774.1066231612@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Ang Chin Han <angch(at)bytecraft(dot)com(dot)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

In response to

  • Re: Lock! at 2003-10-15 04:26:39 from Ang Chin Han

Browse pgsql-admin by date

  From Date Subject
Next Message Naomi Walker 2003-10-15 16:24:47 7.3.2 to 7.3.4 upgrade
Previous Message Oliver Elphick 2003-10-15 14:40:20 Re: working with users