In my data model I have some static data that is added to over time as the system changes. For instance:
create table region (id SERIAL,crname TEXT);
customer has a link to the region, my system adds regions over time. new regions are manually added by the dba executing an insert statement provided by the dev team for a release. I'm looking for a Chris Date style perspective on how this should be modeled and implemented. Should the key be managed by a database sequence where each database instance can have different keys for region "South West Denver" depending on when they are added, or is it acceptable to have key 32 for "South West Denver" in every instance of the region table for dev/test/qa/pre-prod etc? Effectively not using a sequence or database managed key.