Re: Lookup tables

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Lookup tables
Дата
Msg-id CAKFQuwYKGwnQpRSz0Hep3OTG-WXAn0RpPAKL1wsz2dcp9K=ELA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Lookup tables  (Michał Kłeczek <michal@kleczek.org>)
Список 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 по дате отправления: