title: How to drop a trigger in a resilient manner in postgresql
body: <p>I'm looking to drop a currently in production trigger because it's no longer needed, but the problem is that when I try the simplest way, which is something like</p>
  
  <pre><code>drop trigger &lt;triggername&gt; on &lt;tablename&gt;
  </code></pre>
  
  <p>It caused a huge table lock and everything froze!</p>
  
  <p>What the trigger does is:</p>
  
  <p>When a row is inserted or updated, check for a field's contents, split it and populate another table.</p>
  
  <p>How should I proceed to instantly disable (and dropping afterwards) without causing hassle in our production environment?</p>
  
  <p>Thanks in advance and sorry for my english ;)</p>