On Thu, Mar 29, 2012 at 9:25 AM, jakefeed <jakefeed@...> 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]