Serial Numbers...On Commit or On Creation?
I'm wrestling with why I would use On Commit rather than On Creation for my ID numbers in my tables. I thought at first that on commit would prevent me from "using up" serial numbers in the event a user decides not to save the new record. But then I realize that records are saved automatically anyway.
Does anyone have any examples of when one would want On Commit instead of On Creation?