trusts: Fix db migration for PostgreSQL.

diff --git a/trusts/db-migration.c b/trusts/db-migration.c
index e8bea9b3720a2345afd03abe5eff3808e9702c13..a5f879600d4de4f1f2d569f69526f6cc2050510f 100644 (file)
--- a/trusts/db-migration.c
+++ b/trusts/db-migration.c
@@ -107,9 +107,9 @@ static void tm_final(void *tag, int errcode) {
 
     trustsdb->squery(trustsdb, "BEGIN TRANSACTION", "");
     trustsdb->squery(trustsdb, "DROP TABLE ?", "T", "groups");
-    trustsdb->squery(trustsdb, "ALTER TABLE ? RENAME TO ?", "Ts", "migration_groups", "groups");
+    trustsdb->squery(trustsdb, "ALTER TABLE ? RENAME TO groups", "T", "migration_groups");
     trustsdb->squery(trustsdb, "DROP TABLE ?", "T", "hosts");
-    trustsdb->squery(trustsdb, "ALTER TABLE ? RENAME TO ?", "Ts", "migration_hosts", "hosts");
+    trustsdb->squery(trustsdb, "ALTER TABLE ? RENAME TO hosts", "T", "migration_hosts");
     trustsdb->query(trustsdb, tm_complete, cbd, "COMMIT", "");
   }
 }

diff --git a/trusts/db-slave.c b/trusts/db-slave.c
index 66561cc052cdd3600963bfd32b70f0e423229d51..8d71b6d79fc2f1b9f654fd3c6058a6ebc675831a 100644 (file)
--- a/trusts/db-slave.c
+++ b/trusts/db-slave.c
@@ -35,8 +35,8 @@ void trusts_replication_swap(void) {
 
   trustsdb->squery(trustsdb, "BEGIN TRANSACTION", "");
   trustsdb->squery(trustsdb, "DROP TABLE ?", "T", "groups");
-  trustsdb->squery(trustsdb, "ALTER TABLE ? RENAME TO ?", "Ts", "replication_groups", "groups");
+  trustsdb->squery(trustsdb, "ALTER TABLE ? RENAME TO groups", "T", "replication_groups");
   trustsdb->squery(trustsdb, "DROP TABLE ?", "T", "hosts");
-  trustsdb->squery(trustsdb, "ALTER TABLE ? RENAME TO ?", "Ts", "replication_hosts", "hosts");
+  trustsdb->squery(trustsdb, "ALTER TABLE ? RENAME TO hosts", "T", "replication_hosts");
   trustsdb->query(trustsdb, tr_complete, NULL, "COMMIT", "");
 }