title: Row Not Being Deleted After ON DELETE Trigger Runs
body: <p>I am working in PostgreSQL 8.4 and have written a trigger function like so:</p>
  
  <pre><code>CREATE OR REPLACE FUNCTION otherschema.order_delete_log_procedure() RETURNS TRIGGER AS
  $$
  BEGIN
      DELETE FROM otherschema.order_log AS thelog WHERE thelog.log_order_id=OLD.order_id;
      RETURN NULL;
  END;
  $$ LANGUAGE plpgsql;
  
  CREATE TRIGGER order_deletion_log_trigger BEFORE DELETE ON public.order FOR EACH ROW EXECUTE PROCEDURE
  otherschema.order_delete_log_procedure();
  </code></pre>
  
  <p>My problem is, the trigger fires perfectly (the trigger is deleting the log row), however the row that is supposed to be deleted from the table that is firing the trigger is not getting deleted (the order isn't getting deleted).</p>
  
  <p>If I try to delete the order row manually, it just says that no rows were affected and it gives no error.  Any thoughts?</p>
  
  <p>Thanks!</p>