Index: openacs-4/packages/forums/tcl/forums-sc-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/tcl/forums-sc-procs-postgresql.xql,v
diff -u -r1.1 -r1.1.1.1
--- openacs-4/packages/forums/tcl/forums-sc-procs-postgresql.xql	1 Sep 2003 22:22:14 -0000	1.1
+++ openacs-4/packages/forums/tcl/forums-sc-procs-postgresql.xql	28 Jun 2006 20:30:28 -0000	1.1.1.1
@@ -15,17 +15,27 @@
 
     <fullquery name="forum::message::url.select_forums_package_url">
         <querytext>
-            select site_node__url(node_id)
+            select site_node__url(min(node_id))
             from site_nodes
             where object_id = (select package_id
                                from forums_forums
                                where forums_forums.forum_id = :forum_id)
         </querytext>
     </fullquery>
 
+    <fullquery name="forum::forum::url.select_forums_package_url">
+        <querytext>
+            select site_node__url(min(node_id))
+            from site_nodes
+            where object_id = (select package_id
+                               from forums_forums
+                               where forums_forums.forum_id = :forum_id)
+        </querytext>
+    </fullquery>
+
     <fullquery name="forum::message::datasource.messages">
       <querytext>
-        select subject, content, html_p
+        select subject, content, format
         from forums_messages
         where message_id=:message_id or (tree_sortkey between tree_left(:tree_sortkey) and tree_right(:tree_sortkey))
         and forum_id=:forum_id