From d6bf20028dc55174cd413a37ed70d8c73f7519e6 Mon Sep 17 00:00:00 2001 From: Özgür Kesim Date: Sat, 8 Jan 2022 19:45:00 +0100 Subject: Fixed prepared statement for extensions --- src/exchangedb/plugin_exchangedb_postgres.c | 10 +++------- 1 file changed, 3 insertions(+), 7 deletions(-) (limited to 'src/exchangedb/plugin_exchangedb_postgres.c') diff --git a/src/exchangedb/plugin_exchangedb_postgres.c b/src/exchangedb/plugin_exchangedb_postgres.c index 268279f3..fc90f37a 100644 --- a/src/exchangedb/plugin_exchangedb_postgres.c +++ b/src/exchangedb/plugin_exchangedb_postgres.c @@ -2746,13 +2746,9 @@ prepare_statements (struct PostgresClosure *pg) /* Used in #postgres_set_extension_config */ GNUNET_PQ_make_prepare ( "set_extension_config", - "WITH upsert AS " - " (UPDATE extensions " - " SET config=$2 " - " config_sig=$3 " - " WHERE name=$1 RETURNING *) " - "INSERT INTO extensions (config, config_sig) VALUES ($2, $3) " - "WHERE NOT EXISTS (SELECT * FROM upsert);", + "INSERT INTO extensions (name, config, config_sig) VALUES ($1, $2, $3) " + "ON CONFLICT (name) " + "DO UPDATE SET (config, config_sig) = ($2, $3)", 3), /* Used in #postgres_get_extension_config */ GNUNET_PQ_make_prepare ( -- cgit v1.2.3