Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tfQiW-002KKb-7U for pgsql-general@arkaria.postgresql.org; Tue, 04 Feb 2025 21:44:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tfQiV-0092G2-B5 for pgsql-general@arkaria.postgresql.org; Tue, 04 Feb 2025 21:44:23 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tfQiV-0092Fs-0n for pgsql-general@lists.postgresql.org; Tue, 04 Feb 2025 21:44:23 +0000 Received: from mout.gmx.net ([212.227.17.20]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tfQiS-003J8a-1I for pgsql-general@lists.postgresql.org; Tue, 04 Feb 2025 21:44:22 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1738705460; x=1739310260; i=karsten.hilbert@gmx.net; bh=zg+zvCgpKES/jyCDP5xvQ9Sou2F7RkZ/7AS7rRqizaU=; h=X-UI-Sender-Class:Date:From:To:Subject:Message-ID:References: MIME-Version:Content-Type:Content-Transfer-Encoding:In-Reply-To: cc:content-transfer-encoding:content-type:date:from:message-id: mime-version:reply-to:subject:to; b=M6Ufxkqqa50iEhfdLBS0T6RA+IXT3VivbLxWP08Ybov5VuSgz7AVsdxBzHms0zhW DNOSycpx85wF2hhiHgC6y8IK6rXT2g3a2pwAejEWVKXDtbWGJ+XK5MWKgKQcstXYG jogsa/ki/FxDWyjFzNvg5/pN30AXZgc17/hJn+smulMQ6ibylE0+v4o5DuFy0denM MfbZVZlZhXNUaqcTJ2BHjcTW+4toP0B/juo/q4ZENN2t2UZ7RlPosty1M33jnpkNl 2R5/X9g2mlqBSiK30ipl1TyIqoojOoU0u1QlxekvkT7q1IgZlVvh/a6T1SRmbpLb+ t8Y/TVbF+Hx56PuSyQ== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from hermes ([84.144.215.252]) by mail.gmx.net (mrgmx104 [212.227.17.168]) with ESMTPSA (Nemesis) id 1MpDNf-1t4lZc3QQZ-00gcNy for ; Tue, 04 Feb 2025 22:44:19 +0100 Received: from ncq by hermes with local (Exim 4.96) (envelope-from ) id 1tfQiR-0005iF-1P for pgsql-general@lists.postgresql.org; Tue, 04 Feb 2025 22:44:19 +0100 Date: Tue, 4 Feb 2025 22:44:19 +0100 From: Karsten Hilbert To: pgsql-general@lists.postgresql.org Subject: Re: Lookup tables Message-ID: References: <628D4022-5365-4D00-810B-10349A90874A@kleczek.org> <64603f36-b6d5-469b-8d6d-30376842241b@gelassene-pferde.biz> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable In-Reply-To: <64603f36-b6d5-469b-8d6d-30376842241b@gelassene-pferde.biz> Ma_X_il-Followup-to: d Re_X_turn-receipt-to: Karsten.Hilbert@gmx.net Di_X_sposition-Notification-To: Karsten.Hilbert@gmx.net X-Confi_X_rm-Reading-To: Karsten.Hilbert@gmx.net X-Pri_X_ority: 2 (High) Sender: X-Provags-ID: V03:K1:h/1WrbEQ66E14QtqpnffVET8S7ch7NCMf6K6Nnuny1rJz64Kj4X 4Kne0DUTMtK/7kYgNURMDCnp6Xo5cjsyKGNTE9foJemAQfxe0E/cWMdZJd0TOYRpbgVBTmU pUqRxoUaOi8pc8Z0OXO1Eehyv6capRFdTNgY2QVByD+EdEVBDYqaaVGQngdjJVi+YWLpD3O ArIBHGbhERwUdJWAos+9w== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:+clfRLkmiI4=;wBCAj0TkZs5LhtdJ61JRFhm1d1m Ofrc5Kw+oQz/IBF60gZbU9ZVyH7y2wabbPMJOcxBXwFDERdWbbpW3UO6veJ+Gfdujnj7Ksc7X YVlFcNljLpgtxJG7gg12BnS6Xszm8RxAnR5QXR0+p7xxawf5+gEFCpWS7/ViiN9IEloKouHMt iRNagiW3CWk5yVh3FPcMjiRZaoybUqy33BZVVQEf7oIKQcygR4KPMYFCnH9bqWfuoQl7EYX6D VSkIPp1xOmfn6DPL6n7Kgl2uJbTvz8M0/FbCMl5a67Wv6hEri5oCR5yq+uHuMeaJBQ/igWEsC nf0Mv9SQJLHhB10w9MEBuiySOKixRfMl/KiFGgEDMsQ6pJf3aE85rEkEgz+FBetJF0RKREZLU 2DxNnESgUJRNv97igd3nrmwHfUoKcNr3q31H+N5m5/gbDZvDfWPuENGvK030cs4milKKmu8NE FXPJlzCQb3Wy8voygOaWpldY5EX9UhqPU7ZDsAjyASQj0kTlsxhuDIYp0wvANN6fXItOWcqCh MlPY+QX+qdlUuSbcbTM2YHUjZuQBaDGVYI9ndgde0Djr6TTV8ciklvd4dYhYEjVgLDXSTlt2X WtfvdSu3mbBxxKufAlNmAkX3S3h6FqD4p4dn/7CbDKebPdcMVxdbjaWqsOEL/M5I/wqwVnZQo NzocdiZa3dCEqr4ws2bsMtK5PWi0uIiMltbutwWlKIhwp5zAYwGlTU5aTOvxq0t47LrDFFK50 jtDknl8Ae4sbIvHtyD/08qBDa7tFbG0ZF6iS7n1dIhcywYyNScZau8z9W2YCWbNet7B0F06ZD UDbrn57v/nbJXUf1sQIoJaJbon9F5fhyPSDatRJDtBghpfraIVxrmqWB7dUsd9K5KqHTsrGmE ayAM3lmfG+JIXeEjPnbobaZfiP69EdAzSZt0TwRgsSELFoFw45hKUkMMfsnlV+feBMp8/i7LK dqt2z3i0tejrNxfir2VQogYIdRNDFCOMZD/9cJD0kws8oMoJB9YDAYkJo5ytk9W1Xgfydkg9r mVHw4JpuJ4v8gc65zgA65t5AtDmMzGY1EpwtMRlYuuqXwu+Jv7zlo7RPh3R7uAqny3c534ajp qISU8MbADivBMdJ1gvgoBCZI5d9J+owEgL8Czyzvq+I4d34rTq7O0DlfK/LMPvyjANHjP4wyi TrLMtbSuCFuTvHb+ToCGpETMoX1rjCLsNwO13eKDKoT6mSONDsuLjWPOGdGRvSMHeoiYWmudG D+215AfqTUn40dOrTVGksiDWkovLInHMKiZO0MR8MJtCdmZ3rOSvSr9ZuF8Nq//TudCWT2aXP +bsO9/24EXzpNj9DlTP4XGf9Ow0R+IaX6Gmu6VL+MPIaFVe+nQ00IVhVK61Ax9dqK+NRZ+3vd 3JYBvqERuoZbaJdDEF70Sg96KScAmniiaDqPbZocksvOCY7TKLac/obqH4 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Am Tue, Feb 04, 2025 at 10:41:38PM +0100 schrieb Thiemo Kellner: > >> On 4 Feb 2025, at 18:27, Thiemo Kellner = wrote: > >> > >> =EF=BB=BF Unless the lookup table is actually a check constraint one = can use to populate dropdown boxes in an interface. > > > > That is even worse because it ceases being transactional and users mig= ht select something different than what they see on the screen. > > I might see what you want to point out. E.g. the table is COLOURS. The r= ec with id 1 is RED, the one with id 2 is BLUE, 3 is GREE and so on. Now y= ou load these values into the dropdown box that sports RED, BLUE, GREE and= so on. While someone selects GREE, there is a maintenance release changin= g GREE to YELLOW. So when that someone sends the selection by id to the ba= ckend, not GREE is selected but YELLOW. Yep, that's what I meant and which I never thought of before. Karsten =2D- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B