aboutsummaryrefslogtreecommitdiff
path: root/contrib/lo/uninstall_lo.sql
blob: 7cbc796a3dec3d4d6bfd9b87ec502a4a9e0c6276 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
/* $PostgreSQL: pgsql/contrib/lo/uninstall_lo.sql,v 1.3 2007/11/13 04:24:28 momjian Exp $ */

-- Adjust this setting to control where the objects get dropped.
SET search_path = public;

--
-- This removes the LO type
-- It's used just for development
--

-- drop the type and associated 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