exchange

commit a684a90366275bdc4114d2bfb8dea57a2ee59890
parent 70f05226b8f6dc2278fcfbe53a8abc92c1cdac92
Author: Özgür Kesim <oec@kesim.org>
Date:   Wed, 26 Mar 2025 21:19:45 +0100

[exchangedb] added 0009-aggregation_transient.sql

Diffstat:
M
src/exchangedb/0009-aggregation_transient.sql
 | 
6
+++++-
M
src/exchangedb/exchange-0009.sql.in
 | 
4
+---

2 files changed, 6 insertions(+), 4 deletions(-)
diff --git a/src/exchangedb/0009-aggregation_transient.sql b/src/exchangedb/0009-aggregation_transient.sql
@@ -12,8 +12,12 @@
 --
 -- You should have received a copy of the GNU General Public License along with
 -- TALER; see the file COPYING.  If not, see <http://www.gnu.org/licenses/>
---
 
+CREATE INDEX exchange_tables_by_pending
+  ON exchange_tables (table_serial_id)
+  WHERE NOT finished;
+COMMENT ON INDEX exchange_tables_by_pending
+  IS 'Used by exchange_do_create_tables';
 
 CREATE FUNCTION foreign_table_aggregation_transient9()
 RETURNS void
diff --git a/src/exchangedb/exchange-0009.sql.in b/src/exchangedb/exchange-0009.sql.in
@@ -12,8 +12,6 @@
 --
 -- You should have received a copy of the GNU General Public License along with
 -- TALER; see the file COPYING.  If not, see <http://www.gnu.org/licenses/>
---
--- @author Özgür Kesim
 
 BEGIN;
 
@@ -27,10 +25,10 @@ COMMENT ON INDEX exchange_tables_by_pending
   IS 'Used by exchange_do_create_tables';
 
 
-#include "0009-aggregation_transient.sql"
 #include "0009-age_withdraw.sql"
 #include "0009-withdraw.sql"
 #include "0009-recoup.sql"
 #include "0009-statistics.sql"
+#include "0009-aggregation_transient.sql"
 
 COMMIT;