MIME-Version: 1.0
References: <4e7a338-c7d3-e944-20bd-a6e346e175c7@appl-ecosys.com>
 <CAKFQuwaPUJCwmf75Uwu1_kLGfOgdt9L+Y-2evudS0RQBNU3-fA@mail.gmail.com>
In-Reply-To: 
 <CAKFQuwaPUJCwmf75Uwu1_kLGfOgdt9L+Y-2evudS0RQBNU3-fA@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Tue, 4 Feb 2025 09:56:26 -0500
Message-ID: 
 <CANzqJaD-qFaf_v1fhhs73kfBFuTqkH_qZk1UGEJh95Wz7uF0Ng@mail.gmail.com>
Subject: Re: Lookup tables
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000042180c062d5237e1"
Archived-At: 
 <https://www.postgresql.org/message-id/CANzqJaD-qFaf_v1fhhs73kfBFuTqkH_qZk1UGEJh95Wz7uF0Ng%40mail.gmail.com>
Precedence: bulk

--00000000000042180c062d5237e1
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Tue, Feb 4, 2025 at 9:41=E2=80=AFAM 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?

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

--00000000000042180c062d5237e1
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Tue, Feb 4, 2025 at 9:41=E2=80=AFAM Da=
vid G. Johnston &lt;<a href=3D"mailto:david.g.johnston@gmail.com">david.g.j=
ohnston@gmail.com</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote=
_container"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0=
.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">On Tuesday, F=
ebruary 4, 2025, Rich Shepard &lt;<a href=3D"mailto:rshepard@appl-ecosys.co=
m" target=3D"_blank">rshepard@appl-ecosys.com</a>&gt; wrote:<br><blockquote=
 class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px so=
lid rgb(204,204,204);padding-left:1ex">Should lookup tables have a numeric =
FK column as well as the description column?<br>
<br>
If so, how should I add an FK to the two lookup tables in my database?<br>
</blockquote><div><br></div><div>Most do (have a surrogate PK) since it rem=
oves cascading updates</div></blockquote><div>=C2=A0</div></div><div>How do=
es a synthetic PK &quot;remove cascading updates&quot;?=C2=A0 Doesn&#39;t t=
he decision on whether or not to cascade update depend on the ON UPDATE CAS=
CADE clause of the FK definition?</div><div><br></div><span class=3D"gmail_=
signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature">=
<div dir=3D"ltr">Death to &lt;Redacted&gt;, and butter sauce.<div>Don&#39;t=
 boil me, I&#39;m still alive.<br><div><div>&lt;Redacted&gt; lobster!</div>=
</div></div></div></div></div>

--00000000000042180c062d5237e1--