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.6 -r1.7
--- openacs-4/contrib/packages/bcms/tcl/bcms-item-procs-postgresql.xql	5 Oct 2003 12:28:03 -0000	1.6
+++ openacs-4/contrib/packages/bcms/tcl/bcms-item-procs-postgresql.xql	14 Oct 2003 14:58:31 -0000	1.7
@@ -162,7 +162,7 @@
 
         <fullquery name="bcms::item::get_item_best.get_1item">
                 <querytext>
-                        select name, parent_id, storage_type, content_type, storage_type, publish_status,
+                        select item_id, name, parent_id, storage_type, content_type, storage_type, publish_status,
                         revision_id, title, content, description, publish_date, mime_type
                     from cr_items i, cr_revisions r where
                                 i.item_id = r.item_id
@@ -180,7 +180,7 @@
         </querytext>
     </fullquery>
 
-        <fullquery name="bcms::item::get_item_by_url.get_item_id">
+        <fullquery name="bcms::item::get_item_id_by_url.get_item_id">
                 <querytext>
                         select content_item__get_id(:url, :root_id, :resolve_index);
                 </querytext>