<p>Why is insert_update doing nothing in Kamailio db insert_update ?</p>
<p>As explained in the following article the design of "UPSERT" in<br>
PostgreSQL requires to be explicit about the constraint on which<br>
we accept to do update modification to Kamailio database framework/API<br>
would be required to expose which specific key constraint should be<br>
handled as an update</p>
<p><a href="http://pgeoghegan.blogspot.com/2015/10/avoid-naming-constraint-directly-when.html">http://pgeoghegan.blogspot.com/2015/10/avoid-naming-constraint-directly-when.html</a></p>
<p>In this first step, DO NOTHING is providing the simple feature to ignore<br>
error on insert when facing a constraint violation</p>

<hr>

<h4>You can view, comment on, or merge this pull request online at:</h4>
<p>  <a href='https://github.com/kamailio/kamailio/pull/1039'>https://github.com/kamailio/kamailio/pull/1039</a></p>

<h4>Commit Summary</h4>
<ul>
  <li>db_postgress: insert_update() with DO NOTHING</li>
</ul>

<h4>File Changes</h4>
<ul>
  <li>
    <strong>M</strong>
    <a href="https://github.com/kamailio/kamailio/pull/1039/files#diff-0">src/modules/db_postgres/db_postgres.c</a>
    (1)
  </li>
  <li>
    <strong>M</strong>
    <a href="https://github.com/kamailio/kamailio/pull/1039/files#diff-1">src/modules/db_postgres/db_postgres.h</a>
    (2)
  </li>
  <li>
    <strong>M</strong>
    <a href="https://github.com/kamailio/kamailio/pull/1039/files#diff-2">src/modules/db_postgres/km_dbase.c</a>
    (83)
  </li>
  <li>
    <strong>M</strong>
    <a href="https://github.com/kamailio/kamailio/pull/1039/files#diff-3">src/modules/db_postgres/km_dbase.h</a>
    (5)
  </li>
  <li>
    <strong>M</strong>
    <a href="https://github.com/kamailio/kamailio/pull/1039/files#diff-4">src/modules/db_postgres/km_pg_con.c</a>
    (4)
  </li>
  <li>
    <strong>M</strong>
    <a href="https://github.com/kamailio/kamailio/pull/1039/files#diff-5">src/modules/db_postgres/pg_mod.c</a>
    (4)
  </li>
</ul>

<h4>Patch Links:</h4>
<ul>
  <li><a href='https://github.com/kamailio/kamailio/pull/1039.patch'>https://github.com/kamailio/kamailio/pull/1039.patch</a></li>
  <li><a href='https://github.com/kamailio/kamailio/pull/1039.diff'>https://github.com/kamailio/kamailio/pull/1039.diff</a></li>
</ul>

<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br />You are receiving this because you are subscribed to this thread.<br />Reply to this email directly, <a href="https://github.com/kamailio/kamailio/pull/1039">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AF36Zbws1UlKDi0kNBQunAqrJbf390z6ks5rnFGcgaJpZM4Mhjex">mute the thread</a>.<img alt="" height="1" src="https://github.com/notifications/beacon/AF36ZXDXtWJyTpqU1wjWPKTV1elPWyIBks5rnFGcgaJpZM4Mhjex.gif" width="1" /></p>
<div itemscope itemtype="http://schema.org/EmailMessage">
<div itemprop="action" itemscope itemtype="http://schema.org/ViewAction">
  <link itemprop="url" href="https://github.com/kamailio/kamailio/pull/1039"></link>
  <meta itemprop="name" content="View Pull Request"></meta>
</div>
<meta itemprop="description" content="View this Pull Request on GitHub"></meta>
</div>

<script type="application/json" data-scope="inboxmarkup">{"api_version":"1.0","publisher":{"api_key":"05dde50f1d1a384dd78767c55493e4bb","name":"GitHub"},"entity":{"external_key":"github/kamailio/kamailio","title":"kamailio/kamailio","subtitle":"GitHub repository","main_image_url":"https://cloud.githubusercontent.com/assets/143418/17495839/a5054eac-5d88-11e6-95fc-7290892c7bb5.png","avatar_image_url":"https://cloud.githubusercontent.com/assets/143418/15842166/7c72db34-2c0b-11e6-9aed-b52498112777.png","action":{"name":"Open in GitHub","url":"https://github.com/kamailio/kamailio"}},"updates":{"snippets":[{"icon":"DESCRIPTION","message":"db_postgress: insert_update() with DO NOTHING (#1039)"}],"action":{"name":"View Pull Request","url":"https://github.com/kamailio/kamailio/pull/1039"}}}</script>