Kaare,
> How many times have I tried this
> mailing list with no
> success :-(
Hey! It's a peer-to-peer mailing list. You want guarenteed
answers, pay for support (I do) <shrug>
> I'm wondering how people creates guaranteed sequential
> numbers - in my case
> for invoice numbers.
>
> - Sequences are not rollback'able.
> - It seems overkill to have a table just for this.
> - What else?
Given a full set of business rules for invoice numbers, I
could probably throw you a solution. Gods know that I've
devised enough invoicing systems in the past. Please post
more detail.
-Josh Berkus