> 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/