Re: Lookup tables

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Lookup tables
Date: 2025-02-04 14:41:37
Message-ID: CAKFQuwaPUJCwmf75Uwu1_kLGfOgdt9L+Y-2evudS0RQBNU3-fA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support pgsql-general

On Tuesday, February 4, 2025, Rich Shepard <rshepard(at)appl-ecosys(dot)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 and is a
smaller value.

Lots of alter tables and update queries.

David J.

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Rich Shepard 2025-02-04 14:46:41 Re: Lookup tables
Previous Message Rich Shepard 2025-02-04 14:27:54 Lookup tables

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2025-02-04 14:46:41 Re: Lookup tables
Previous Message Rich Shepard 2025-02-04 14:27:54 Lookup tables