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 1tfMlS-001pub-QR for pgsql-general@arkaria.postgresql.org; Tue, 04 Feb 2025 17:31:11 +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 1tfMlR-006Ils-AG for pgsql-general@arkaria.postgresql.org; Tue, 04 Feb 2025 17:31:09 +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 1tfMlQ-006Ilj-Vs for pgsql-general@lists.postgresql.org; Tue, 04 Feb 2025 17:31:08 +0000 Received: from mail-ej1-x62e.google.com ([2a00:1450:4864:20::62e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tfMlN-003Gvg-1j for pgsql-general@lists.postgresql.org; Tue, 04 Feb 2025 17:31:08 +0000 Received: by mail-ej1-x62e.google.com with SMTP id a640c23a62f3a-ab7515df1faso149004466b.2 for ; Tue, 04 Feb 2025 09:31:05 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=kleczek.org; s=google; t=1738690264; x=1739295064; darn=lists.postgresql.org; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:from:to:cc:subject:date:message-id :reply-to; bh=Lzo0r0VsOjrk4hKJH1MqGmm7r+kBZJpbGiqT7lEZmxc=; b=biOb+dczf5SB/uclpO/A2IuTpD5mCXLG5tnCw8eLQyj/KX3awASKwEbpPMlgaQL6Z0 N6wXhOaKWt5BSVmanVeMyfwI4CYzLS8HVvQwnZKfxbKgkImxoAWWrq0nM/xUKlOePBgS +dPCbZhSRSBSkEjPpF85mDttyaV/kNjznZ4gE= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1738690264; x=1739295064; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=Lzo0r0VsOjrk4hKJH1MqGmm7r+kBZJpbGiqT7lEZmxc=; b=lYmoOyrR/3W/Xvw3bMPdyxHeBypIzA0SeT0EMGiI0U0gh/PEX8gT71CaUyeLwIUXEO qCjJmfvedLEKNmARh1NRxbEb80GjoR6QaTK5P78qLaOR6TGDhYR1aPX99xVoYW5pelLB 0yXLK5vl+bwvIOuNwbgS+RiDeLJUXqRgNxqnum7XdFlds0BCyh2i0Y3JA4I6kb3aQjpP twMvaxsO3wC2lEVTQ/60IRWJPjEc0dHit5oON7ZeVIyLUbNdhwtKC8qVnz0HwKi87Wda J6vJGcDn8j4h7xTWVZ329DBRpqGNML2JRrY69kUXkuspciT98T7mpvt+oR1NFROw8S1G yCJQ== X-Gm-Message-State: AOJu0YyPEkbAuQmNVwjH+W7Ec7/yxQ/SswL6xqLa2tU3ZJeR9lNcTKpa gVgYl74BWLJ39RF7EPkoiI4ziFRQfuXKJ57jut8axaR8MKAWFF58olkmgaI8jSvINvnrNqodDNe mCS8= X-Gm-Gg: ASbGnctZEuz/1OX5TeuD405J9/fEULPgRgBB4JLAkmdkfcM2Vayb0i3AEVd5MVezyHz 0DPOiQ8bsFx4qmL2vdchF1BnnR/A/tszWX0w7+xrAHx16W1N5kusPxMv8Lj2J8yhJfOOrx3bfir X+0LySrjdm2E3bvLMrOq98ONqkY1iUikDLIJG3WNWk82JkFDOSUX8uS92n7SNri6UMA3eedozYq FEXeTy2xB6F6hSWgB3gspEVGQasYcjOALtTYJhp9SmHMpC2Q9iUBWnhVIsrYRLlhjNQa69pzJWd sKYxMFdszHA7PtD+eRcjGkeDXxh1pTcIMkiUBLgHE68= X-Google-Smtp-Source: AGHT+IEshBbCWhvkTmPsIBxVhkKc5FWzAG28QyJUUWxQesEgK/b84+9sFkEEeDOpRbuOXFXsen9t5A== X-Received: by 2002:a17:906:60d7:b0:ab6:d2d2:4fd8 with SMTP id a640c23a62f3a-ab6d2d2527fmr2270381866b.57.1738690264448; Tue, 04 Feb 2025 09:31:04 -0800 (PST) Received: from smtpclient.apple (b15.kleczek.org. [185.20.172.182]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-ab6e49ffe2csm969732666b.97.2025.02.04.09.31.03 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 04 Feb 2025 09:31:04 -0800 (PST) Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable From: =?utf-8?Q?Micha=C5=82_K=C5=82eczek?= Mime-Version: 1.0 (1.0) Subject: Re: Lookup tables Date: Tue, 4 Feb 2025 18:30:53 +0100 Message-Id: <628D4022-5365-4D00-810B-10349A90874A@kleczek.org> References: Cc: pgsql-general@lists.postgresql.org In-Reply-To: To: Thiemo Kellner X-Mailer: iPhone Mail (22C161) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On 4 Feb 2025, at 18:27, Thiemo Kellner wrot= e: >=20 > =EF=BB=BF Unless the lookup table is actually a check constraint one can u= se to populate dropdown boxes in an interface. That is even worse because it ceases being transactional and users might sel= ect something different than what they see on the screen. =E2=80=94 Micha=C5=82=20=