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 -N -r1.55 -r1.56
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql	10 Feb 2009 18:31:54 -0000	1.55
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql	2 Apr 2009 22:31:13 -0000	1.56
@@ -470,7 +470,8 @@
   -- lob_id if storage_type = lob.
   lob             integer
                   constraint cr_revisions_lob_fk
-                  references lobs,
+                  references lobs
+                  on delete set null,
   -- content holds the file name if storage type = file
   -- otherwise it holds the text data if storage_type = text.
   content	  text,