X-Git-Url: http://the.earth.li/gitweb/?p=onak.git;a=blobdiff_plain;f=keydb%2Fkeydb_pg.c;h=1b58c1a5f27c71f1788c1e7783e70aa60df7b77a;hp=52d27fc538220b1c3c4661d5e952430b2e690067;hb=67f26da9c26e544b723ac73ac67383519c873e30;hpb=30a4eee133c15503dad435c8ce41953d94492c28 diff --git a/keydb/keydb_pg.c b/keydb/keydb_pg.c index 52d27fc..1b58c1a 100644 --- a/keydb/keydb_pg.c +++ b/keydb/keydb_pg.c @@ -290,19 +290,19 @@ static int pg_delete_key(struct onak_dbctx *dbctx, PQclear(result); snprintf(statement, 1023, - "DELETE FROM onak_keys WHERE keyid = '%" PRIX64 "'", + "DELETE FROM onak_sigs WHERE signee = '%" PRIX64 "'", keyid); result = PQexec(dbconn, statement); PQclear(result); snprintf(statement, 1023, - "DELETE FROM onak_sigs WHERE signee = '%" PRIX64 "'", + "DELETE FROM onak_uids WHERE keyid = '%" PRIX64 "'", keyid); result = PQexec(dbconn, statement); PQclear(result); snprintf(statement, 1023, - "DELETE FROM onak_uids WHERE keyid = '%" PRIX64 "'", + "DELETE FROM onak_keys WHERE keyid = '%" PRIX64 "'", keyid); result = PQexec(dbconn, statement); } else if (PQresultStatus(result) != PGRES_TUPLES_OK) {