diff options
| author | Christian Grothoff <christian@grothoff.org> | 2022-05-17 11:21:20 +0200 |
|---|---|---|
| committer | Christian Grothoff <christian@grothoff.org> | 2022-05-17 11:21:20 +0200 |
| commit | d8f1f7b761a41fc027c53dcd85c2b07dd73c6d1b (patch) | |
| tree | 40a92a23af452f01af6260f4de138438cb46cc0d /src/exchangedb/common-0001.sql | |
| parent | 802649c2703cb1b9991316073ca0b9e20cebe16f (diff) | |
| download | exchange-d8f1f7b761a41fc027c53dcd85c2b07dd73c6d1b.tar.gz exchange-d8f1f7b761a41fc027c53dcd85c2b07dd73c6d1b.tar.bz2 exchange-d8f1f7b761a41fc027c53dcd85c2b07dd73c6d1b.zip | |
integrate purse expiration into test, bugfixes
Diffstat (limited to 'src/exchangedb/common-0001.sql')
| -rw-r--r-- | src/exchangedb/common-0001.sql | 8 |
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 $$; |