[DBIx-Class-Devel] [sql-translator] Add deferred FKs to SQLite (#70)

[Dagfinn Ilmari Mannsåker]

> @@ -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 https://sqlite.org/syntax/foreign-key-clause.html.

---
Reply to this email directly or view it on GitHub:
https://github.com/dbsrgits/sql-translator/pull/70/files#r39672522
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.scsys.co.uk/pipermail/dbix-class-devel/attachments/20150916/bd98d219/attachment.htm>