transaction idle timeout in 7.4.5 and 8.0.0beta2

From: Szima Gábor <sygma(at)axelero(dot)hu>
To: pgsql-hackers(at)postgresql(dot)org
Subject: transaction idle timeout in 7.4.5 and 8.0.0beta2
Date: 2004-09-17 06:47:02
Message-ID: Pine.LNX.4.50.0409170846170.989-100000@vigo.sygma.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Katsaros Kwn/nos 2004-09-17 08:50:18 Re: Problems with SPI memory management (new...)
Previous Message Christopher Browne 2004-09-17 04:25:04 Re: pg_dump --exclude-schema=foo