<p>This pull request will allow to generate next statement</p>
<pre><code>ALTER TABLE subnets ADD CONSTRAINT subnets_subnet_udx EXCLUDE USING gist ( subnet inet_ops with && ) WHERE state = 0;
</code></pre>
<p>with next syntax:</p>
<pre><code>$sqlt_table->add_constraint(
        name => 'subnets_subnet_udx',
        type => 'exclude',
        fields => 'subnet',
        expression => 'subnet inet_ops with &&',
        options => { using => 'gist', where => 'state = 0' },
);
</code></pre>
<hr>
<h4>You can view, comment on, or merge this pull request online at:</h4>
<p> <a href='https://github.com/dbsrgits/sql-translator/pull/98'>https://github.com/dbsrgits/sql-translator/pull/98</a></p>
<h4>Commit Summary</h4>
<ul>
<li>Implement EXCLUDE constraint for PostgreSQL</li>
</ul>
<h4>File Changes</h4>
<ul>
<li>
<strong>M</strong>
<a href="https://github.com/dbsrgits/sql-translator/pull/98/files#diff-0">lib/SQL/Translator/Producer/PostgreSQL.pm</a>
(9)
</li>
<li>
<strong>M</strong>
<a href="https://github.com/dbsrgits/sql-translator/pull/98/files#diff-1">lib/SQL/Translator/Schema/Constants.pm</a>
(5)
</li>
<li>
<strong>M</strong>
<a href="https://github.com/dbsrgits/sql-translator/pull/98/files#diff-2">lib/SQL/Translator/Schema/Constraint.pm</a>
(1)
</li>
</ul>
<h4>Patch Links:</h4>
<ul>
<li><a href='https://github.com/dbsrgits/sql-translator/pull/98.patch'>https://github.com/dbsrgits/sql-translator/pull/98.patch</a></li>
<li><a href='https://github.com/dbsrgits/sql-translator/pull/98.diff'>https://github.com/dbsrgits/sql-translator/pull/98.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/dbsrgits/sql-translator/pull/98">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AASeAqsPKObMviSLva3VaG1IQ5Kf-21Rks5sudgxgaJpZM4QBiTu">mute the thread</a>.<img alt="" height="1" src="https://github.com/notifications/beacon/AASeAlfnLdU3N7_IUscPZRyp2DhGzSwPks5sudgxgaJpZM4QBiTu.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/dbsrgits/sql-translator/pull/98"></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/dbsrgits/sql-translator","title":"dbsrgits/sql-translator","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/dbsrgits/sql-translator"}},"updates":{"snippets":[{"icon":"DESCRIPTION","message":"Implement EXCLUDE constraint for PostgreSQL (#98)"}],"action":{"name":"View Pull Request","url":"https://github.com/dbsrgits/sql-translator/pull/98"}}}</script>