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.15 -r1.16 --- openacs-4/packages/file-storage/tcl/file-storage-procs-postgresql.xql 4 Mar 2002 18:26:03 -0000 1.15 +++ openacs-4/packages/file-storage/tcl/file-storage-procs-postgresql.xql 13 Mar 2002 21:17:12 -0000 1.16 @@ -38,7 +38,10 @@ fs_folders_and_files.live_revision, fs_folders_and_files.type, to_char(fs_folders_and_files.last_modified, 'YYYY-MM-DD HH24:MI') as last_modified, - fs_folders_and_files.content_size + fs_folders_and_files.content_size, + case when acs_permission__permission_p(fs_folders_and_files, :user_id, 'write') = 'f' then 0 else 1 end as write_p, + case when acs_permission__permission_p(fs_folders_and_files, :user_id, 'delete') = 'f' then 0 else 1 end as delete_p, + case when acs_permission__permission_p(fs_folders_and_files, :user_id, 'admin') = 'f' then 0 else 1 end as admin_p from fs_folders_and_files where fs_folders_and_files.parent_id = :folder_id and 't' = acs_permission__permission_p(fs_folders_and_files.file_id, :user_id, 'read')