Index: openacs-4/packages/dotlrn/sql/postgresql/dotlrn-main-portlet-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/postgresql/Attic/dotlrn-main-portlet-drop.sql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/dotlrn/sql/postgresql/dotlrn-main-portlet-drop.sql	2 Jul 2002 19:53:51 -0000	1.4
+++ openacs-4/packages/dotlrn/sql/postgresql/dotlrn-main-portlet-drop.sql	3 Jul 2002 19:58:07 -0000	1.5
@@ -85,21 +85,25 @@
         ''dotlrn_main_portlet''
     );
 
-  begin 
+    begin
     select datasource_id into ds_id
       from portal_datasources
      where name = ''dotlrn-main-portlet'';
-   exception when no_data_found then
-     ds_id := null;
-  end;
+-- cant seem to get the exception working properly.. 
+-- is it really necessary here?  look into it later.  -dan chak 2002-07-02
+--    exception when no_data_found then
+--        ds_id := null;
+    end;
 
   if ds_id is not null then
     portal_datasource__delete(ds_id);
   end if;
+  
+  return 0;
 
 end;
 ' language 'plpgsql';
 
 select inline_0();
-delete function inline_0();
+drop function inline_0();
 
