Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql,v
diff -u -r1.14 -r1.15
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql	1 May 2001 04:37:49 -0000	1.14
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql	3 May 2001 04:00:49 -0000	1.15
@@ -397,7 +397,7 @@
   nls_language    varchar(50),
   storage_type    varchar(10) not null,
   -- lob_id if storage_type = lob.
-  lob             integer,
+  lob             integer references lobs,
   -- content holds the file name if storage type = file
   -- otherwise it holds the text data if storage_type = text.
   content	  text,
@@ -415,10 +415,7 @@
         from cr_items
         where item_id = new.item_id;
 
-        if (v_storage_type <> new.storage_type) or
-           (v_storage_type = ''lob'' and new.lob is null) or
-           ((v_storage_type = ''text'' or v_storage_type = ''file'') and
-            new.content is null) then
+        if v_storage_type <> new.storage_type then
 
            raise EXCEPTION ''Invalid storage type: % for revision_id = %'', new.storage_type, new.revision_id;