diff options
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 |