diff options
| author | Christian Grothoff <christian@grothoff.org> | 2023-01-11 17:33:01 +0100 |
|---|---|---|
| committer | Christian Grothoff <christian@grothoff.org> | 2023-01-11 17:33:01 +0100 |
| commit | f2e444a6bb6a24c6398376ab7048baae37890b90 (patch) | |
| tree | 46c3b0c47986eb89aa82442fff3e782aca09afd7 /src/exchangedb/0003-withdraw_age_commitments.sql | |
| parent | 30c6580c4eb90050cf2f58127eb71da2b9f0d459 (diff) | |
| parent | eafe3435e99870d93c8b6adf457f4c4c9e050415 (diff) | |
Merge branch 'master' of git+ssh://git.taler.net/exchange
Diffstat (limited to 'src/exchangedb/0003-withdraw_age_commitments.sql')
| -rw-r--r-- | src/exchangedb/0003-withdraw_age_commitments.sql | 7 |
1 files changed, 3 insertions, 4 deletions
diff --git a/src/exchangedb/0003-withdraw_age_commitments.sql b/src/exchangedb/0003-withdraw_age_commitments.sql index f6f8b44d..1aac8bb2 100644 --- a/src/exchangedb/0003-withdraw_age_commitments.sql +++ b/src/exchangedb/0003-withdraw_age_commitments.sql @@ -36,7 +36,7 @@ BEGIN ',timestamp INT8 NOT NULL' ') %s ;' ,table_name - ,'PARTITION BY HASH (h_commitment)' + ,'PARTITION BY HASH (reserve_pub)' ,partition_suffix ); PERFORM comment_partitioned_table( @@ -96,9 +96,8 @@ BEGIN table_name = concat_ws('_', table_name, partition_suffix); EXECUTE FORMAT ( - 'CREATE INDEX ' || table_name || '_by_reserve_pub' - ' ON ' || table_name || - ' (reserve_pub);' + 'ALTER TABLE ' || table_name || + ' ADD PRIMARY KEY (h_commitment, reserve_pub);' ); EXECUTE FORMAT ( 'ALTER TABLE ' || table_name || |