X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 7608CD1B54F
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Wed, 15 Oct 2003 15:27:44 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 68264-10
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Wed, 15 Oct 2003 12:27:13 -0300 (ADT)
Received: from sss.pgh.pa.us (unknown [192.204.191.242])
	by svr1.postgresql.org (Postfix) with ESMTP id 64CCAD1B547
	for <pgsql-admin@postgresql.org>; Wed, 15 Oct 2003 12:27:12 -0300 (ADT)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.12.10/8.12.10) with ESMTP id h9FFQrhn015775;
	Wed, 15 Oct 2003 11:26:53 -0400 (EDT)
To: Ang Chin Han <angch@bytecraft.com.my>
Cc: Oliver Elphick <olly@lfix.co.uk>,
	=?ISO-8859-15?Q?Szab=F3_P=E9ter?= <matyee@westel900.net>,
	pgsql-admin@postgresql.org
Subject: Re: Lock! 
In-reply-to: <3F8CCC7F.6@bytecraft.com.my> 
References: <004c01c39175$0f0b3620$2702a8c0@WorkGroup>
	<1066148873.5581.67.camel@linda.lfix.co.uk>
	<3F8CCC7F.6@bytecraft.com.my>
Comments: In-reply-to Ang Chin Han <angch@bytecraft.com.my>
	message dated "Wed, 15 Oct 2003 12:26:39 +0800"
Date: Wed, 15 Oct 2003 11:26:52 -0400
Message-ID: <15774.1066231612@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200310/155
X-Sequence-Number: 10716

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