Horton
Menu

Re: Lookup tables

David G. Johnston <david.g.johnston@gmail.com>

View thread
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Rich Shepard <rshepard@appl-ecosys.com>
Cc: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Date: 2025-02-04T19:11:25Z
Lists: pgsql-general 
On Tuesday, February 4, 2025, Rich Shepard <rshepard@appl-ecosys.com> wrote:

>
> I want to replace the old lookup table (with no FK) with this one.
>

Is the use of FK here intentional or a typo?  Because everything written so
far leads me to believe it should be PK.  Pri,are key is the unique side,
Foreign key is the usage side.

David J.