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 1tfNXe-001wZu-Fj for pgsql-general@arkaria.postgresql.org; Tue, 04 Feb 2025 18:20:58 +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 1tfNXd-006ydL-Di for pgsql-general@arkaria.postgresql.org; Tue, 04 Feb 2025 18:20:57 +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 1tfNXd-006yd9-3R for pgsql-general@lists.postgresql.org; Tue, 04 Feb 2025 18:20:57 +0000 Received: from mail-ot1-x32e.google.com ([2607:f8b0:4864:20::32e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tfNXa-003AU5-2I for pgsql-general@lists.postgresql.org; Tue, 04 Feb 2025 18:20:56 +0000 Received: by mail-ot1-x32e.google.com with SMTP id 46e09a7af769-724f4d99bc7so1346665a34.1 for ; Tue, 04 Feb 2025 10:20:55 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1738693254; x=1739298054; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=8480h8JrtnD6FEEcFvDq4KQRqs0DxS0DLbdAtN6Tzrs=; b=jPnRL/nvE5d+85A00iO7BjXDRlJ9gM9jM6MnNff0pMZJA/Lp9Hew0rG9yEuGAxfRA5 cVf50JL4FnAaDrdvvsfV+yu29x3wmjUJzf002/Jyd//irkiKWwsJhuFmAsdIJ5J2jPFa O/q8X9AvSjfGsukUWnlbcc0nvIBsBQmSc+fG2503o94MHAU/m93EiQ5whLPfwwWqle22 ew2UPra2q5CFQKByw5tCSgwiqYH/cPA808AN4luuA2elY4k+E4wRJRfS/QtZPJczQPZd QguxC7uAK6JOxJWNxKYg/yBAvxNOdaRfGxwmwLBsMBi16McXodS/XF1wb+4DyU1ifHg8 8GNg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1738693254; x=1739298054; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=8480h8JrtnD6FEEcFvDq4KQRqs0DxS0DLbdAtN6Tzrs=; b=TSkb3byb5C0MpzueQE3gD7o03zdw+BI++Rl4h2Ktumm4CTJcebqPlhZqkX2t6OCE2V JJ+GMA2FQZCw116Im2LNZJ71y5HBun4t0g0E+85xH/s/yJfwOBaCI0CVKzGrfhqdUf1f 6ZLm11hdQDp+ugfnbeMcdm5JyxdIrEdNOQDs+GPxX1qhBjAkpA505tndCg5CSURPP9G7 wFZigZFn8mZLxjTyjB0jvQQxhodyB/XYMtUQzTKmSOA3HKrKt8749x/3XqITfEl+P+aw IV10r9uS1Jt9OpfksRd9/vAapPT3Ay2Czq0Fb5bhXcUimbAS7m+SrhHey9EdzxTy9Wa5 cjpQ== X-Forwarded-Encrypted: i=1; AJvYcCXiJ5tj6m7Yn/QGnI6bgLrNmMscfReWISut7AuEA6wEHw7efywNtUojggz9UJSgztNreWxjyE1Q+g7gckrj@lists.postgresql.org X-Gm-Message-State: AOJu0YxbuLcwWCGiaRNVBoW5ookFx03k45SEJvTET7roj+KEfWZwrRAL KYqA7hSb8SANMmUZ5mKkgIdE02b9RtsKbWJ6YvVbQ6/HmL1QKMnx7+jaq1ikwG1HfkOUMyQOSbZ 9dXTGbcebe3omktm2GPAvQ5nwKD8= X-Gm-Gg: ASbGncusydyU64Ap0Gmyj6Q014KwzY/GqrfeIwZKkci4KOZNaPdfy4CZFugS1TWe/dh Dt0pXXstiLKmMIChVn1AxoGHP6tKAeyArJoqtcat+GvDSGaAtv7h0yP9N3304Y14iX5wMfT8= X-Google-Smtp-Source: AGHT+IGX2ghnMdPxWLqp0sE5DBtBJ3yU0q9ePEGRjemRMDNT+hgMPu2mxbTWCfFE/F3uKDnmPBR56VFmmvAzFrzFrx0= X-Received: by 2002:a05:6830:6517:b0:718:1863:a3fa with SMTP id 46e09a7af769-72656766054mr22208994a34.10.1738693254011; Tue, 04 Feb 2025 10:20:54 -0800 (PST) MIME-Version: 1.0 Received: by 2002:a05:6802:a0c:b0:577:9519:f64a with HTTP; Tue, 4 Feb 2025 10:20:53 -0800 (PST) In-Reply-To: <628D4022-5365-4D00-810B-10349A90874A@kleczek.org> References: <628D4022-5365-4D00-810B-10349A90874A@kleczek.org> From: "David G. Johnston" Date: Tue, 4 Feb 2025 11:20:53 -0700 X-Gm-Features: AWEUYZkzjNkR28QBdMaL8ONDQT0uAinRUrW7RMHTD6RsYGhJufCp60OgNidyUCo Message-ID: Subject: Re: Lookup tables To: =?UTF-8?B?TWljaGHFgiBLxYJlY3plaw==?= Cc: Thiemo Kellner , "pgsql-general@lists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000c76471062d5511ab" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000c76471062d5511ab Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tuesday, February 4, 2025, Micha=C5=82 K=C5=82eczek = wrote: > > > On 4 Feb 2025, at 18:27, Thiemo Kellner > wrote: > > > > =EF=BB=BF Unless the lookup table is actually a check constraint one ca= n 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. > What is the process flow for this happening? How big a bug needs to exist in the system for something bad to happen as opposed to some kind of =E2=80= =9Cvalue not found=E2=80=9D error and a refresh with the correct matching values sho= wing up in the UI? David J. --000000000000c76471062d5511ab Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tuesday, February 4, 2025, Micha=C5=82 K=C5=82eczek <michal@kleczek.org> wrote:

> On 4 Feb 2025, at 18:27, Thiemo Kellner <thiemo@gelassene-pferde.biz> 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 se= lect something different than what they see on the screen.

What is the process flow for this happenin= g?=C2=A0 How big a bug needs to exist in the system for something bad to ha= ppen as opposed to some kind of =E2=80=9Cvalue not found=E2=80=9D error and= a refresh with the correct matching values showing up in the UI?

David J.
=C2=A0
--000000000000c76471062d5511ab--