1 CREATE OR REPLACE FUNCTION alert_zc_notify() RETURNS trigger AS $$
3 PERFORM pg_notify( 'zc', NEW.pn || ',' || NEW._id );
4 RETURN NULL; -- after trigger, result is ignored
8 -- DROP TRIGGER alert_zc_trigger ON zc;
10 CREATE TRIGGER alert_zc_trigger
12 FOR EACH ROW EXECUTE FUNCTION alert_zc_notify();