aboutsummaryrefslogtreecommitdiff
path: root/src/exchangedb/exchange_do_reserves_in_insert.sql
AgeCommit message (Collapse)Author
2024-01-10add support for taler-merchant-exchange to taler-unified-setup.shChristian Grothoff
2023-07-30remove pre-array batch reserves-in insertion logicChristian Grothoff
2023-07-30misc bug fixes in batch insertChristian Grothoff
2023-07-30unify to TEXT instead of mixing TEXT and VARCHARChristian Grothoff
2023-07-29migration to new amount style for exchangedbChristian Grothoff
2023-07-28taler_amount type introduced in reserves table and corresponding functionsÖzgür Kesim
- current_balance is now a taler_amount - all C-functions, SQL-statements and stored procedures adjusted accordingly. => make check passes all tests in testing.
2023-07-28FAILING attempt to make echange.reserve use taler_amountÖzgür Kesim
Fails with > TALER_PREFIX=/usr/local ./test-exchangedb-postgres 2023-07-28T19:02:25.150845+0200 /home/oec/projects/taler/exchange/src/exchangedb/.libs/test-exchangedb-postgres-2559159 WARNING Could not run PSQL on file /usr/local/share/taler//sql/exchange/drop.sql: psql exit code was 3 2023-07-28T19:02:32.488085+0200 pq-2559159 ERROR Query `call_withdraw' failed with result: invalid input syntax for type bigint: "(1,1000)"/(null)/ERROR: invalid input syntax for type bigint: "(1,1000)" CONTEXT: PL/pgSQL function exchange_do_withdraw(bytea,taler_amount,bytea,bytea,bytea,bytea,bytea,bigint,bigint,boolean) line 23 at SQL statement /PGRES_FATAL_ERROR/ERROR: invalid input syntax for type bigint: "(1,1000)" CONTEXT: PL/pgSQL function exchange_do_withdraw(bytea,taler_amount,bytea,bytea,bytea,bytea,bytea,bigint,bigint,boolean) line 23 at SQL statement 2023-07-28T19:02:32.488146+0200 /home/oec/projects/taler/exchange/src/exchangedb/.libs/test-exchangedb-postgres-2559159 ERROR Assertion failed at test_exchangedb.c:1428.
2023-07-28-fix type defsChristian Grothoff
2023-06-02make CREATE TYPE usage idempotentFlorian Dold
PostgresSQL doesn't have a CREATE TYPE OR REPLACE, so we have to work around this with exception handling.
2023-05-21-fix SQLChristian Grothoff
2023-05-18array-based do_reserves_in_insertChristian Grothoff
2023-04-22simplify batch insert: no cursor where not required, replace ↵Christian Grothoff
out_reserve_found with ruuid being allowed to remain NULL
2023-04-22-misc fixesChristian Grothoff
2023-04-22-misc fixesChristian Grothoff
2023-04-22-misc fixesChristian Grothoff
2023-04-22-misc fixesChristian Grothoff
2023-04-22-misc bugsChristian Grothoff
2023-04-22-misc bugsChristian Grothoff
2023-04-22misc bugfixes in reserves_in batch logicChristian Grothoff
2023-03-27Spi filesJoseph