Date: Wed, 28 Jan 2004 12:47:22 +0200
From: Stef <svb@ucs.co.za>
To: pg-perform <pgsql-performance@postgresql.org>
Cc: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Re: postgres timeout. [SOLVED]
Message-Id: <20040128124722.78fe5dc0.svb@ucs.co.za>
In-Reply-To: <20040128121217.2e4aceef.svb@ucs.co.za>
References: <20040128121109.02f554e6.svb@ucs.co.za>
	<20040128121217.2e4aceef.svb@ucs.co.za>
User-Agent: sillypheed-claws (anti-aliased)
Mime-Version: 1.0
Content-Type: multipart/signed; protocol="application/pgp-signature";
	micalg="pgp-sha1";
	boundary="Signature=_Wed__28_Jan_2004_12_47_22_+0200_ob+DRIW2rsuQYY+H"

--Signature=_Wed__28_Jan_2004_12_47_22_+0200_ob+DRIW2rsuQYY+H
Content-Type: text/plain; charset=US-ASCII
Content-Disposition: inline
Content-Transfer-Encoding: 7bit

Hi all, 

It seems I always find a solution just after
panicking a little bit.
Anyway, I found that statement_timeout solved
my problem. When I tested it earlier, I actually 
made an error, and skipped it as a possible 
solution.

Cheers
Stef

Stef mentioned :
=> Forgot to mention that I use postgres 7.3.4
=> 
=> Stef mentioned :
=> => Hi all ,
=> => 
=> => I'm trying to find out if there is a specific setting 
=> => to make transactions time out faster in a scenario
=> => where there's an update on a table in a transaction 
=> => block, and another update process tries to update
=> => the same column.
=> => 
=> => It looks like the second process will wait until you
=> => end the transaction block in the first transaction.
=> => 
=> => I've looked at the deadlock timeout parameter and
=> => other parameters, but I don't think I found  what 
=> => I'm looking for.
=> => 
=> => I basically need to be able to let the second process
=> => exit with an error after waiting 5 - 10 seconds.
=> => 
=> => Please can someone help?
=> => 
=> => Kind Regards
=> => Stefan
=> => 
=> 

--Signature=_Wed__28_Jan_2004_12_47_22_+0200_ob+DRIW2rsuQYY+H
Content-Type: application/pgp-signature

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iQCVAwUBQBeTProLc+HYd7LFAQKu6wP/Y1mwesFbpeVYk/cEIS7qsbxPwcabByfQ
c4Lkitlp7zs2pdMtlwCl9PAMX+t09q0bdffon7SAo14taIKFvvcLMkrobls4TMEZ
k0fmV7qChlv3oLens71QezQDphnvdOYMCyX1cNLwFNJBNte8EfxzbJNPrwgBuepB
dixrYGexRe4=
=d4H3
-----END PGP SIGNATURE-----

--Signature=_Wed__28_Jan_2004_12_47_22_+0200_ob+DRIW2rsuQYY+H--