Re: Cheapest way to poll for notifications?

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Cheapest way to poll for notifications?
Date: 2009-12-19 07:24:53
Message-ID: 4B2C7FC5.4070201@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

On 11/12/2009 11:39 PM, Craig Ringer wrote:

> As for the JDBC driver - it turns out that the documentation is
> out-of-date and/or misleading. The JDBC driver *does* support reading
> notifications the backend has pushed to its receive buffer, and does
> *not* have to poll the backend or issue a statement to receive
> notifications.

Update: The above is true only for non-SSL connections. For SSL
connections you still have to send dummy statements.

--
Craig Ringer

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Raimon Fernandez 2009-12-19 07:40:12 Re: Extended Query, flush or sync ?
Previous Message Alex - 2009-12-19 07:14:58 Re: PL/Perl Performance Problems

Browse pgsql-jdbc by date

  From Date Subject
Next Message Alexander Pyhalov 2009-12-19 09:47:59 Re: Get bytes sent to client
Previous Message Craig Ringer 2009-12-19 07:00:35 Cheapest way to poll for notifications? & Driver improvement question re SSL and notify