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) {
* Include the basic keydb routines.
*/
#define NEED_UPDATEKEYS 1
+#define NEED_GET 1
#define NEED_GET_FP 1
#include "keydb.c"
dbctx->cleanupdb = pg_cleanupdb;
dbctx->starttrans = pg_starttrans;
dbctx->endtrans = pg_endtrans;
- dbctx->fetch_key_id = pg_fetch_key_id;
+ dbctx->fetch_key = generic_fetch_key;
dbctx->fetch_key_fp = generic_fetch_key_fp;
+ dbctx->fetch_key_id = pg_fetch_key_id;
dbctx->fetch_key_text = pg_fetch_key_text;
dbctx->store_key = pg_store_key;
dbctx->update_keys = generic_update_keys;