Re: Lookup tables
David G. Johnston <david.g.johnston@gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Michał Kłeczek <michal@kleczek.org>
Cc: Thiemo Kellner <thiemo@gelassene-pferde.biz>, "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2025-02-04T18:20:53Z
Lists: pgsql-general
On Tuesday, February 4, 2025, Michał Kłeczek <michal@kleczek.org> wrote: > > > On 4 Feb 2025, at 18:27, Thiemo Kellner <thiemo@gelassene-pferde.biz> > wrote: > > > > 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 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 “value not found” error and a refresh with the correct matching values showing up in the UI? David J.