[mdb-dev] Deferrable on foreign keys in exported schema

[Peter R. <qwe...@gm...>]

Hi list,

I'm using mdb-tools to import an Access database into Postgres, one problem
though is that loading data into an exported schema is more difficult than it
could be.  It would help if the generated constraints were deferrable, so that
the data can be loaded in in any order.

Thanks

Peter Russell

diff --git a/src/libmdb/backend.c b/src/libmdb/backend.c
index 655303c..48830cd 100644
--- a/src/libmdb/backend.c
+++ b/src/libmdb/backend.c
@@ -643,7 +643,7 @@ mdb_get_relationships(MdbHandle *mdb, const gchar
*namespace, const char* tablen
                                " REFERENCES ", quoted_table_2, "(",
quoted_column_2, ")",
                                (grbit & 0x00000100) ? " ON UPDATE CASCADE" : "",
                                (grbit & 0x00001000) ? " ON DELETE CASCADE" : "",
-                               ";\n", NULL);
+                               " DEFERRABLE", ";\n", NULL);
 
                        break;
                }