Subject | Re: One Generator To Rule Them All |
---|---|
Author | peter_jacobi.rm |
Post date | 2003-09-07T12:09:10Z |
Hi Sugi,
--- In firebird-support@yahoogroups.com, sugi <truesaint@c...> wrote:
> What if we just use one generator for all table PKs in a database?
> The obvious problem is the limit of 32bit integers, which is plenty,
but
> not inexhaustible.
The is 64 bit in Firebird. 32 bit was in ye olde times.
Other candidates, to be accessed by UDFs for now:
RDTSC (Pentium Timestamp Counter) 64 bit
UUID (Universally Unique IDentifier) 128 bit,
use char(16) character set OCTETS.
Regards,
Peter Jacobi