Re: Lookup tables - Mailing list pgsql-general

From Thiemo Kellner
Subject Re: Lookup tables
Date
Msg-id dcc1d1bd-8ec5-4ec9-b3c7-a67889c6034d@gelassene-pferde.biz
Whole thread Raw
In response to Re: Lookup tables  (Michał Kłeczek <michal@kleczek.org>)
List pgsql-general
04.02.2025 18:31:09 Michał Kłeczek <michal@kleczek.org>:

>>  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
seeon the screen. 

In how far is a real check constraint less transactional? And in how far is it more advisable to have a real check
constraintand fill your dropdown boxes from another source and having to keep that source on sync with the real check
constraint?




pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Understanding ALTER DEFAULT PRIVILEGES Behavior in PostgreSQL
Next
From: Rich Shepard
Date:
Subject: Re: Lookup tables