From: Theodore Petrosky <tedpet5@yahoo.com>
To: postgres SQL <pgsql-sql@postgresql.org>
Subject: notify and leaks?
Date: Wed, 7 Apr 2004 09:30:19 -0700 (PDT)
Message-ID: <20040407163019.34185.qmail@web41007.mail.yahoo.com> (raw)
I am using postgresql as the backend to a job tracking
system. My front app is running only on Mac OS X.
I have been using notifications from postgresql to
tell my user if the current record they are looking at
has been updated by someone else. Obviously I am only
'listening' when a user is looking at a particular
job.
I am concerned about usage of the listen and unlisten.
How does the backend know if my app didn't quit
unexpectidly? I mean I don't think my app has ever
crashed :)... and I do make sure if the user quits
that I close the connection. But I have a few users
that are using laptops on a wireless network. We are
in a building in manhattan and not infrequently the
wireless connection is lost.
After all this conversation.. I guess my question is..
am I leaking 'listens' if I don't close them properly?
I only created a few users and most of the connections
are from one of the user accounts. I do not have
separate user accounts.
Is this a problem waiting to bite me later?
Ted
__________________________________
Do you Yahoo!?
Yahoo! Small Business $15K Web Design Giveaway
http://promotions.yahoo.com/design_giveaway/
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-sql@postgresql.org
Cc: tedpet5@yahoo.com
Subject: Re: notify and leaks?
In-Reply-To: <20040407163019.34185.qmail@web41007.mail.yahoo.com>
* 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