x.sql

CREATE OR REPLACE FUNCTION kakadudu() RETURNS uuid AS $$
DECLARE
  evid uuid := gen_random_uuid();
BEGIN
  INSERT INTO log (evid) VALUES (evid); 
  LISTEN kakadudu;
  PERFORM pg_notify('kakadudu', evid::text);
  RETURN evid;
END;
$$ LANGUAGE plpgsql;