Horton
Menu

Re: Lookup tables [FIXED]

Rich Shepard <rshepard@appl-ecosys.com>

View thread
From: Rich Shepard <rshepard@appl-ecosys.com>
To: pgsql-general@postgresql.org
Date: 2025-02-04T20:57:34Z
Lists: pgsql-general 
On Tue, 4 Feb 2025, Rich Shepard wrote:

> I'll make new tables today.

That did not work as well as I expected. Instead, I added a new column (type
`serial') to each of the two lookup tables. That adds a PK to each while
retaining the table and column names referenced by other tables.

Thanks for all your comments,

Rich