Обсуждение: Port Bug Report: Remote connections never die

Поиск
Список
Период
Сортировка

Port Bug Report: Remote connections never die

От
Unprivileged user
Дата:
============================================================================
                        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:
---------


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