I'm no SQL expert, but isn't that what database sequences are for?
Philip Warner wrote:
At 18:05 6/08/2002 +1000, Philip Warner wrote:Looking at the code in pipe.c, it uses the current time to build the ID; several messages were received within a second of each other - hence the non-unique ID.