04.02.2025 18:31:09 Michał Kłeczek <michal@xxxxxxxxxxx>: >> 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. In how far is a real check constraint less transactional? And in how far is it more advisable to have a real check constraint and fill your dropdown boxes from another source and having to keep that source on sync with the real check constraint?
