diff options
author | Christian Grothoff <christian@grothoff.org> | 2022-11-27 18:40:44 +0100 |
---|---|---|
committer | Christian Grothoff <christian@grothoff.org> | 2022-11-27 18:40:44 +0100 |
commit | f2ba02aab2b9bbd976107ecc4ac7e7d657a9d73a (patch) | |
tree | 2b573c5ec895fbca1663a9e0efa6102890f68bbc /src/exchangedb/0002-wire_targets.sql | |
parent | bbf3e6fe03f1f9f8c7d342004f65bab9f7b1b91c (diff) | |
download | exchange-f2ba02aab2b9bbd976107ecc4ac7e7d657a9d73a.tar.xz |
more sql refactoring
Diffstat (limited to 'src/exchangedb/0002-wire_targets.sql')
-rw-r--r-- | src/exchangedb/0002-wire_targets.sql | 10 |
1 files changed, 4 insertions, 6 deletions
diff --git a/src/exchangedb/0002-wire_targets.sql b/src/exchangedb/0002-wire_targets.sql index 08bc468d3..afb9197af 100644 --- a/src/exchangedb/0002-wire_targets.sql +++ b/src/exchangedb/0002-wire_targets.sql @@ -14,7 +14,7 @@ -- TALER; see the file COPYING. If not, see <http://www.gnu.org/licenses/> -- -CREATE OR REPLACE FUNCTION create_table_wire_targets( +CREATE FUNCTION create_table_wire_targets( IN shard_suffix VARCHAR DEFAULT NULL ) RETURNS VOID @@ -22,7 +22,7 @@ LANGUAGE plpgsql AS $$ BEGIN PERFORM create_partitioned_table( - 'CREATE TABLE IF NOT EXISTS %I' + 'CREATE TABLE %I' '(wire_target_serial_id BIGINT GENERATED BY DEFAULT AS IDENTITY' ',wire_target_h_payto BYTEA PRIMARY KEY CHECK (LENGTH(wire_target_h_payto)=32)' ',payto_uri VARCHAR NOT NULL' @@ -47,12 +47,10 @@ BEGIN ,'wire_target_h_payto' ,shard_suffix ); - -END -$$; +END $$; -CREATE OR REPLACE FUNCTION constrain_table_wire_targets( +CREATE FUNCTION constrain_table_wire_targets( IN partition_suffix VARCHAR ) RETURNS void |