# HG changeset patch # User Matthew Wild # Date 1302537666 -3600 # Node ID 6a372135b4c48fa2d8155a0f952017ec3c95983e # Parent 19c9bf88ec89dca97cef4057c21007079be2f631 tools/migration/migrator/prosody_sql.lua: Fix compatibility with PostgreSQL (thanks Timo) diff -r 19c9bf88ec89 -r 6a372135b4c4 tools/migration/migrator/prosody_sql.lua --- a/tools/migration/migrator/prosody_sql.lua Wed Apr 06 14:45:44 2011 +0100 +++ b/tools/migration/migrator/prosody_sql.lua Mon Apr 11 17:01:06 2011 +0100 @@ -149,7 +149,11 @@ 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