How to Ignore error in batch insert Postgresql
<p>I have a process that runs every 5 minutes and tries to insert a batch of articles into a table. The articles come from web-scraping, so there are cases in which I am trying to insert a batch that contains articles which have already been saved into the DB.</p>
<p>My primary key is <code>uuid</code> - an MD5 hash of the article title.</p>
<p>Checking if an article exists in the db to filter the batch is kinda inefficient.</p>
<p>Is it a DB level way in Postgresql to ignore the attempts of inserting a duplicate <code>uuid</code> without returning an Error?</p>