Index: openacs-4/packages/xotcl-core/lib/revisions-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/xotcl-core/lib/revisions-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/xotcl-core/lib/revisions-postgresql.xql	20 Jun 2006 22:56:53 -0000	1.2
+++ openacs-4/packages/xotcl-core/lib/revisions-postgresql.xql	2 Apr 2013 11:50:40 -0000	1.3
@@ -23,6 +23,26 @@
 	order by n.revision_id desc
     </querytext>
   </fullquery> 
+
+  <fullquery name="revisions_info">
+    <rdbms><type>postgresql</type><version>8.4</version></rdbms>
+      <querytext>
+        select  ci.name, n.revision_id as version_id,
+        person__name(n.creation_user) as author,
+        n.creation_user as author_id,
+        to_char(n.last_modified,'YYYY-MM-DD HH24:MI:SS') as last_modified_ansi,
+        n.description,
+        acs_permission__permission_p(n.revision_id,:user_id,'admin') as admin_p,
+        acs_permission__permission_p(n.revision_id,:user_id,'delete') as delete_p,
+        char_length(n.data) as content_size,
+        content_revision__get_number(n.revision_id) as version_number
+        from cr_revisionsi n, cr_items ci
+        where ci.item_id = n.item_id and ci.item_id = :page_id
+        and acs_permission__permission_p(n.revision_id, :user_id, 'read')
+        order by n.revision_id desc
+      </querytext>
+  </fullquery>
+
 </queryset>