Viacheslav N Tararin <taras(at)dekasoft(dot)com(dot)ua> writes:> NOTIFY work, message will send on statement execution, but transaction > may be rolledback later.
No, the message is sent at commit. See the man page for NOTIFY.
regards, tom lane