MIME-Version: 1.0
References: 
 <CAAY=A79usb2Lbr9nUyzxyRNWLQNc-w3oTBbtUGyC2a4E-qaX3A@mail.gmail.com>
 <CAKFQuwYPeiXTT0GTrN3o7Ja7P9G9Z-LerHsdbzCDqe=SRhffyg@mail.gmail.com>
 <CCFD24A0-A331-4633-AC9A-714F7F18B5DF@gmail.com>
In-Reply-To: <CCFD24A0-A331-4633-AC9A-714F7F18B5DF@gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Thu, 2 May 2024 07:02:37 -0700
Message-ID: 
 <CAKFQuwY6-90W2sO=peE6xf1F07vpbf_4PdKa_bt=4=OAH1GMCw@mail.gmail.com>
Subject: Re: One parent record with 3 possible child records
To: Rob Sargent <robjsargent@gmail.com>
Cc: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>,
 JORGE MALDONADO <jorgemal1960@gmail.com>
Content-Type: multipart/alternative; boundary="0000000000006dc16b061779107a"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwY6-90W2sO%3DpeE6xf1F07vpbf_4PdKa_bt%3D4%3DOAH1GMCw%40mail.gmail.com>
Precedence: bulk

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

On Thu, May 2, 2024 at 6:37=E2=80=AFAM Rob Sargent <robjsargent@gmail.com> =
wrote:

> Presuming the id is unique in parent and child, what=E2=80=99s 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.

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

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><span style=3D"font-family:Arial,Helve=
tica,sans-serif">On Thu, May 2, 2024 at 6:37=E2=80=AFAM Rob Sargent &lt;<a =
href=3D"mailto:robjsargent@gmail.com">robjsargent@gmail.com</a>&gt; wrote:<=
/span><br></div></div><div class=3D"gmail_quote"><blockquote class=3D"gmail=
_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204=
,204);padding-left:1ex"><div style=3D"overflow-wrap: break-word;"><div><blo=
ckquote type=3D"cite">Presuming the id is unique in parent and child, what=
=E2=80=99s the value of the type field in the foreign key?=C2=A0 Are you sa=
ying the PK on tableMain is (type,id), perhaps for clustering purposes?<br>=
</blockquote></div><div><br></div></div></blockquote><div><br></div><div cl=
ass=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif">Prev=
enting the parent record from saying &quot;tblOne&quot; while the actual ID=
 value is present on &quot;tblTwo&quot;.</div><div class=3D"gmail_default" =
style=3D"font-family:arial,helvetica,sans-serif"><br></div><div class=3D"gm=
ail_default" style=3D"font-family:arial,helvetica,sans-serif">David J.</div=
><div class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-ser=
if"><br></div></div></div>

--0000000000006dc16b061779107a--