Received-SPF: pass (ha01s018.org-dns.com: connection is authenticated)
Date: Fri, 7 Feb 2025 12:07:56 +0100 (GMT+01:00)
From: Thiemo Kellner <thiemo@gelassene-pferde.biz>
To: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Message-ID: <dcb2ac8c-0931-4707-b573-f36aa345e70a@gelassene-pferde.biz>
In-Reply-To: <20250206210318.kj2j5dvliidpmesy@hjp.at>
References: <c0fe3bc0-efb2-4648-ac9a-435601acc2bf@gelassene-pferde.biz>
 <628D4022-5365-4D00-810B-10349A90874A@kleczek.org>
 <64603f36-b6d5-469b-8d6d-30376842241b@gelassene-pferde.biz>
 <20250206210318.kj2j5dvliidpmesy@hjp.at>
Subject: Re: Lookup tables
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/dcb2ac8c-0931-4707-b573-f36aa345e70a%40gelassene-pferde.biz>
Precedence: bulk

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