06.02.2025 22:04:34 Peter J. Holzer <hjp-pgsql@xxxxxx>: >> I might see what you want to point out. E.g. the table is COLOURS. The >> rec with id 1 is RED, the one with id 2 is BLUE, 3 is GREE and so on. >> Now you load these values into the dropdown box that sports RED, BLUE, >> GREE and so on. While someone selects GREE, there is a maintenance >> release changing GREE to YELLOW. So when that someone sends the >> selection by id to the backend, not GREE is selected but YELLOW. > > I fail to see why use of a surrogate key is the problem here. It seems I did not make mys of clear. I don't see either and don' remember an occasion in over 20 years of DWH business the use of surrogates was a problem. > Either changing the color from GREE to YELLOW makes sense or it doesn't. Hear, hear. > If it doesn't make sense, then it's release which is faulty, not the > model. ACK Thiemo
