Re: Is it possible to get the Payload from a NOTIFY via the JDBC Driver?

> This works with 9.0 and newer server versions. The JDBC driver didn't
> need any changes to make that happen, so the comment never got
> updated.

Sweet, thanks :)

> > I'm also curious to know if there are any plans to implement async
> > support for notifications.
> >
>
> Meaning a callback mechanism or just not needing to issue queries to the
> server? Currently the JDBC driver supports an intermediate method
> depending on your connection type. You only need to poll
> PGConnection.getNotifications, not issue server queries as long as you
> aren't connected via SSL. The driver uses InputStream.available to
> determine when a notification is pending which isn't supported on all
> InputStreams.

It would be nice to be able to attach a listener that gets notifications in realtime as they come over the wire, but if I understand you correctly, I can atleast let a thread poll regularily, and it will not create any network traffic, right? Is there a way to attach a listener with today's architecture?

-- Edvin