lundi 2 novembre 2015

Exported tables are not in the right order (FK)

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