SQLite Manager
When I export a database with FKs with the Export feature, the tables are not written to file in the right order. This becomes apparent when the exported database is re-imported with the Import feature, when a table B requires a table A because it references it - and table B is created before table A. The error message upon importing looks like this:
SQLiteManager:
INSERT INTO "B" VALUES(x,y); [ no such table: main.A ]
Exception Name: NS_ERROR_FAILURE Exception Message: Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.createStatement]
Aucun commentaire:
Enregistrer un commentaire