libeufin

commit e464bb3a67e9f5cf359cc63872cea1361ef155e9
parent 6bd9172326c6a1a3a03854a7ffebd37ac9135e4b
Author: Antoine A <>
Date:   Fri, 24 Jan 2025 10:10:49 +0100

nexus: fix migration

Diffstat:
M
database-versioning/libeufin-nexus-0010.sql
 | 
5
++---

1 file changed, 2 insertions(+), 3 deletions(-)
diff --git a/database-versioning/libeufin-nexus-0010.sql b/database-versioning/libeufin-nexus-0010.sql
@@ -21,9 +21,8 @@ SET search_path TO libeufin_nexus;
 
 -- Better polymorphism schema
 ALTER TABLE talerable_incoming_transactions ADD COLUMN metadata BYTEA;
-INSERT INTO talerable_incoming_transactions (metadata)
-  SELECT COALESCE (reserve_public_key, account_pub, wad_id)
-  FROM talerable_incoming_transactions;
+UPDATE talerable_incoming_transactions 
+  SET metadata=COALESCE (reserve_public_key, account_pub, wad_id);
 ALTER TABLE talerable_incoming_transactions
   DROP CONSTRAINT incoming_polymorphism,
   DROP COLUMN reserve_public_key,