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 1tfN6G-001sWQ-4K for pgsql-general@arkaria.postgresql.org; Tue, 04 Feb 2025 17:52:40 +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 1tfN6F-006ZrA-87 for pgsql-general@arkaria.postgresql.org; Tue, 04 Feb 2025 17:52:39 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tfN6E-006Zr2-U9 for pgsql-general@lists.postgresql.org; Tue, 04 Feb 2025 17:52:38 +0000 Received: from mout.gmx.net ([212.227.17.22]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tfN6C-003AFq-29 for pgsql-general@lists.postgresql.org; Tue, 04 Feb 2025 17:52:38 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1738691554; x=1739296354; i=karsten.hilbert@gmx.net; bh=uLqSXUN+m+LWhdaFdcGpxLFsipftj2eHqS1/6EOKHUQ=; 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=G94B+qUukB4JF0BzxzRmbocEz9HrRDul2pW18ww/68rNOXHSJmEZ+e6lHBGJPpGc Pf9hnrMehc/jAk75f5ZYlHLByJdurxyb+s90PNSLm0xIHITcK2VOMq/LyHpc54ujv xYjgVu0R10RohwWaReGrXxs3UDq586OjfZAaTJEJs/n4KohffmexZg/xyPIYq5FIr Wnm8OqgmIm+SUsnjcKVykq2Lz1M7J/HFKb8qpIDakLVmfS4DS2l31W3H+Vu0j4H7Z 3WQy34aA/PsF+jU3v6df2xHqFStv77M4429RX1iAldB96wd1Cj41DqaaVNcmPDmP6 v/XCulwEB9mqHnkUIg== 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 1M5wPb-1tlgUr3Anj-00H5a5 for ; Tue, 04 Feb 2025 18:52:34 +0100 Received: from ncq by hermes with local (Exim 4.96) (envelope-from ) id 1tfN6A-0002kX-1L for pgsql-general@lists.postgresql.org; Tue, 04 Feb 2025 18:52:34 +0100 Date: Tue, 4 Feb 2025 18:52:34 +0100 From: Karsten Hilbert To: pgsql-general@lists.postgresql.org Subject: Re: Lookup tables Message-ID: References: <628D4022-5365-4D00-810B-10349A90874A@kleczek.org> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable In-Reply-To: <628D4022-5365-4D00-810B-10349A90874A@kleczek.org> 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:9KUVR4g36tnBOO364OIRQ1vBPqnkxDqpR3Nh5Zosjom1LIsO42d Sk2joxPuIvfkwIZ8HZCrepasxSHLLPY0J9mpuyi/HsMkxxebveihKcJ7juHEGAnddYeg5mZ xl2xDxBUkDD0Esdtcw8s62F9HTVfbPJYeDx3YdUosPH3KfKcKtE9aLhn7ihF58JoW6q/Aro Xt8pPpw7I1y6bzuXi5prw== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:AcaUltZrS5o=;yVFDR0J+T/7GJf3ZRy+4RqqmvsD KHCe7FkuAdae9pvqJ0c3zqMY13PiXuofFMofnuFCAkb75gwLWSAoD9D9B1nxjY49TPApaqp0l gIYhGbXPdEhirWXT4v30inMLcWYPz59IrJzOjY6HrHx6gSnzE3Ap0CSNu8J06KECUXIBfp+Pb M0PLGnRfcY1SbKd/7lxXyhI9hWFMJzPuWjJzJertdXBCCWU0PUZOMCk5yxOiJcWOoKybZlRyy d1E0HGMGhdHiE8B0TRHOI1vbKF/sSj32LIjPAULlL/g5W3WrUpV3/DNnaYBR6YL2S4JTL6WuN Z9/D226p9UYqEXQui8r4UCEAy8fk0bhrjKOC7KwOP5qir/ijUKEqe+tLdd9EJtdGRpas7IbDz uGS2VmZcBlcDkgC5TN+AAds4PjVVGYoQMTlSkVqNiQKKhywfWti5kr5wmkASjEWWac7oqE3RQ AuzzxdgAG7X9Mo4scROX4oLoOwP8zi/JaYZzXXJLNfur/YVys4M4Uh8KK0X4dQaOcuiW3WDKf 9u1e3R/Ub7fuChgC8WDsxjo0Dsaz9dm7UAOj0gddqzLWlBc7ql8D6w3fmGh3vjM4RSozdOMNM W4W5hDBY6ayJmL6ITJEbWs8KZjRS4VAqGgm3knkwqR7lYu/j++keA3Ip0eaqTV8yTmjwFPfPL Ed8jY/6C8z8T990WpxT3ETakGNLSDngarWMDn8FBR/Ec+Y7sXr8tHGwNsyPiQSTPTsNE7i0sL fT7jbIOPQTr8/bgwVyOZvRwYY/Ef3EpcWNh5rAfEoDcxdVlwHMqst2hbJP7hXoB8sErxL9Ym0 4b32uH6ClDdGEVy5sWaEkYluksHqzYoc+N2Ytr+woEuTQjQK6EKXBQr0x8/deTN1wwNDtnP44 KX91Bs4o7WBiBizPO7zRjUJEjUCQa4rHiA4QjFhPNsut2aHAeebG9lC9FWv7nYV5Fv2XbjGJV QVTDanrmTuIz2pX4gAVnj5AKqj9JNI2UbwaE4E/fdiYYr1IKZcfbYyPd4VsRsf6KTcFG9lFlk QSZLuaEi/RzhRH2fui4rib56XDeiGHNO2S8Zw9QhuLFVvhuByAyWFCg/iRsHcLOWhB/098BPm pTXUnXFIzH7ca2UVaUAJuEAwVryt0VxB5fB3il6jc+eaa1ExtBt7QI6tnSne9y6aRJbJrX4/4 VXYhIWfLrSCV+v2GrVuuNvGsxOMNn/3yEspc1yfSOEejsZQDLH8G768vamzK2WwvdL3/VGpwJ JUODmlF54pKE0Gbmd1qUXYS/2FLshtGdYPBZx/SPPEARuVHE5Wg3HJeEbTzfZJdYmnFGfNGfI ny9aCxZaYGTgvndOah1dW09Rg== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Am Tue, Feb 04, 2025 at 06:30:53PM +0100 schrieb Micha=C5=82 K=C5=82eczek: > > On 4 Feb 2025, at 18:27, Thiemo Kellner = wrote: > > > > =EF=BB=BF Unless the lookup table is actually a check constraint one c= an use to populate dropdown boxes in an interface. > > That is even worse because it ceases being transactional and users might= select something different than what they see on the screen. I never thought of that, thanks. Karsten =2D- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B