Re: Alter table column constraint [RESOLVED] - Mailing list pgsql-general

From Rich Shepard
Subject Re: Alter table column constraint [RESOLVED]
Date
Msg-id alpine.LNX.2.20.1812171307390.741@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: Alter table column constraint  (Ron <ronljohnsonjr@gmail.com>)
List 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


pgsql-general by date:

Previous
From: David Rowley
Date:
Subject: Re: NL Join vs Merge Join - 5 hours vs 2 seconds
Next
From: "a"
Date:
Subject: How to insert bulk data with libpq in C?