Got it. On Fri, May 8, 2020 at 2:05 PM David G. Johnston <david.g.johns...@gmail.com> wrote:
> On Fri, May 8, 2020 at 10:19 AM Christophe Pettus <x...@thebuild.com> > wrote: > >> If you don't want to periodically poll the table, you can use NOTIFY >> within the trigger to wake up a process that is waiting on NOTIFY. >> > > Kinda. > > "With the libpq library, the application issues LISTEN as an ordinary SQL > command, and then must periodically call the function PQnotifies to find > out whether any notification events have been received.". > > IOW, the interface for the client is still a polling interface its just > that with LISTEN the event is transient and in-memory only (on the server) > and thus has less overhead. > > David J. > >
