Index: openacs-4/packages/ref-currency/ref-currency.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ref-currency/ref-currency.info,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/ref-currency/ref-currency.info	11 Dec 2003 21:40:11 -0000	1.6
+++ openacs-4/packages/ref-currency/ref-currency.info	12 Mar 2005 19:27:36 -0000	1.7
@@ -7,7 +7,7 @@
     <initial-install-p>f</initial-install-p>
     <singleton-p>t</singleton-p>
 
-    <version name="0.1d" url="http://www.mayuli.com/acs-repository/download/apm/ref-currency-0.1d.apm">
+    <version name="0.2d" url="http://www.mayuli.com/acs-repository/download/apm/ref-currency-0.2d.apm">
     <database-support>
         <database>oracle</database>
         <database>postgresql</database>
@@ -18,7 +18,7 @@
         <description format="text/plain">This is the currency sub-module for acs-reference.
 It provides ISO 4217 compatibility.</description>
 
-        <provides url="ref-currency" version="0.1d"/>
+        <provides url="ref-currency" version="0.2d"/>
         <requires url="acs-kernel" version="4.6.2"/>
         <requires url="acs-reference" version="0.1d"/>
         <requires url="ref-countries" version="0.1d"/>
Index: openacs-4/packages/ref-currency/sql/postgresql/ref-currency-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ref-currency/sql/postgresql/ref-currency-drop.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/ref-currency/sql/postgresql/ref-currency-drop.sql	15 Sep 2001 01:04:22 -0000	1.1
+++ openacs-4/packages/ref-currency/sql/postgresql/ref-currency-drop.sql	12 Mar 2005 19:27:36 -0000	1.2
@@ -10,12 +10,12 @@
 -- This will probably fail if their is a child table using this.
 -- I can probably make this cleaner also, but ... no time today
 
-create function inline_0() returns integer as '
+create or replace function inline_0() returns integer as '
 declare
     rec        acs_reference_repositories%ROWTYPE;
 begin
     for rec in select * from acs_reference_repositories where upper(table_name) like ''CURRENC%'' loop
-	 execute ''drop table '' || rec.table_name;
+	 execute ''drop table '' || rec.table_name || '' cascade'';
          perform acs_reference__delete(rec.repository_id);
     end loop;
     return 0;