James, funny you should mention it...we were talking about it
just today on irc.
You could enforce uniqueness in a revision table with a
partial index.
You can do something similiar with a functional index on
oracle (there is an example in chapter 7 in Tom Kyte's Effective Oracle by Design titled selective uniqueness).
