<p>In <a href="https://github.com/dbsrgits/sql-translator/pull/70#discussion_r39744049">lib/SQL/Translator/Parser/SQLite.pm</a>:</p>
<pre style='color:#555'>> @@ -425,7 +425,7 @@ table_constraint : PRIMARY_KEY parens_field_list conflict_clause(?)
> }
> }
> |
> - FOREIGN_KEY parens_field_list REFERENCES ref_def cascade_def(?)
> + FOREIGN_KEY parens_field_list REFERENCES ref_def cascade_def(?) deferrable(?) deferred(?)
</pre>
<div class="email-fragment">I've updated the PR accordingly. All tests are passing.</div>
<span class="email-hidden-toggle"><a href="#">…</a></span><div class="email-hidden-reply" style="display:none">
<div class="email-quoted-reply">On Wed, Sep 16, 2015 at 7:12 PM, Dagfinn Ilmari Mannsåker < notifications@github.com> wrote:
In lib/SQL/Translator/Parser/SQLite.pm
<<a href="https://github.com/dbsrgits/sql-translator/pull/70#discussion_r39672522">https://github.com/dbsrgits/sql-translator/pull/70#discussion_r39672522</a>>:
> @@ -425,7 +425,7 @@ table_constraint : PRIMARY_KEY parens_field_list conflict_clause(?)
> }
> }
> |
> - FOREIGN_KEY parens_field_list REFERENCES ref_def cascade_def(?)
> + FOREIGN_KEY parens_field_list REFERENCES ref_def cascade_def(?) deferrable(?) deferred(?)
Unlike PostgreSQL, the INITIALLY (DEFERRED|IMMEDIATE) clause in SQLite is
part of the (NOT)? DEFERRABLE clause. See
<a href="https://sqlite.org/syntax/foreign-key-clause.html">https://sqlite.org/syntax/foreign-key-clause.html</a>.
—
Reply to this email directly or view it on GitHub
<<a href="https://github.com/dbsrgits/sql-translator/pull/70/files#r39672522">https://github.com/dbsrgits/sql-translator/pull/70/files#r39672522</a>>.
</div>
<div class="email-fragment"></div>
<div class="email-signature-reply">--
Thanks,
Rob Kinyon
<a href="http://greenfishbluefish.com/">http://greenfishbluefish.com/</a>
</div>
</div>
<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br>Reply to this email directly or <a href="https://github.com/dbsrgits/sql-translator/pull/70/files#r39744049">view it on GitHub</a>.<img alt="" height="1" src="https://github.com/notifications/beacon/AASeAphF0wjMwjoPUoMVJXRQc2EdzDHXks5oyrakgaJpZM4F-Z3L.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/70/files#r39744049"></link>
<meta itemprop="name" content="View Pull Request"></meta>
</div>
<meta itemprop="description" content="View this Pull Request on GitHub"></meta>
</div>