title: Amazon Redshift Keys are not enforced - how to prevent duplicate data?
body: <p>Just testing out <strong>AWS Redshift</strong>, and having discovered some dupe data on an insert that I'd hoped would just fail on duplication in the key column, reading the docs reveal that primary key constraints aren't "enforced".</p>
  
  <p>Anyone figured out how to prevent duplication on primary key (per "traditional" expectation).</p>
  
  <p>Thanks to any Redshift pioneers!</p>