From a200dd5979d7b8ff869891c459c37b90e674b5ce Mon Sep 17 00:00:00 2001 From: Christian Grothoff Date: Tue, 17 Oct 2023 12:14:46 +0200 Subject: minor clean ups --- src/exchangedb/0002-wad_out_entries.sql | 6 ------ 1 file changed, 6 deletions(-) (limited to 'src/exchangedb/0002-wad_out_entries.sql') diff --git a/src/exchangedb/0002-wad_out_entries.sql b/src/exchangedb/0002-wad_out_entries.sql index 8da0f04f7..de921637b 100644 --- a/src/exchangedb/0002-wad_out_entries.sql +++ b/src/exchangedb/0002-wad_out_entries.sql @@ -129,12 +129,6 @@ DECLARE BEGIN table_name = concat_ws('_', table_name, partition_suffix); - -- FIXME: change to materialized index by reserve_pub! - EXECUTE FORMAT ( - 'CREATE INDEX ' || table_name || '_by_reserve_pub ' - 'ON ' || table_name || ' ' - '(reserve_pub);' - ); EXECUTE FORMAT ( 'ALTER TABLE ' || table_name || ' ADD CONSTRAINT ' || table_name || '_wad_out_entry_serial_id_key' -- cgit v1.2.3