The unique constraint idea is clever. But using side effects like the constraint throwing an error to do significant stuff makes me uncomfortable. Document it well so the maintenance programmer who looks at the app in four years will understand how you're using that.