[taler-exchange] branch master updated: fix #9111

[gnunet]

This is an automated email from the git hooks/post-receive script.

grothoff pushed a commit to branch master
in repository exchange.

The following commit(s) were added to refs/heads/master by this push:
     new 0d69fb634 fix #9111
0d69fb634 is described below

commit 0d69fb634a7f5116118ff47f2bfad0fad3a6a570
Author: Christian Grothoff <christian@grothoff.org>
AuthorDate: Thu Aug 22 22:17:59 2024 +0200

    fix #9111
---
 contrib/wallet-core                    |  2 +-
 src/exchangedb/0005-kyc_attributes.sql | 26 ++++++++++++++++++++++++++
 2 files changed, 27 insertions(+), 1 deletion(-)

diff --git a/contrib/wallet-core b/contrib/wallet-core
index e78b41204..5934e007f 160000
--- a/contrib/wallet-core
+++ b/contrib/wallet-core
@@ -1 +1 @@
-Subproject commit e78b4120493e89d836b0a87473eea572ad6c2bbd
+Subproject commit 5934e007f637bd9834a811e67c0a030d7a59f2c0
diff --git a/src/exchangedb/0005-kyc_attributes.sql 
b/src/exchangedb/0005-kyc_attributes.sql
index 1cffd4cb6..f8f40f66b 100644
--- a/src/exchangedb/0005-kyc_attributes.sql
+++ b/src/exchangedb/0005-kyc_attributes.sql
@@ -28,6 +28,7 @@ BEGIN
     ' DROP COLUMN kyc_prox'
     ',DROP COLUMN provider'
     ',DROP COLUMN satisfied_checks'
+    ',DROP CONSTRAINT kyc_attributes_pkey'
     ',ADD COLUMN trigger_outcome_serial INT8 NOT NULL'
     ';'
     ,table_name
@@ -43,6 +44,26 @@ BEGIN
 END $$;
 
 
+
+CREATE OR REPLACE FUNCTION constrain_table_kyc_attributes5(
+  IN partition_suffix TEXT
+)
+RETURNS void
+LANGUAGE plpgsql
+AS $$
+DECLARE
+  table_name TEXT DEFAULT 'kyc_attributes';
+BEGIN
+  table_name = concat_ws('_', table_name, partition_suffix);
+  -- To search accounts
+  EXECUTE FORMAT (
+    'CREATE INDEX ' || table_name || '_h_payto_index '
+    'ON ' || table_name || ' '
+    '(h_payto);'
+  );
+END $$;
+
+
 CREATE FUNCTION foreign_table_kyc_attributes5()
 RETURNS void
 LANGUAGE plpgsql
@@ -73,6 +94,11 @@ INSERT INTO exchange_tables
     ,FALSE),
     ('kyc_attributes5'
     ,'exchange-0005'
+    ,'constrain'
+    ,TRUE
+    ,FALSE),
+    ('kyc_attributes5'
+    ,'exchange-0005'
     ,'foreign'
     ,TRUE
     ,FALSE);

-- 
To stop receiving notification emails like this one, please contact
gnunet@gnunet.org.