<p>I receive the following error when my PostgreSQL stored procedures return JSON type or I use row_to_json in an avp_db_query:</p>

<p><code>WARNING:db_postgres:db_postgres_get_columns: unhandled data type column (server_detail) type id (114), use DB_STRING as default</code></p>

<p>This just defines JSONOID as DB_STRING in <code>db_postgres_get_columns</code> as opposed to letting it default to DB_STRING and generate the warnings.</p>

<hr>

<h4>You can view, comment on, or merge this pull request online at:</h4>
<p>&nbsp;&nbsp;<a href='https://github.com/OpenSIPS/opensips/pull/823'>https://github.com/OpenSIPS/opensips/pull/823</a></p>

<h4>Commit Summary</h4>
<ul>
  <li>Add JSONOID to pg_type.h for supporting JSON return types</li>
</ul>

<h4>File Changes</h4>
<ul>
  <li>
    <strong>M</strong>
    <a href="https://github.com/OpenSIPS/opensips/pull/823/files#diff-0">modules/db_postgres/pg_type.h</a>
    (1)
  </li>
  <li>
    <strong>M</strong>
    <a href="https://github.com/OpenSIPS/opensips/pull/823/files#diff-1">modules/db_postgres/res.c</a>
    (1)
  </li>
</ul>

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

<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">&mdash;<br>Reply to this email directly or <a href="https://github.com/OpenSIPS/opensips/pull/823">view it on GitHub</a>.<img alt="" height="1" src="https://github.com/notifications/beacon/AFOciYxBrYm8u4zPDbG1k9CNpPL731Teks5prat0gaJpZM4Hr785.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/OpenSIPS/opensips/pull/823"></link>
  <meta itemprop="name" content="View Pull Request"></meta>
</div>
<meta itemprop="description" content="View this Pull Request on GitHub"></meta>
</div>