Re: Lookup tables - Mailing list pgsql-general

From David G. Johnston
Subject Re: Lookup tables
Date
Msg-id CAKFQuwYKGwnQpRSz0Hep3OTG-WXAn0RpPAKL1wsz2dcp9K=ELA@mail.gmail.com
Whole thread Raw
In response to Re: Lookup tables  (Michał Kłeczek <michal@kleczek.org>)
List 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.
 

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: old OS
Next
From: Ayush Vatsa
Date:
Subject: Understanding ALTER DEFAULT PRIVILEGES Behavior in PostgreSQL