Index: openacs-4/packages/file-storage/tcl/file-storage-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/tcl/file-storage-procs-postgresql.xql,v
diff -u -r1.38.2.1 -r1.38.2.2
--- openacs-4/packages/file-storage/tcl/file-storage-procs-postgresql.xql	26 May 2004 18:13:03 -0000	1.38.2.1
+++ openacs-4/packages/file-storage/tcl/file-storage-procs-postgresql.xql	21 Jul 2004 22:37:18 -0000	1.38.2.2
@@ -129,6 +129,22 @@
         </querytext>
     </fullquery>
 
+    <fullquery name="fs::do_notifications.get_owner_name">
+        <querytext>
+	  select person__name(o.creation_user) as owner from
+          acs_objects o where o.object_id = :file_id
+        </querytext>
+    </fullquery>
+
+    <fullquery name="fs::do_notifications.path1">
+       <querytext>
+		select site_node__url(node_id) as path1 from site_nodes
+		       where object_id = (select package_id
+						 from fs_root_folders where
+						 fs_root_folders.folder_id = :root_folder)
+       </querytext>
+    </fullquery>
+
     <fullquery name="fs::publish_versioned_object_to_file_system.select_object_content">
         <querytext>
             select lob