Index: openacs-4/contrib/packages/bcms/tcl/bcms-item-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/bcms/tcl/bcms-item-procs-postgresql.xql,v
diff -u -r1.10 -r1.11
--- openacs-4/contrib/packages/bcms/tcl/bcms-item-procs-postgresql.xql	17 Dec 2003 03:50:05 -0000	1.10
+++ openacs-4/contrib/packages/bcms/tcl/bcms-item-procs-postgresql.xql	9 Feb 2004 14:42:28 -0000	1.11
@@ -12,7 +12,7 @@
                                 :item_id,               -- item_id
                                 null,                   -- locale
                                 now(),                  -- creation_date
-                                :creation_user_id,      -- creation_user
+                                :creation_user,      -- creation_user
                                 :parent_id,             -- context_id
                                 :creation_ip,           -- creation_ip
                                 'content_revision',     -- item_subtype
@@ -44,7 +44,7 @@
                                 i.content_type, 
                                 i.storage_type,
                                 i.tree_sortkey,
-                                to_char(last_modified,'YYYY-MM-DD HH:MM AM') as last_modified
+                                to_char(last_modified,'YYYY-MM-DD HH24:MM:SS') as last_modified
                                 $addtnl_select
                         from cr_items i, cr_revisionsx r
                                 $addtnl_from
@@ -137,7 +137,7 @@
                             :parent_id,         -- parent_id
                             null,               -- symlink_id
                             now(),              -- creation_date
-                            :creation_user_id,  -- creation_user_id
+                            :creation_user,  -- creation_user
                             :creation_ip        -- creation_ip
             )
         </querytext>
@@ -207,7 +207,7 @@
     <fullquery name="bcms::item::get_item_path.get_item_path">
          <querytext>
             (select i.item_id, :prepend_path as path, 
-                case when i.content_type = 'content_folder' then content_folder__get_label(i.item_id) else bcms__get_title(i.item_id, 'latest') end as title
+                coalesce(:root_title, case when i.content_type = 'content_folder' then content_folder__get_label(i.item_id) else bcms__get_title(i.item_id, 'latest') end) as title
             from cr_items i where item_id = :root_id)
 
             union