summaryrefslogtreecommitdiff
path: root/contrib/lo/lo_drop.sql
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2005-06-23 00:06:37 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2005-06-23 00:06:37 +0000
commit5b0c9d3603b027e022b8a0ebd4c492469a5d1633 (patch)
treea6cf50fa8f63616d4889c869814ed205f6216faa /contrib/lo/lo_drop.sql
parentd20763dbee7cdf8a700bf6bdd120b3913a3b99f4 (diff)
downloadpostgresql-5b0c9d3603b027e022b8a0ebd4c492469a5d1633.tar.gz
Cleanup the contrib/lo module: there is no need anymore to implement
a physically separate type. Defining 'lo' as a domain over OID works just fine and is more efficient. Improve documentation and fix up the test script. (Would like to turn test script into a proper regression test, but right now its output is not constant because of numeric OIDs; plus it makes Unix-specific assumptions about files it can import.)
Diffstat (limited to 'contrib/lo/lo_drop.sql')
-rw-r--r--contrib/lo/lo_drop.sql7
1 files changed, 2 insertions, 5 deletions
diff --git a/contrib/lo/lo_drop.sql b/contrib/lo/lo_drop.sql
index c6c491b2c1..de0281fabd 100644
--- a/contrib/lo/lo_drop.sql
+++ b/contrib/lo/lo_drop.sql
@@ -1,15 +1,12 @@
--
--- This removes the type (and a test table)
+-- This removes the LO type
-- It's used just for development
--
-- Adjust this setting to control where the objects get created.
SET search_path = public;
--- remove our test table
-DROP TABLE a;
-
--- now drop the type and associated C functions
+-- drop the type and associated functions
DROP TYPE lo CASCADE;
-- the trigger function has no dependency on the type, so drop separately