Skip site navigation (1) Skip section navigation (2)

Re: implementing asynchronous notifications

From: David Gagnon <dgagnon(at)siunik(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: implementing asynchronous notifications
Date: 2005-04-20 15:59:46
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc

  I just read this thread. Wich seems really interesting.  Is there an 
example on how to use Async Notifies?  I look at it a couple of months 
ago and found it not sufficient for my needs.  I need to implement a 
notification mechanism to clear data from caches in my application on 
data update.

Is this change allow me to do that .. ?  That will be so nice :-)

If yes it's that possible to get a small example on how to use it.


Oliver Jowett wrote:

>Andras Kadinger wrote:
>>PGConnection.getNotifies() now processes peding Async Notifies first - no
>>need to send polling queries to the server anymore. The result is zero
>>network traffic in the idle case.
>I've applied your latest patch (with some cosmetic editing and a
>testcase) to CVS HEAD. Thanks for implementing this!
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

In response to


pgsql-jdbc by date

Next:From: David GagnonDate: 2005-04-20 18:02:19
Subject: Is closing a ResulSet, Statement or connection act as a rollback when a transaction is not commited? Not clear in JavaDoc.
Previous:From: Oliver JowettDate: 2005-04-20 00:20:44
Subject: Re: implementing asynchronous notifications

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group