aboutsummaryrefslogtreecommitdiff
path: root/src/exchangedb/common-0001.sql
diff options
context:
space:
mode:
authorChristian Grothoff <christian@grothoff.org>2022-05-17 11:21:20 +0200
committerChristian Grothoff <christian@grothoff.org>2022-05-17 11:21:20 +0200
commitd8f1f7b761a41fc027c53dcd85c2b07dd73c6d1b (patch)
tree40a92a23af452f01af6260f4de138438cb46cc0d /src/exchangedb/common-0001.sql
parent802649c2703cb1b9991316073ca0b9e20cebe16f (diff)
integrate purse expiration into test, bugfixes
Diffstat (limited to 'src/exchangedb/common-0001.sql')
-rw-r--r--src/exchangedb/common-0001.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/src/exchangedb/common-0001.sql b/src/exchangedb/common-0001.sql
index 05394246c..cb64f446e 100644
--- a/src/exchangedb/common-0001.sql
+++ b/src/exchangedb/common-0001.sql
@@ -1193,6 +1193,14 @@ BEGIN
'(merge_pub);'
);
+ -- FIXME: drop index on master (crosses shards)?
+ -- Or use materialized index? (needed?)
+ EXECUTE FORMAT (
+ 'CREATE INDEX IF NOT EXISTS ' || table_name || '_purse_expiration '
+ 'ON ' || table_name || ' '
+ '(purse_expiration);'
+ );
+
END
$$;