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.