Index: openacs-4/packages/general-comments/tcl/general-comments-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/general-comments/tcl/general-comments-procs-postgresql.xql,v diff -u -N -r1.7.2.2 -r1.7.2.3 --- openacs-4/packages/general-comments/tcl/general-comments-procs-postgresql.xql 20 Nov 2006 20:00:26 -0000 1.7.2.2 +++ openacs-4/packages/general-comments/tcl/general-comments-procs-postgresql.xql 22 Nov 2006 10:03:21 -0000 1.7.2.3 @@ -5,7 +5,7 @@ - + select g.comment_id, r.title, r.mime_type, @@ -17,8 +17,7 @@ cr_revisions r, acs_objects o where g.object_id = :object_id and - r.revision_id = - content_item__get_live_revision(g.comment_id) and + r.revision_id = content_item__get_live_revision(g.comment_id) and o.object_id = g.comment_id $context_clause $my_comments_clause @@ -31,6 +30,7 @@ + select g.comment_id, r.title, r.content,