Re: transaction idle timeout in 7.4.5 and 8.0.0beta2

Interesting. So it times out a transaction to release its locks. Does
it time from the start of the transaction? I assume so. We do have
statment_timeout so maybe transaction_timeout would be the proper name.
Timing out on just the idle state seems strange to me.

---------------------------------------------------------------------------

Szima Gbor wrote:
>
> Hi all,
>
> I was implement the "transaction idle timeout" function in PostgreSQL
> (version 7.4.5 and 8.0.0beta2)
>
> test=# SET trans_idle_timeout=10;
> SET
> test=# BEGIN;
> BEGIN
>
> (ps)
> ...
> postgres: sygma test [local] idle in transaction (3)
> postgres: sygma test [local] idle in transaction (2)
> postgres: sygma test [local] idle in transaction (1)
> postgres: sygma test [local] idle in transaction (aborted)
>
> test=# INSERT INTO test (a,b) VALUES (1,'a');
> ERROR: current transaction is aborted, commands ignored until end of transaction block
>
>
> The code is very simple and stable.
>
> Changed files:
>
> include/storage/proc.h
> backend/libpq/pqcomm.c
> backend/libpq/be-secure.c
> backend/utils/misc/guc.c
>
> TODO: SSL connection, manual, psql help & tab-competition
>
> Do you interest it?
>
>
> Regards, Sygma
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073