Index: openacs-4/contrib/packages/bcms/tcl/bcms-revision-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/bcms/tcl/bcms-revision-procs-postgresql.xql,v diff -u -r1.5 -r1.6 --- openacs-4/contrib/packages/bcms/tcl/bcms-revision-procs-postgresql.xql 27 Oct 2003 10:09:10 -0000 1.5 +++ openacs-4/contrib/packages/bcms/tcl/bcms-revision-procs-postgresql.xql 9 Feb 2004 14:48:44 -0000 1.6 @@ -32,7 +32,7 @@ - select x.revision_id, x.name, x.title, x.description, p.first_names, p.last_name, + select x.item_id, x.revision_id, x.name, x.title, x.description, p.first_names, p.last_name, to_char(x.last_modified,'HH:MI AM MM/DD/YYYY') as creation_date, l.live_revision_id from ${table_name}x x, persons p, (select content_item__get_live_revision(:item_id) as live_revision_id) l where x.creation_user = p.person_id @@ -43,7 +43,7 @@ - select content_revision__copy(:revision_id, null, null, :creation_user_id, :creation_ip) + select content_revision__copy(:revision_id, null, null, :creation_user, :creation_ip)