On Jan 12, 4:43 am, "Rick Morrison" <[EMAIL PROTECTED]> wrote: > My experience with GUID PKs is that they almost always cause more troubles > than they purport to solve, and 99% of the time a plain Integer PK will work > just fine instead. The two rare exceptions are with multi-database > synchronization (and even there integer PKs can work fine with an additional > 'source' discriminator column) and humungo databases where overflowing a > bigint col is a real fear.
A bit offtopic, but I can't imagine a situation where overflowing a bigint col would be feasible. Even if you generate 1 billion rows per second, you still have about 300 years worth of keys available. Ants Aasma --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---