Axel Rau <Axel(dot)Rau(at)Chaos1(dot)DE> writes:
> Can the channel argument derived from the NEW pseudo arg of an INSERT TRIGGER?
> In the following trigger function, the
> PERFORM pg_notify(fac);
> does not work (LISTEN in psql shows no notification).
That should work.
I think more likely what you're running into is that the NOTIFY won't
be delivered until end of transaction?
regards, tom lane