| 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: | Whole Thread | Raw Message | 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
| 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 |