Index: openacs-4/contrib/packages/general-comments/tcl/general-comments-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/general-comments/tcl/Attic/general-comments-procs-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/packages/general-comments/tcl/general-comments-procs-postgresql.xql	2 May 2003 15:49:59 -0000	1.1
+++ openacs-4/contrib/packages/general-comments/tcl/general-comments-procs-postgresql.xql	28 May 2003 00:54:13 -0000	1.2
@@ -3,22 +3,46 @@
 <queryset>
    <rdbms><type>postgresql</type><version>7.1</version></rdbms>
 
+<fullquery name="general_comments::create_coment.insert_comment">
+    <querytext>
+
+	select general_comment__new (
+		:comment_id,
+		:object_id,
+		:package_id,
+		:parent_id,
+		:context_id,
+		:title,
+		:description,
+		:empty_blob(),
+		:creation_user,	
+		:creation_date,
+		:creation_ip,
+		:comment_mime_type
+		:is_live
+	);
+
+    </querytext>
+</fullquery>
+
 <fullquery name="general_comments_get_comments.get_comments">      
       <querytext>
       
              select g.comment_id,
                     r.title,
                     r.mime_type,
                     o.creation_user,
-                    acs_object__name(o.creation_user) as author,
+                    u.full_name as author,
                     to_char(o.creation_date, 'MM-DD-YYYY') as pretty_date,
                     to_char(o.creation_date, 'Month DD, YYYY HH12:MI PM') as pretty_date2
                     $content_select
                from general_comments g,
                     cr_revisions r,
-                    acs_objects o
+                    acs_objects o,
+		    cc_users u,
+	            cr_items i
               where g.object_id = :object_id and
-                    r.revision_id = content_item__get_live_revision(g.comment_id) and
+                    r.revision_id = i.live_revision and
                     o.object_id = g.comment_id
               order by o.creation_date
       </querytext>