Index: openacs-4/packages/cms/www/modules/templates/template.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/cms/www/modules/templates/template.tcl,v
diff -u -N -r1.4 -r1.5
--- openacs-4/packages/cms/www/modules/templates/template.tcl	20 Aug 2002 04:18:00 -0000	1.4
+++ openacs-4/packages/cms/www/modules/templates/template.tcl	22 Aug 2002 03:04:32 -0000	1.5
@@ -33,27 +33,8 @@
 
 
 # get the context bar info
-# FIXME: postgresql query needs to be fixed
-template::query get_context context multirow "select
-      t.tree_level, t.context_id, content_item.get_title(t.context_id) as title
-    from (
-      select 
-        context_id, level as tree_level
-      from 
-        acs_objects
-      where
-        context_id <> 0
-      connect by
-        prior context_id = object_id
-      start with
-        object_id = :template_id
-      ) t, cr_items i
-    where
-      i.item_id = t.context_id
-    order by
-      tree_level desc"
+db_multirow context get_context ""
 
-
 # find out which items this template is registered to
 db_multirow items get_items ""