Postgres Pro
Downloads
Home   >   mailing lists

Re: Lookup tables - Mailing list pgsql-general

From Ron Johnson
Subject Re: Lookup tables
Date
Msg-id CANzqJaD-qFaf_v1fhhs73kfBFuTqkH_qZk1UGEJh95Wz7uF0Ng@mail.gmail.com
Whole thread Raw
In response to Re: Lookup tables  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Lookup tables
List pgsql-general
Tree view
On Tue, Feb 4, 2025 at 9:41 AM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Tuesday, February 4, 2025, Rich Shepard <rshepard@appl-ecosys.com> wrote:
Should lookup tables have a numeric FK column as well as the description column?

If so, how should I add an FK to the two lookup tables in my database?

Most do (have a surrogate PK) since it removes cascading updates
 
How does a synthetic PK "remove cascading updates"?  Doesn't the decision on whether or not to cascade update depend on the ON UPDATE CASCADE clause of the FK definition?

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Lookup tables
Next
From: "David G. Johnston"
Date:
Subject: Re: Lookup tables