title: AWS Redshift LOCK WRITE and not READ
body: <p>How can I do a <code>LOCK WRITE</code> on a table in a transaction that lets other connections perform SELECT operations ?</p>
  
  <p>When performing this :</p>
  
  <pre><code>BEGIN;
  LOCK TABLE my_table;
  &lt;very long commands&gt;
  </code></pre>
  
  <p>Other connections can't perform SELECT operations like <code>SELECT COUNT(*) FROM my_table;</code></p>
  
  <p>What I want to achieve is preventing others from writing while I'm writing, without preventing them from reading.</p>