Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-type.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-type.sql,v
diff -u -r1.11 -r1.12
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-type.sql	2 Apr 2001 05:35:29 -0000	1.11
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-type.sql	3 Apr 2001 12:10:22 -0000	1.12
@@ -152,12 +152,11 @@
 
   -- we''ll remove the associated table if it exists
   select 
-    count(*) > 0 into table_exists 
+    table_exists(lower(table_name)) into table_exists 
   from 
-    user_tables u, acs_object_types objet
+    acs_object_types
   where 
-    objet.object_type = drop_type__content_type and
-    u.table_name = upper(objet.table_name);
+    object_type = drop_type__content_type;
 
   if table_exists and content_type__drop_table_p then
     select