Index: openacs-4/packages/file-storage/www/version-add-2-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/www/Attic/version-add-2-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/file-storage/www/version-add-2-postgresql.xql	17 Aug 2001 01:25:08 -0000	1.1
+++ openacs-4/packages/file-storage/www/version-add-2-postgresql.xql	25 Aug 2001 00:36:50 -0000	1.2
@@ -9,8 +9,13 @@
     	select content_revision__new (
         	:name,		-- title
         	:description,	-- description
+		now(),		-- publish_date (default)
         	:mime_type,	-- mime_type
+		null,		-- nls_language (default)
+		null,		-- data (default)
         	:file_id,	-- item_id
+		null,		-- rvision_id (default)
+		now(),		-- creation_date (default)
         	:user_id,	-- creation_user
         	:ip_addr	-- creation_ip
     		);
@@ -23,9 +28,8 @@
       <querytext>
 
 	update cr_revisions
-	set    content = empty_blob()
+ 	set lob = [set __lob_id [db_string get_lob_id "select empty_lob()"]]
 	where  revision_id = :revision_id
-	returning content into :1
 
       </querytext>
 </fullquery>