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