[taler-exchange] branch master updated: fix format specifiers

[gnunet]

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

marco-boss pushed a commit to branch master
in repository exchange.

The following commit(s) were added to refs/heads/master by this push:
     new f596b27a fix format specifiers
f596b27a is described below

commit f596b27a97dd649664f624d7f72cd52b7f56e043
Author: Marco Boss <bossm8@bfh.ch>
AuthorDate: Sat Apr 2 12:18:56 2022 +0200

    fix format specifiers
---
 src/exchangedb/common-0001.sql | 11 ++++++-----
 1 file changed, 6 insertions(+), 5 deletions(-)

diff --git a/src/exchangedb/common-0001.sql b/src/exchangedb/common-0001.sql
index 5f0e8241..09698087 100644
--- a/src/exchangedb/common-0001.sql
+++ b/src/exchangedb/common-0001.sql
@@ -611,7 +611,6 @@ BEGIN
       ',done BOOLEAN NOT NULL DEFAULT FALSE'
       ',extension_blocked BOOLEAN NOT NULL DEFAULT FALSE'
       ',extension_details_serial_id INT8' -- REFERENCES extension_details 
(extension_details_serial_id) ON DELETE CASCADE'
-      ',UNIQUE (coin_pub, merchant_pub, h_contract_terms)'
     ') %s ;'
     ,table_name
     ,'PARTITION BY HASH (coin_pub)'
@@ -639,7 +638,9 @@ BEGIN
   EXECUTE FORMAT (
     'ALTER TABLE deposits_' || partition_suffix || ' '
       'ADD CONSTRAINT deposits_' || partition_suffix || 
'_deposit_serial_id_pkey '
-        'PRIMARY KEY (deposit_serial_id)'
+        'PRIMARY KEY (deposit_serial_id) '
+      ',ADD CONSTRAINT deposits_' || partition_suffix || 
'_coin_pub_merchant_pub_h_contract_terms_key '
+        'UNIQUE (coin_pub, merchant_pub, h_contract_terms)'
   );
 END
 $$;
@@ -1644,7 +1645,7 @@ BEGIN
   ALTER TABLE IF EXISTS deposits
     DROP CONSTRAINT IF EXISTS deposits_pkey CASCADE
     ,DROP CONSTRAINT IF EXISTS deposits_extension_details_serial_id_fkey
-    ,DROP CONSTRAINT IF EXISTS 
deposits_shard_known_coin_id_merchant_pub_h_contract_terms_key CASCADE
+    ,DROP CONSTRAINT IF EXISTS 
deposits_coin_pub_merchant_pub_h_contract_terms_key CASCADE
   ;
 
   ALTER TABLE IF EXISTS refunds
@@ -1711,7 +1712,7 @@ BEGIN
 
   EXECUTE FORMAT(
     'CREATE USER MAPPING IF NOT EXISTS '
-      'FOR %s SERVER %I '
+      'FOR %I SERVER %I '
       'OPTIONS (user %L, password %L)'
     ,local_user
     ,shard_suffix
@@ -1722,7 +1723,7 @@ BEGIN
   EXECUTE FORMAT(
     'GRANT ALL PRIVILEGES '
       'ON FOREIGN SERVER %I '
-      'TO %L;'
+      'TO %I;'
     ,shard_suffix
     ,local_user
   );

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