merchant

commit 20138dd971d553f4af6236da5d12b00286b1a317
parent 357a283adfe6c1413d7ce2f6f769a7f0e0bba249
Author: Christian Grothoff <christian@grothoff.org>
Date:   Tue,  2 Jun 2026 22:03:05 +0200

fix 37 fixup

Diffstat:
M
src/backenddb/pg_fixup_instance_schema.sql
 | 
6
++----
M
src/backenddb/sql-schema/merchant-0036.sql.in
 | 
1
+
M
src/backenddb/sql-schema/merchant-0037.sql
 | 
2
+-

3 files changed, 4 insertions(+), 5 deletions(-)
diff --git a/src/backenddb/pg_fixup_instance_schema.sql b/src/backenddb/pg_fixup_instance_schema.sql
@@ -14,11 +14,10 @@
 -- TALER; see the file COPYING.  If not, see <http://www.gnu.org/licenses/>
 --
 
-DROP FUNCTION IF EXISTS merchant.fixup_instance_schema(BIGINT);
-CREATE FUNCTION merchant.fixup_instance_schema(
+DROP PROCEDURE IF EXISTS merchant.fixup_instance_schema(BIGINT);
+CREATE PROCEDURE merchant.fixup_instance_schema(
   in_min_version BIGINT
 )
-  RETURNS void
   LANGUAGE plpgsql
 AS $$
 DECLARE
@@ -45,4 +44,3 @@ END $$;
 
 COMMENT ON FUNCTION merchant.create_instance_schema(BIGINT)
   IS 'Updates all schema to the given version';
-
diff --git a/src/backenddb/sql-schema/merchant-0036.sql.in b/src/backenddb/sql-schema/merchant-0036.sql.in
@@ -66,6 +66,7 @@ COMMENT ON INDEX instance_fixups_by_version
 -- ---------------------------------------------------------------------
 #include "../create_tables.sql"
 #include "../pg_create_instance_schema.sql"
+#include "../pg_fixup_instance_schema.sql"
 #include "merchant-0036-init.sql.fragment"
 
 -- ---------------------------------------------------------------------
diff --git a/src/backenddb/sql-schema/merchant-0037.sql b/src/backenddb/sql-schema/merchant-0037.sql
@@ -51,6 +51,6 @@ INSERT INTO merchant.instance_fixups
   ('merchant_0037_init'
   ,37);
 -- Apply new fix-up to existing instances
-CALL merchant.merchant_create_instance_schema (37);
+CALL merchant.fixup_instance_schema (37::INT8);
 
 COMMIT;