Subject One Generator To Rule Them All
Author sugi
Dear firebird-support list,

For some time now, I've been thinking about means to alleviate the
complexity caused by the use of generators (i.e. having to
declare/implement X number of generators and before insert triggers for
X number of different tables, I'm lazy...:).

Now here's some crazy idea:
What if we just use one generator for all table PKs in a database?

It's just a surrogate key, and by doing this, we achieved
'enterprise-level uniqueness' (coined by scott ambler, i think) at the
same time.

The obvious problem is the limit of 32bit integers, which is plenty, but
not inexhaustible. Any suggestions or comment on whether this is a good

Many thanks in advance,