Horton

Re: timeout implementation issues

Jessica Perry Hekman <jphekman@dynamicdiagrams.com>

View thread
From: Jessica Perry Hekman <jphekman@dynamicdiagrams.com>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Jan Wieck <janwieck@yahoo.com>, pgsql-hackers@postgresql.org
Date: 2002-04-02T19:17:20Z
Lists: pgsql-hackers 
On Tue, 2 Apr 2002, Bruce Momjian wrote:

> 	BEGIN WORK;
> 	query;
> 	SET statement_timeout = 4;
> 	query;
> 	SET statement_timeout = 0;
> 	query;
> 	COMMIT;
> 	SET statement_timeout = 0;
> 
> Basically, it does the reset twice, once assuming the transaction
> doesn't abort, and another assuming it does abort.  Is this something
> that the JDBC and ODBC drivers can do automatically?

I can't speak for ODBC. Seems like in JDBC, Connection::commit() would
call code clearing the timeout, and Statement::executeQuery() and
executeUpdate() would do the same.

j