Looks like the patch to fix this is located here:
http://cvs.openacs.org/cvs/openacs-4/packages/acs-content-repository/tcl/content-revision-procs.tcl?r1=1.14&r2=1.15
It is PostgreSQL 8 only.
Does anyone know of a way to fix this problem that would work in PostgreSQL 7?