We used a trigger that called pg_notify (https://www.postgresql.org/docs/9.5/sql-notify.html) and then had another process that LISTENed for notifications. What kind of process is this? I'm assuming that this is an application written in C. The advantage of LISTEN / NOTIFY is only that the process which should process data does not have to do polling, but is notified when there is something to do. Dirk
|