> We have an database in which we supply product catalogs with pricing. The > end user can create their own items, too. In order to separate the user's > items from the items we supply, we're contemplating using negative primary > keys for our items and positive primary keys for the users items. We are > using Firebird 2.5.1. Are there any known issues using negative primary key > values in this configuration. Thank you.
Not from a numeric POV, but I wonder what method you use to assign the primary key values? One generator per table might be hard in that scenario. -- With regards, Thomas Steinmaurer (^TS^) Firebird Technology Evangelist http://www.upscene.com/ Do you care about the future of Firebird? Join the Firebird Foundation: http://www.firebirdsql.org/en/firebird-foundation/
