text: -- Copyright (c) 2016-2018  Timescale, Inc. All Rights Reserved.
  --
  -- This file is licensed under the Apache License,
  -- see LICENSE-APACHE at the top level directory.
  
  CREATE TABLE drop_test(time timestamp, temp float8, device text);
  
  SELECT create_hypertable('drop_test', 'time', 'device', 2);
  SELECT * FROM _timescaledb_catalog.hypertable;
  INSERT INTO drop_test VALUES('Mon Mar 20 09:17:00.936242 2017', 23.4, 'dev1');
  SELECT * FROM drop_test;
  
  \c single :ROLE_SUPERUSER
  DROP EXTENSION timescaledb CASCADE;
  \c single :ROLE_DEFAULT_PERM_USER
  
  -- Querying the original table should not return any rows since all of
  -- them actually existed in chunks that are now gone
  SELECT * FROM drop_test;
  
  \c single :ROLE_SUPERUSER
  -- Recreate the extension
  SET client_min_messages=error;
  CREATE EXTENSION timescaledb;
  RESET client_min_messages;
  
  -- Test that calling twice generates proper error
  \set ON_ERROR_STOP 0
  CREATE EXTENSION timescaledb;
  \set ON_ERROR_STOP 1
  \c single :ROLE_DEFAULT_PERM_USER
  
  -- CREATE twice with IF NOT EXISTS should be OK
  CREATE EXTENSION IF NOT EXISTS timescaledb;
  
  -- Make the table a hypertable again
  SELECT create_hypertable('drop_test', 'time', 'device', 2);
  
  SELECT * FROM _timescaledb_catalog.hypertable;
  INSERT INTO drop_test VALUES('Mon Mar 20 09:18:19.100462 2017', 22.1, 'dev1');
  SELECT * FROM drop_test;
  
  --test drops thru cascades of other objects
  \c single :ROLE_SUPERUSER
  
  drop schema public cascade;
  \dn
  