From b663f3443ba096a06970214c3e83e79f6e570b84 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Thu, 22 Aug 2002 00:01:51 +0000 Subject: Add a bunch of pseudo-types to replace the behavior formerly associated with OPAQUE, as per recent pghackers discussion. I still want to do some more work on the 'cstring' pseudo-type, but I'm going to commit the bulk of the changes now before the tree starts shifting under me ... --- contrib/lo/lo_drop.sql | 12 +++--------- 1 file changed, 3 insertions(+), 9 deletions(-) (limited to 'contrib/lo/lo_drop.sql') diff --git a/contrib/lo/lo_drop.sql b/contrib/lo/lo_drop.sql index 2472715a3d..4e4602836c 100644 --- a/contrib/lo/lo_drop.sql +++ b/contrib/lo/lo_drop.sql @@ -6,16 +6,10 @@ -- 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 and associated C functions +drop type lo CASCADE; --- 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); +-- 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 -- cgit v1.2.1