Index: openacs-4/contrib/obsolete-packages/bboard-portlets/sql/postgresql/bboard-portlets-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/bboard-portlets/sql/postgresql/bboard-portlets-drop.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/contrib/obsolete-packages/bboard-portlets/sql/postgresql/bboard-portlets-drop.sql	28 Aug 2003 09:41:52 -0000	1.3
@@ -0,0 +1,37 @@
+--
+-- packages/bboard-portlets/sql/bboard-portlets-drop.sql
+--
+
+-- Drops bboard datasources for portal portlets
+
+-- Copyright (C) 2001 ArsDigita Corporation 
+-- @author Michael Bryzek (mbryzek@arsdigita.com)
+-- @creation-date 2001-02-26
+
+-- $Id: bboard-portlets-drop.sql,v 1.3 2003/08/28 09:41:52 lars Exp $
+
+-- This is free software distributed under the terms of the GNU Public
+-- License.  Full text of the license is available from the GNU Project:
+-- http://www.fsf.org/copyleft/gpl.html
+
+declare  
+  ds_id portal_datasources.datasource_id%TYPE;
+begin
+
+  begin 
+    select datasource_id into ds_id
+      from portal_datasources
+     where name = 'Summarize bboard applications'
+       and package_key = 'bboard';
+   exception when no_data_found then
+     ds_id := null;
+  end;
+
+  if ds_id is not null then
+    portal_datasource.delete(ds_id);
+  end if;
+
+end;
+/
+show errors;
+