diff options
author | Marco Boss <bossm8@bfh.ch> | 2022-04-02 13:42:00 +0200 |
---|---|---|
committer | Marco Boss <bossm8@bfh.ch> | 2022-04-02 13:42:00 +0200 |
commit | 5880a8ec4faa75e1eb5ed80dd36ae978b9a1e54f (patch) | |
tree | 69ade4ffb1fc02c8e995651d475d1e2cf3932efd /src/exchangedb | |
parent | f596b27a97dd649664f624d7f72cd52b7f56e043 (diff) | |
download | exchange-5880a8ec4faa75e1eb5ed80dd36ae978b9a1e54f.tar.xz |
drop functions
Diffstat (limited to 'src/exchangedb')
-rw-r--r-- | src/exchangedb/common-0001.sql | 5 | ||||
-rw-r--r-- | src/exchangedb/drop0001.sql | 3 |
2 files changed, 5 insertions, 3 deletions
diff --git a/src/exchangedb/common-0001.sql b/src/exchangedb/common-0001.sql index 096980879..20fddd499 100644 --- a/src/exchangedb/common-0001.sql +++ b/src/exchangedb/common-0001.sql @@ -1583,7 +1583,7 @@ BEGIN ); EXECUTE FORMAT( - 'ALTER FOREIGN TABLE %I OWNER TO %L' + 'ALTER FOREIGN TABLE %I OWNER TO %I' ,source_table_name || '_' || shard_suffix ,local_user ); @@ -1698,7 +1698,7 @@ LANGUAGE plpgsql AS $$ BEGIN - RAISE NOTICE 'Creating server %s', remote_host; + RAISE NOTICE 'Creating server %', remote_host; EXECUTE FORMAT( 'CREATE SERVER IF NOT EXISTS %I ' @@ -1907,6 +1907,7 @@ BEGIN ,'taler-exchange-httpd' ); END LOOP; + END $$; diff --git a/src/exchangedb/drop0001.sql b/src/exchangedb/drop0001.sql index 364578515..ab0e75234 100644 --- a/src/exchangedb/drop0001.sql +++ b/src/exchangedb/drop0001.sql @@ -149,8 +149,9 @@ DROP FUNCTION IF EXISTS create_table_partition; DROP FUNCTION IF EXISTS create_partitions; DROP FUNCTION IF EXISTS detach_default_partitions; DROP FUNCTION IF EXISTS drop_default_partitions; -DROP FUNCTION IF EXISTS master_prepare_sharding; +DROP FUNCTION IF EXISTS prepare_sharding; DROP FUNCTION IF EXISTS create_foreign_table; +DROP FUNCTION IF EXISTS create_foreign_servers; DROP FUNCTION IF EXISTS create_shard_server; |