On Thu, Mar 29, 2012 at 9:25 AM, jakefeed <[email protected]> wrote:
> 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. > No, I don't know of any issues with negative primary keys. The solution makes me queasy though. Maybe a compound key that clearly identifies things as theirs and ours? Good luck, Ann [Non-text portions of this message have been removed]
