Forum OpenACS Q&A: Re: content_type__create_type for both item and revision table?

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).