[DBIx-Class-Devel] [dbsrgits/sql-translator] SQLite diff producer creates broken foreign key constraints (#95)

[andrewgregory]

Since SQLite doesn't support altering existing columns, sql-translator achieves this by creating a new table with the correct schema and copying the data over.  It first copies the data into a temporary table, though.  If the table includes a foreign key constraint it cannot be satisfied because the temporary table is in a different SQLite schema.  Should sql-translator create the new table in the main database so that foreign keys work or do applications need to disable (or just not enable to begin with) foreign key constraints for sql translator?

-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/dbsrgits/sql-translator/issues/95
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.scsys.co.uk/pipermail/dbix-class-devel/attachments/20170829/eff47f6c/attachment.htm>