Re: Implementing standard SQL's DOMAIN constraint [RESOLVED]

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Implementing standard SQL's DOMAIN constraint [RESOLVED]
Date: 2019-01-02 18:28:29
Message-ID: alpine.LNX.2.20.1901021026370.20959@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 2 Jan 2019, Ron wrote:

> Note that a CHECK constraint with 50 items is a *Very Bad Idea*, since
> changing such a constraint is very painful. Use a FK constraint instead.

Ron,

It's even longer with Canadian provinces included. I gratefully accept
your advice and will use a table and foreign key instead.

Regards,

Rich

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2019-01-02 21:49:21 Default for date field: today vs CURRENT_DATE
Previous Message Kevin Brannen 2019-01-02 18:25:26 RE: Relocatable Binaries (RPMs) : custom installation path for PostgreSQL