1-- This file and its contents are licensed under the Apache License 2.0. 2-- Please see the included NOTICE for copyright information and 3-- LICENSE-APACHE for a copy of the license. 4 5-- Clean up objects that are created by the setup files. Ideally, we 6-- should clean them up in each post.*.sql file after generating the 7-- output, but now we do it here. 8 9SELECT :'TEST_VERSION' >= '2.0.0' AS has_create_mat_view \gset 10 11SET client_min_messages TO WARNING; 12 13\if :has_create_mat_view 14DROP MATERIALIZED VIEW IF EXISTS mat_inval CASCADE; 15DROP MATERIALIZED VIEW IF EXISTS mat_drop CASCADE; 16DROP MATERIALIZED VIEW IF EXISTS mat_before CASCADE; 17DROP MATERIALIZED VIEW IF EXISTS mat_conflict CASCADE; 18DROP MATERIALIZED VIEW IF EXISTS mat_inttime CASCADE; 19DROP MATERIALIZED VIEW IF EXISTS mat_inttime2 CASCADE; 20DROP MATERIALIZED VIEW IF EXISTS mat_ignoreinval CASCADE; 21DROP MATERIALIZED VIEW IF EXISTS cagg.realtime_mat CASCADE; 22\else 23DROP VIEW IF EXISTS mat_inval CASCADE; 24DROP VIEW IF EXISTS mat_drop CASCADE; 25DROP VIEW IF EXISTS mat_before CASCADE; 26DROP VIEW IF EXISTS mat_conflict CASCADE; 27DROP VIEW IF EXISTS mat_inttime CASCADE; 28DROP VIEW IF EXISTS mat_inttime2 CASCADE; 29DROP VIEW IF EXISTS mat_ignoreinval CASCADE; 30DROP VIEW IF EXISTS cagg.realtime_mat CASCADE; 31\endif 32 33DROP TABLE IF EXISTS public.hyper_timestamp; 34DROP TABLE IF EXISTS public."two_Partitions"; 35DROP TABLE IF EXISTS conditions_before; 36DROP TABLE IF EXISTS inval_test; 37DROP TABLE IF EXISTS int_time_test; 38DROP TABLE IF EXISTS conflict_test; 39DROP TABLE IF EXISTS drop_test; 40DROP TABLE IF EXISTS repair_test_timestamptz; 41DROP TABLE IF EXISTS repair_test_int; 42DROP TABLE IF EXISTS repair_test_extra; 43DROP TABLE IF EXISTS repair_test_timestamp; 44DROP TABLE IF EXISTS repair_test_date; 45DROP TABLE IF EXISTS compress; 46DROP TABLE IF EXISTS devices; 47DROP TABLE IF EXISTS disthyper; 48DROP TABLE IF EXISTS policy_test_timestamptz; 49 50DROP TYPE IF EXISTS custom_type; 51DROP TYPE IF EXISTS custom_type_for_compression; 52 53DROP PROCEDURE IF EXISTS _timescaledb_testing.restart_dimension_slice_id; 54DROP PROCEDURE IF EXISTS _timescaledb_testing.stop_workers; 55 56DROP FUNCTION IF EXISTS timescaledb_integrity_test; 57DROP FUNCTION IF EXISTS timescaledb_catalog_has_no_missing_columns; 58DROP FUNCTION IF EXISTS integer_now_test; 59 60DROP SCHEMA IF EXISTS cagg; 61DROP SCHEMA IF EXISTS _timescaledb_testing; 62 63 64RESET client_min_messages; 65