pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Matthew Fleming <mgf@post.its.mcw.edu>
To: pgsql-interfaces@postgresql.org
Subject: automatic disconnect?
Date: Tue, 23 Feb 1999 12:26:42 -0600 (CST)
Message-ID: <199902231826.MAA11222@post.its.mcw.edu> (raw)


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



Message-ID: <199902231826.MAA11222@post.its.mcw.edu>
Permalink:  ../199902231826.MAA11222@post.its.mcw.edu/
Also on:    postgresql.org/message-id/199902231826.MAA11222@post.its.mcw.edu

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: mgf@post.its.mcw.edu
  Subject: Re: automatic disconnect?
  In-Reply-To: <199902231826.MAA11222@post.its.mcw.edu>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox