Index: openacs-4/packages/bookmarks/tcl/bookmarks-init-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bookmarks/tcl/bookmarks-init-postgresql.xql,v diff -u -r1.4 -r1.5 --- openacs-4/packages/bookmarks/tcl/bookmarks-init-postgresql.xql 21 Dec 2002 22:29:50 -0000 1.4 +++ openacs-4/packages/bookmarks/tcl/bookmarks-init-postgresql.xql 25 Sep 2003 17:08:22 -0000 1.5 @@ -14,31 +14,6 @@ - - - - - select b.bookmark_id, - b.url_id, - b.local_title, - acs_objects.creation_date, - b.parent_id, - bm_urls.complete_url, - b.folder_p - from (select bm.bookmark_id, bm.url_id, bm.local_title, bm.folder_p, - bm.parent_id, bm.owner_id, bm.tree_sortkey from bm_bookmarks bm, bm_bookmarks bm2 - where bm2.bookmark_id = :root_folder_id - and bm.tree_sortkey between bm2.tree_sortkey and tree_right(bm2.tree_sortkey) - ) b left join bm_urls using (url_id), - acs_objects - where owner_id = :user_id - and acs_objects.object_id = b.bookmark_id - order by b.tree_sortkey - - - - - delete from bm_in_closed_p where creation_date < (current_timestamp - interval '1 day')