Index: openacs-4/packages/file-storage/www/view/index-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/www/view/index-postgresql.xql,v diff -u -r1.1.4.2 -r1.1.4.3 --- openacs-4/packages/file-storage/www/view/index-postgresql.xql 6 Mar 2005 10:26:40 -0000 1.1.4.2 +++ openacs-4/packages/file-storage/www/view/index-postgresql.xql 6 Mar 2005 11:09:31 -0000 1.1.4.3 @@ -21,7 +21,9 @@ and i.parent_id = (select item_id from cr_items where name = :item_url_folder - limit 1) + and parent_id = (select item_id + from cr_items + where name = :item_url_parent_folder)) order by revision_id desc limit 1