Index: openacs-4/packages/forums/forums.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/forums.info,v
diff -u -r1.11 -r1.12
--- openacs-4/packages/forums/forums.info	30 Jul 2002 22:29:04 -0000	1.11
+++ openacs-4/packages/forums/forums.info	30 Jul 2002 22:41:15 -0000	1.12
@@ -85,7 +85,7 @@
             <file type="content_page" path="www/message-email.tcl"/>
             <file type="content_page" path="www/message-post-confirm.adp"/>
             <file type="query_file" db_type="oracle" path="www/message-post-oracle.xql"/>
-            <file type="query_file" path="www/message-post-postgres.xql"/>
+            <file type="query_file" db_type="postgresql" path="www/message-post-postgresql.xql"/>
             <file type="content_page" path="www/message-post.adp"/>
             <file type="content_page" path="www/message-post.tcl"/>
             <file type="query_file" path="www/message-post.xql"/>
Fisheye: Tag 1.2 refers to a dead (removed) revision in file `openacs-4/packages/forums/www/message-post-postgres.xql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: openacs-4/packages/forums/www/message-post-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/www/Attic/message-post-postgresql.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/forums/www/message-post-postgresql.xql	30 Jul 2002 22:41:15 -0000	1.1
@@ -0,0 +1,12 @@
+<?xml version="1.0"?>
+<queryset>
+
+    <rdbms><type>postgresql</type><version>7.1</version></rdbms>
+
+    <fullquery name="select_date">
+        <querytext>
+          select to_char(current_timestamp, 'Mon DD YYYY HH24:MI:SS') 
+        </querytext>
+    </fullquery>
+
+</queryset>
Index: openacs-4/packages/forums/www/message-post.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/www/Attic/message-post.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/forums/www/message-post.xql	3 Jun 2002 04:39:05 -0000	1.2
+++ openacs-4/packages/forums/www/message-post.xql	30 Jul 2002 22:41:15 -0000	1.3
@@ -2,6 +2,14 @@
 
 <queryset>
 
+    <fullquery name="select_name">
+        <querytext>
+          select first_names || ' ' || last_name
+          from persons
+          where person_id = :user_id
+        </querytext>
+    </fullquery>
+
     <fullquery name="select_forum_id">
         <querytext>
             select forum_id