CREATE OR REPLACE VIEW user_visible_lazychat_messages AS
   SELECT eur.user, t.message
     FROM effective_user_roles eur, lazychat_targets t
    WHERE t.target = eur.role
  UNION
    SELECT m.author, m.message
    FROM lazychat_messages m;