tools/migration/migrator/prosody_sql.lua: Fix compatibility with PostgreSQL (thanks...

diff --git a/tools/migration/migrator/prosody_sql.lua b/tools/migration/migrator/prosody_sql.lua
index b1f836beaed1d78178e2f9e1128cfba93c660b53..50ae8c40a92c99aca7f8af5d0ab7f89fbf813981 100644 (file)
--- a/tools/migration/migrator/prosody_sql.lua
+++ b/tools/migration/migrator/prosody_sql.lua
@@ -149,7 +149,11 @@ function writer(output, iter)
        assert(stmt:execute());
        local stmt = assert(dbh:prepare("DELETE FROM prosody"));
        assert(stmt:execute());
-       local insert = assert(dbh:prepare("INSERT INTO `prosody` (`host`,`user`,`store`,`key`,`type`,`value`) VALUES (?,?,?,?,?,?)"));
+       local insert_sql = "INSERT INTO `prosody` (`host`,`user`,`store`,`key`,`type`,`value`) VALUES (?,?,?,?,?,?)";
+       if output.driver == "PostgreSQL" then
+               insert_sql = insert_sql:gsub("`", "\"");
+       end
+       local insert = assert(dbh:prepare(insert_sql));
 
        return function(item)
                if not item then assert(dbh:commit()) return dbh:close(); end -- end of input