<p>This adds support for covering indices (i.e. the "INCLUDE" clause on <code>create index</code>) for the Postgres producer.</p>
<p>the intended interface is as follows</p>
<pre><code>$table-&gt;add_index(
   name =&gt; 'covering', fields =&gt; [ 'foo' ], 
   options =&gt; { include =&gt; [ 'bar', 'baz' ] }
);
</code></pre>
<p>In the current implementation it silently skips the clause if PG is under<br>
version 10, b/c it was only added in 11 (as far as I remember). I'm not quite<br>
sure if it should be that way, or if it should die.</p>

<hr>

<h4>You can view, comment on, or merge this pull request online at:</h4>
<p>&nbsp;&nbsp;<a href='https://github.com/dbsrgits/sql-translator/pull/131'>https://github.com/dbsrgits/sql-translator/pull/131</a></p>

<h4>Commit Summary</h4>
<ul>
  <li>add support for covering index (INCLUDE) on PG producer</li>
</ul>

<h4>File Changes</h4>
<ul>
  <li>
    <strong>M</strong>
    <a href="https://github.com/dbsrgits/sql-translator/pull/131/files#diff-74dda26d4d454e8f3a1a7f3761fc0ebe1c1117c68b192b24c0e3ab07358bf733">lib/SQL/Translator/Producer/PostgreSQL.pm</a>
    (16)
  </li>
  <li>
    <strong>M</strong>
    <a href="https://github.com/dbsrgits/sql-translator/pull/131/files#diff-189a00d181911490216a0063c6c01224bccb76bbdc1a49f7b2725c76a42d1333">t/47postgres-producer.t</a>
    (8)
  </li>
</ul>

<h4>Patch Links:</h4>
<ul>
  <li><a href='https://github.com/dbsrgits/sql-translator/pull/131.patch'>https://github.com/dbsrgits/sql-translator/pull/131.patch</a></li>
  <li><a href='https://github.com/dbsrgits/sql-translator/pull/131.diff'>https://github.com/dbsrgits/sql-translator/pull/131.diff</a></li>
</ul>

<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">&mdash;<br />You are receiving this because you are subscribed to this thread.<br />Reply to this email directly, <a href="https://github.com/dbsrgits/sql-translator/pull/131">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AACJ4AVWML2DUPJZXEJAXGDS5ATQ3ANCNFSM4W7AQRQQ">unsubscribe</a>.<img src="https://github.com/notifications/beacon/AACJ4AV5RFLXCVX3CHXLVJDS5ATQ3A5CNFSM4W7AQRQ2YY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4L5GVK5A.gif" height="1" width="1" alt="" /></p>
<script type="application/ld+json">[
{
"@context": "http://schema.org",
"@type": "EmailMessage",
"potentialAction": {
"@type": "ViewAction",
"target": "https://github.com/dbsrgits/sql-translator/pull/131",
"url": "https://github.com/dbsrgits/sql-translator/pull/131",
"name": "View Pull Request"
},
"description": "View this Pull Request on GitHub",
"publisher": {
"@type": "Organization",
"name": "GitHub",
"url": "https://github.com"
}
}
]</script>