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