X-Git-Url: https://git.enpas.org/?a=blobdiff_plain;f=tools%2Fmigration%2Fmigrator%2Fprosody_sql.lua;h=50ae8c40a92c99aca7f8af5d0ab7f89fbf813981;hb=f7f0c23d27cd61b7410a7b14df845adb0ac201b2;hp=b1f836beaed1d78178e2f9e1128cfba93c660b53;hpb=6060b4a59bc700d6001414d60a59d101a0e5306b;p=prosody.git

diff --git a/tools/migration/migrator/prosody_sql.lua b/tools/migration/migrator/prosody_sql.lua
index b1f836be..50ae8c40 100644
--- 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