title: RAISE NOTICE not appearing on screen
body: <p>I have the following trigger that checks if space used > quota and increments the quota by 5. The quota is successfully incremented but the RAISE NOTICE does not appear on the screen.</p>
  
  <pre><code> CREATE OR REPLACE FUNCTION checkspaceused() RETURNS TRIGGER AS $cssubscription$
   DECLARE
   new_spaceused INTEGER; 
   new_id INTEGER; 
   new_quota INTEGER ;
   BEGIN
      IF(TG_OP='UPDATE') THEN
          IF NEW.spaceused &gt; NEW.quota THEN
          RAISE NOTICE 'Limit breached';
          UPDATE subscription SET quota = NEW.spaceused + 5 where u_id = NEW.u_id; 
          END IF ; 
  
      END IF;
  
  RETURN NEW; 
  END;
  $cssubscription$ LANGUAGE plpgsql;
  CREATE TRIGGER checkspaceused AFTER UPDATE ON subscription FOR EACH ROW EXECUTE PROCEDURE checkspaceused();
  </code></pre>
  
  <p>Help please. </p>