Search Postgresql Archives

Re: Best way to use trigger to email a report ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Got it. 

On Fri, May 8, 2020 at 2:05 PM David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:
On Fri, May 8, 2020 at 10:19 AM Christophe Pettus <xof@xxxxxxxxxxxx> 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.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux