Re: How to define fixed validation tables - Mailing list pgsql-novice

From David G. Johnston
Subject Re: How to define fixed validation tables
Date
Msg-id CAKFQuwbwdqaYkOVcCF_BtyXgKicQpkhXvqduRDjTCqbh2+Ubsg@mail.gmail.com
Whole thread Raw
In response to How to define fixed validation tables  ("David A. Cobb" <david.a.cobb.1943@gmail.com>)
List pgsql-novice
On Thursday, December 28, 2017, David A. Cobb <david.a.cobb.1943@gmail.com> wrote:
The values should be fixed as part of the definition process.

You can make it difficult to alter the table contents but not impossible - and I'd lean toward a table rather than a check constraint.

Grants and triggers are your most direct tools of choice here.

David J.

pgsql-novice by date:

Previous
From: "David A. Cobb"
Date:
Subject: How to define fixed validation tables
Next
From: lgcaracol
Date:
Subject: Escape char in pg_ls_dir