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 -r1.7.2.1 -r1.7.2.2 --- openacs-4/packages/general-comments/tcl/general-comments-procs-postgresql.xql 4 Jan 2006 20:37:43 -0000 1.7.2.1 +++ openacs-4/packages/general-comments/tcl/general-comments-procs-postgresql.xql 20 Nov 2006 20:00:26 -0000 1.7.2.2 @@ -5,7 +5,7 @@ - + select g.comment_id, r.title, r.mime_type, @@ -17,7 +17,8 @@ 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 @@ -30,7 +31,6 @@ - select g.comment_id, r.title, r.content,