I'm trying to do a multi_insert in a transaction into a SQLite DB table. The table is a 'users' table with a hierarchy column of 'parent_id'.
Certain records have 'id's which are less than their 'parent_id's because of which multi_insert fails with foreign key constraint violation. How do I set the "PRAGMA defer_foreign_keys" for the SQLite DB so that the constraints get applied only at the end of the transaction? -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/sequel-talk/139aac16-8bff-4214-a397-50b5eee602df%40googlegroups.com.
