Re: Lookup tables

06.02.2025 22:04:34 Peter J. Holzer <hjp-pgsql@hjp.at>:

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