 create unique index tt_i on tt(a);
 alter table tt replica identity using index tt_i;
 
+--
+-- Special objects to test DROP statements
+--
+
+CREATE SCHEMA droptest
+CREATE TABLE stuff (a serial PRIMARY KEY, the_object oid)
+CREATE TABLE ref_stuff (b serial PRIMARY KEY, a_fk int NOT NULL REFERENCES stuff);
+
+set search_path = droptest;
+CREATE TYPE the_types AS ENUM('harder','better','faster','stronger');
+
+CREATE FUNCTION return_the_types () RETURNS the_types LANGUAGE plpgsql AS
+$$ DECLARE res the_types ; BEGIN SELECT (('{harder,better,faster,stronger}'::text[])[round(random()*3+1)])::the_types into res; RETURN res; END $$
+;
+
+INSERT INTO stuff(the_object) VALUES (lo_create(0));
+
+
+
+-- TODO: move everything to a split filecrea
+
 -- 
 -- DROPs 
 --

	i _timestamptz(3),
	j time(4) with time zone,
	k timetz(3),
	l interval default '1 second'::interval,
	m interval year to month,
	n interval day to second,
	o interval second,

-- clean up
DROP EVENT TRIGGER snitch;

DROP TABLE ref_stuff CASCADE;
DROP TYPE the_types CASCADE;
DROP SCHEMA droptest CASCADE;
