exchange

commit 889c88651e37427fdc57f6f3c7ffcfb6e66354e7
parent 318766c58bd9272b3321d392c97e5caf794d5d7e
Author: Christian Grothoff <christian@grothoff.org>
Date:   Thu, 27 Mar 2025 13:42:58 +0100

fix SQL

Diffstat:
M
src/exchangedb/Makefile.am
 | 
2
+-
M
src/exchangedb/exchange_statistics_helpers.sql
 | 
7
+++----

2 files changed, 4 insertions(+), 5 deletions(-)
diff --git a/src/exchangedb/Makefile.am b/src/exchangedb/Makefile.am
@@ -72,7 +72,7 @@ CLEANFILES = \
   exchange-0008.sql \
   procedures.sql
 
-procedures.sql: procedures.sql.in exchange_do_*.sql
+procedures.sql: procedures.sql.in exchange_do_*.sql exchange_statistics_helpers.sql
 	chmod +w $@ 2> /dev/null || true
 	gcc -E -P -undef - < procedures.sql.in 2>/dev/null | sed -e "s/--.*//" | awk 'NF' - >$@
 	chmod ugo-w $@
diff --git a/src/exchangedb/exchange_statistics_helpers.sql b/src/exchangedb/exchange_statistics_helpers.sql
@@ -276,7 +276,7 @@ CREATE OR REPLACE PROCEDURE exchange_do_bump_amount_interval_stat(
   in_slug TEXT,
   in_h_payto BYTEA,
   in_timestamp TIMESTAMP,
-  in_delta taler_amount 
+  in_delta taler_amount
 )
 LANGUAGE plpgsql
 AS $$
@@ -1034,11 +1034,10 @@ BEGIN
   -- Doing so also DELETEs the associated statistics, hence CASCADE.
   DELETE
      FROM exchange_statistic_interval_meta
-    WHERE origin=in_schema CASCADE;
+    WHERE origin=in_schema;
   DELETE
      FROM exchange_statistic_bucket_meta
-    WHERE origin=in_schema CASCADE;
+    WHERE origin=in_schema;
 END $$;
 COMMENT ON FUNCTION exchange_drop_customization
   IS 'Removes all entries related to a particular exchange customization schema';
-