Port Bug Report: Remote connections never die - Mailing list pgsql-ports

From Unprivileged user
Subject Port Bug Report: Remote connections never die
Date
Msg-id 199812281200.HAA27534@hub.org
Whole thread Raw
List pgsql-ports
============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name        : Juan Alvarez
Your email address    : jferrando@acm.org

Category        : unknown
Severity        : serious

Summary: Remote connections never die

System Configuration
--------------------
  Operating System   : Linux 2.0.35 (Suse 5.3)

  PostgreSQL version : 6.0

  Compiler used      :

Hardware:
---------
Pentium II 333Mhz, 128 MB RAM, 4 GB SCSI disk drive

Versions of other tools:
------------------------


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

Problem Description:
--------------------
I'm using JDBC with password control to access the database.
If the network goes down or the client program dies the
postgres process stays alive with any updated (and not
commited or rolled back) table blocked.
I cant't find a way to avoid this nasty behaviour.

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

Test Case:
----------


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

Solution:
---------


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


pgsql-ports by date:

Previous
From: Andrea Gabellini
Date:
Subject: New User
Next
From: Silvio Emanuel Barbosa de Macedo
Date:
Subject: postgres Linux on i586 regression tests