Automatic disconnect? - Mailing list pgsql-general

From Matthew Fleming
Subject Automatic disconnect?
Date
Msg-id 199902231826.MAA10989@post.its.mcw.edu
Whole thread Raw
List pgsql-general
Netters,

I have just written an application which accesses a postgresql
database from perl via the dbi interface. However, my question is
perhaps a general one. The program establishes a connection to a
particular database via a $dbh->connect call, and then does a
$dbh->disconnect when the user exits from the application. However, I
have unruly users. What will happen if they kill the telnet window in
which the application is running? I believe the OS will then kill the
application, but will this then leave a "zombie" database handle?

Thanks for the info,

Matthew Fleming
------------------------------------------------------------------------------
Matthew G. Fleming, MD                  phone : 414.456.4072
Associate Professor                     fax   : 414.456.6518
Department of Dermatology               s-mail: Dept. of Dermatology
Medical College of Wisconsin                    Medical College of Wisconsin
                                                MFRC Room 4061
e-mail: mgf@mcw.edu                             Milwaukee, WI 53226-4810
------------------------------------------------------------------------------
      Decency is the ultimate civic virtue  -- Christopher Lasch

pgsql-general by date:

Previous
From: Michael Davis
Date:
Subject: RE: [GENERAL] Transaction logging
Next
From: Peter T Mount
Date:
Subject: Re: [GENERAL] Transaction logging