Re: Alter table column constraint [RESOLVED]

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Alter table column constraint [RESOLVED]
Date: 2018-12-17 21:09:51
Message-ID: alpine.LNX.2.20.1812171307390.741@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 17 Dec 2018, Ron wrote:

> Melvin is saying to:
> 1. create a table named valid_industry,
> 2. populate it with the valid industries,
> 3. create an FK constraint on your main table's industry column to
> valid_industry.industry, and then
> 4. drop the constraint invalid_industry.

Got it. Hadn't before considered making column check constraints into
separate tables, but now I see the value of doing this.

Thanks, all,

Rich

In response to

Browse pgsql-general by date

  From Date Subject
Next Message a 2018-12-18 03:03:56 How to insert bulk data with libpq in C?
Previous Message David Rowley 2018-12-17 20:48:09 Re: NL Join vs Merge Join - 5 hours vs 2 seconds