Re: How to define fixed validation tables

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: "David A(dot) Cobb" <david(dot)a(dot)cobb(dot)1943(at)gmail(dot)com>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: How to define fixed validation tables
Date: 2017-12-28 20:15:52
Message-ID: CAKFQuwbwdqaYkOVcCF_BtyXgKicQpkhXvqduRDjTCqbh2+Ubsg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Thursday, December 28, 2017, David A. Cobb <david(dot)a(dot)cobb(dot)1943(at)gmail(dot)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.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message lgcaracol 2017-12-29 10:00:56 Escape char in pg_ls_dir
Previous Message David A. Cobb 2017-12-28 20:09:51 How to define fixed validation tables