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.25 -r1.26
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-type.sql	6 Jan 2003 17:07:49 -0000	1.25
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-type.sql	11 Feb 2003 10:28:35 -0000	1.26
@@ -619,7 +619,7 @@
 
 
 -- procedure refresh_view
-create function content_type__refresh_view (varchar)
+create or replace function content_type__refresh_view (varchar)
 returns integer as '
 declare
   refresh_view__content_type           alias for $1;  
@@ -659,6 +659,10 @@
   select table_name into v_table_name from acs_object_types
     where object_type = refresh_view__content_type;
 
+  if length(v_table_name) > 25 then
+      raise exception ''Table name cannot be longer than 25 characters, because that causes conflicting rules when we create the views.'';
+  end if;
+
   -- create the input view (includes content columns)
 
   if table_exists(v_table_name || ''i'') then