# HG changeset patch
# User Alain Mazy <am@osimis.io>
# Date 1702923429 -3600
# Node ID f790232b77ef234beb09b925c523ec0624eca4c0
# Parent  d979f25e60cf02a7722f8d328440085c920156b0
fix InsertOrUpdateMetadata

diff -r d979f25e60cf -r f790232b77ef PostgreSQL/Plugins/SQL/PrepareIndexV2.sql
--- a/PostgreSQL/Plugins/SQL/PrepareIndexV2.sql	Mon Dec 18 18:50:01 2023 +0100
+++ b/PostgreSQL/Plugins/SQL/PrepareIndexV2.sql	Mon Dec 18 19:17:09 2023 +0100
@@ -453,7 +453,8 @@
 BEGIN
   	FOR i IN 1 .. ARRAY_LENGTH(resource_ids, 1) LOOP
 		-- RAISE NOTICE 'Parameter %: % % %', i, resource_ids[i], metadata_types[i], metadata_values[i];
-		INSERT INTO Metadata VALUES(resource_ids[i], metadata_types[i], metadata_values[i], revisions[i]) ON CONFLICT DO NOTHING;
+		INSERT INTO Metadata VALUES(resource_ids[i], metadata_types[i], metadata_values[i], revisions[i]) 
+          ON CONFLICT (id, type) DO UPDATE SET value = EXCLUDED.value, revision = EXCLUDED.revision;
 	END LOOP;
   
 END;