Index: openacs-4/packages/bookmarks/sql/postgresql/bookmarks-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bookmarks/sql/postgresql/bookmarks-create.sql,v
diff -u -r1.12 -r1.13
--- openacs-4/packages/bookmarks/sql/postgresql/bookmarks-create.sql	30 Jul 2001 00:00:02 -0000	1.12
+++ openacs-4/packages/bookmarks/sql/postgresql/bookmarks-create.sql	28 Sep 2001 03:33:52 -0000	1.13
@@ -101,8 +101,11 @@
 
 
 -- For connect by queries
-create index bm_bookmarks_idx1 on bm_bookmarks(bookmark_id, parent_id);
-create index bm_bookmarks_idx2 on bm_bookmarks(parent_id, bookmark_id);
+-- Replace oracle indexes:
+-- create index bm_bookmarks_idx1 on bm_bookmarks(bookmark_id, parent_id);
+-- create index bm_bookmarks_idx2 on bm_bookmarks(parent_id, bookmark_id);
+-- With index on tree_sortkey
+create index bm_bookmarks_idx1 on bm_bookmarks(tree_sortkey);
 
 create function bm_bookmarks_insert_tr () returns opaque as '
 declare