Postgres Pro
Downloads
Home   >   mailing lists

Re: One parent record with 3 possible child records - Mailing list pgsql-sql

From David G. Johnston
Subject Re: One parent record with 3 possible child records
Date
Msg-id CAKFQuwY6-90W2sO=peE6xf1F07vpbf_4PdKa_bt=4=OAH1GMCw@mail.gmail.com
Whole thread Raw
In response to Re: One parent record with 3 possible child records  (Rob Sargent <robjsargent@gmail.com>)
List pgsql-sql
Tree view
On Thu, May 2, 2024 at 6:37 AM Rob Sargent <robjsargent@gmail.com> wrote:
Presuming the id is unique in parent and child, what’s the value of the type field in the foreign key?  Are you saying the PK on tableMain is (type,id), perhaps for clustering purposes?


Preventing the parent record from saying "tblOne" while the actual ID value is present on "tblTwo".

David J.

pgsql-sql by date:

Previous
From: Rob Sargent
Date:
Subject: Re: One parent record with 3 possible child records
Next
From: "Wetmore, Matthew (CTR)"
Date:
Subject: One parent record with 3 possible child records