Re: BUG #3504: Some listening sessions never return from writing, problems ensue

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Peter Koczan" <pjkoczan(at)gmail(dot)com>
Cc: "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3504: Some listening sessions never return from writing, problems ensue
Date: 2007-08-03 00:49:53
Message-ID: 17555.1186102193@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Peter Koczan" <pjkoczan(at)gmail(dot)com> writes:
> This app uses Perl/DBD::Pg, and the code is basically:

> while ($dbh->func('pg_notifies')) {
> # do stuff
> }

If I'm not mistaken, that loop would process all the currently available
notify messages and then fall out. So the real question is what's
around this --- what conditions will make the program come back to this
loop periodically? Or not do so?

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Laurent Martelli 2007-08-03 08:04:51 Re: BUG #3506: to_number silently ignore characters
Previous Message Peter Koczan 2007-08-02 21:17:54 Re: BUG #3504: Some listening sessions never return from writing, problems ensue