title: Lightest lock for exclusive inserts in PostgreSQL
body: <p>I want to limit INSERTs to whichever transaction gets the lock (with the others waiting in line, not failing) while allowing concurrent reads, updates, and deletes (but obviously not of the data being inserted, which is impossible in PG anyway).</p>
  
  <p>What is the lightest LOCK to achieve this?</p>