Hi,

>How would one normally deal with this problem? Presumably one must always
>use globally
>unique keys, but can these be generated in firebird?

Yep. Use UUIDs. Recente FB versions have an internal gen_uuid() function.
Older ones you have to use some UDF or generate it client side.

It's recomended that you store gen_uuid() values on a char(16) octets field.
Search for gen_uuid in this group and you'll find more info.


Regards,
Anderson Farias