mirror of https://github.com/postgres/postgres
You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
22 lines
459 B
22 lines
459 B
26 years ago
|
--
|
||
|
|
-- 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
|