On May 2, 2011, at 10:53 PM, Rob Sargent wrote: > ...and you're at risk of having to reformat them when you buy out your competitor. The scheme described was awfully similar to one that a client of mine used, product family prefix, identifiers within the family. And guess what? The scheme, which had been stable for 20+ years, had to change when a new variant of product was introduced which cut across family & product. I don't remember the details. I do remember that I hadn't used the supposedly stable product ids as PKs ;-) -- Scott Ribe scott_ribe@xxxxxxxxxxxxxxxx http://www.elevated-dev.com/ (303) 722-0567 voice -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general