From f2ba02aab2b9bbd976107ecc4ac7e7d657a9d73a Mon Sep 17 00:00:00 2001 From: Christian Grothoff Date: Sun, 27 Nov 2022 18:40:44 +0100 Subject: more sql refactoring --- src/exchangedb/0002-history_requests.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'src/exchangedb/0002-history_requests.sql') diff --git a/src/exchangedb/0002-history_requests.sql b/src/exchangedb/0002-history_requests.sql index 978dea640..a8dbeb6a7 100644 --- a/src/exchangedb/0002-history_requests.sql +++ b/src/exchangedb/0002-history_requests.sql @@ -15,7 +15,7 @@ -- -CREATE OR create_table_history_requests( +CREATE FUNCTION create_table_history_requests( IN shard_suffix VARCHAR DEFAULT NULL ) RETURNS VOID @@ -64,7 +64,7 @@ BEGIN END $$; -CREATE OR foreign_table_history_requests() +CREATE FUNCTION foreign_table_history_requests() RETURNS VOID LANGUAGE plpgsql AS $$ -- cgit v1.2.3