diff options
Diffstat (limited to 'contrib/lo/drop.sql')
| -rw-r--r-- | contrib/lo/drop.sql | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/contrib/lo/drop.sql b/contrib/lo/drop.sql new file mode 100644 index 00000000000..2472715a3d5 --- /dev/null +++ b/contrib/lo/drop.sql @@ -0,0 +1,21 @@ +-- +-- This removes the type (and a test table) +-- It's used just for development +-- + +-- remove our test table +drop table a; + +-- now drop any sql based functions associated with the lo type +drop function oid(lo); + +-- now drop the type +drop type lo; + +-- as the type is gone, remove the C based functions +drop function lo_in(opaque); +drop function lo_out(opaque); +drop function lo(oid); +drop function lo_manage(); + +-- the lo stuff is now removed from the system |