title: Can't get notify in postgresql trigger function to work
body: <p>Running <em>Postgresql 9.1</em> on <em>ubuntu</em>.
  I have a database defined and it has a table named <strong>pending</strong>.
  I created a trigger function named <strong>ins_notify_function</strong>.<br>
  The content of this function is</p>
  
  <pre><code>    BEGIN
      NOTIFY "inspend", 'fired by NOTIFY';
      RETURN NULL;
      END
  </code></pre>
  
  <p>I have a trigger function created:</p>
  
  <pre><code>   CREATE TRIGGER audit_ins
     AFTER INSERT
     ON pending
     FOR EACH ROW
     EXECUTE PROCEDURE ins_notify_function();
  </code></pre>
  
  <p>So, I then run <em>psql</em> and type into it:</p>
  
  <pre><code>   LISTEN "inspend";
  </code></pre>
  
  <p>In <em>psql</em> I type:</p>
  
  <pre><code>   NOTIFY "inspend"; 
  </code></pre>
  
  <p>and get back the Asynchronous notification ...
  message.</p>
  
  <p>Insert a record in the table pending and <em>psql</em> does NOT show Asynchronous notification ...
  It shows nothing.</p>
  
  <p>Am I missing a step here?</p>
  
  <p>Any help greatly appreciated.</p>
  
  <p>Thanks.</p>