--
-- destroy.source
--
-- $Header: /cvsroot/pgsql/src/test/regress/Attic/destroy.source,v 1.1.1.1 1996/07/09 06:22:24 scrappy Exp $
--

--
-- this will fail if the user is not the postgres superuser.
-- if it does, don't worry about it (you can turn usersuper
-- back on as "postgres").  too many people don't follow 
-- directions and run this as "postgres", though...
--
UPDATE pg_user
   SET usesuper = 't'::bool
   WHERE usename = '_USER_';


--
-- FUNCTION REMOVAL
--
DROP FUNCTION hobbies(person);

DROP FUNCTION hobby_construct(text,text);

DROP FUNCTION equipment(hobbies_r);

DROP FUNCTION user_relns();

DROP FUNCTION circle_in(opaque);

DROP FUNCTION circle_out(opaque);

DROP FUNCTION pt_in_circle(point,circle);

DROP FUNCTION overpaid(emp);

DROP FUNCTION boxarea(box);

DROP FUNCTION interpt_pp(path,path);

DROP FUNCTION reverse_c16(char16);


--
-- OPERATOR REMOVAL
--
DROP OPERATOR ## (path, path);

DROP OPERATOR <% (point, circle);

-- left unary 
DROP OPERATOR @#@ (none, int4);

-- right unary 
DROP OPERATOR #@# (int4, none);	

-- right unary 
DROP OPERATOR #%# (int4, none);	


--
-- ABSTRACT DATA TYPE REMOVAL
--
DROP TYPE city_budget;

DROP TYPE circle;


--
-- RULE REMOVAL
--	(is also tested in queries.source)
--

--
-- AGGREGATE REMOVAL
--
DROP AGGREGATE newavg;

DROP AGGREGATE newsum;

DROP AGGREGATE newcnt;


--
-- CLASS REMOVAL
--	(inheritance hierarchies are deleted in reverse order)
--

--
-- DROP ancillary data structures (i.e. indices)
--
DROP INDEX onek_unique1;

DROP INDEX onek_unique2;

DROP INDEX onek_hundred;

DROP INDEX onek_stringu1;

DROP INDEX tenk1_unique1;

DROP INDEX tenk1_unique2;

DROP INDEX tenk1_hundred;

DROP INDEX tenk2_unique1;

DROP INDEX tenk2_unique2;

DROP INDEX tenk2_hundred;

-- DROP INDEX onek2_u1_prtl;

-- DROP INDEX onek2_u2_prtl;

-- DROP INDEX onek2_stu1_prtl;

DROP INDEX rect2ind;

DROP INDEX rix;

DROP INDEX iix;

DROP INDEX six;

DROP INDEX hash_i4_index;

DROP INDEX hash_c16_index;

DROP INDEX hash_txt_index;

DROP INDEX hash_f8_index;

-- DROP INDEX hash_ovfl_index;

DROP INDEX bt_i4_index;

DROP INDEX bt_c16_index;

DROP INDEX bt_txt_index;

DROP INDEX bt_f8_index;


DROP TABLE  onek;

DROP TABLE  onek2;

DROP TABLE  tenk1;

DROP TABLE  tenk2;

DROP TABLE  Bprime;


DROP TABLE  hobbies_r;

DROP TABLE  equipment_r;


DROP TABLE  aggtest;

DROP TABLE  xacttest;

DROP TABLE  arrtest;

DROP TABLE  iportaltest;


DROP TABLE  f_star;

DROP TABLE  e_star;

DROP TABLE  d_star;

DROP TABLE  c_star;

DROP TABLE  b_star;

DROP TABLE  a_star;


--
-- must be in reverse inheritance order
--
DROP TABLE  stud_emp;

DROP TABLE  student;

DROP TABLE  slow_emp4000;

DROP TABLE  fast_emp4000;

DROP TABLE  emp;

DROP TABLE  person;


DROP TABLE  ramp;

DROP TABLE  real_city;

DROP TABLE  dept;

DROP TABLE  ihighway;

DROP TABLE  shighway;

DROP TABLE  road;

DROP TABLE  city;


DROP TABLE  hash_i4_heap;

DROP TABLE  hash_c16_heap;

DROP TABLE  hash_txt_heap;

DROP TABLE  hash_f8_heap;

-- DROP TABLE  hash_ovfl_heap;

DROP TABLE  bt_i4_heap;

DROP TABLE  bt_c16_heap;

DROP TABLE  bt_txt_heap;

DROP TABLE  bt_f8_heap;


DROP TABLE  BOOLTBL1;

DROP TABLE  BOOLTBL2;

DROP TABLE  ABSTIME_TBL;

DROP TABLE  RELTIME_TBL;

DROP TABLE  TINTERVAL_TBL;

DROP TABLE  BOX_TBL;

DROP TABLE  CHAR_TBL;

DROP TABLE  CHAR2_TBL;

DROP TABLE  CHAR4_TBL;

DROP TABLE  CHAR8_TBL;

DROP TABLE  CHAR16_TBL;

DROP TABLE  FLOAT4_TBL;

DROP TABLE  FLOAT8_TBL;

DROP TABLE  INT2_TBL;

DROP TABLE  INT4_TBL;

DROP TABLE  OID_TBL;

DROP TABLE  OIDNAME_TBL;

DROP TABLE  OIDINT2_TBL;

DROP TABLE  OIDINT4_TBL;

DROP TABLE  POINT_TBL;

DROP TABLE  POLYGON_TBL;


--
-- VIRTUAL CLASS REMOVAL
--	(also tests removal of rewrite rules)
--
DROP VIEW street;

DROP VIEW iexit;

DROP VIEW toyemp;

