blob: d7f34f8bed5e5e8f4e3a5f553e7dc3e9b070ff11 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
--
-- This removes the type (and a test table)
-- It's used just for development
--
-- Adjust this setting to control where the objects get created.
SET search_path = public;
SET autocommit TO 'on';
-- remove our test table
DROP TABLE a;
-- now drop the type and associated C functions
DROP TYPE lo CASCADE;
-- the trigger function has no dependency on the type, so drop separately
DROP FUNCTION lo_manage();
-- the lo stuff is now removed from the system
|