MIME-Version: 1.0
References: <CANzqJaD1JNeJfNJkxZOvqSw=ueJLzq3hM3tUf5FJNkbxEr8Z4A@mail.gmail.com>
 <6511b21d495f1c010f05ae9841ee3fdc649dcff2.camel@cybertec.at>
 <CANzqJaB3rHWWHQD2aUqrQvZcdo_doOKTNFcMkBnkvoTt4_JriA@mail.gmail.com>
 <9dccf4f8-2d45-4e6e-a374-1de66d6cc243@aklaver.com> <CANzqJaDbrmgAXmctgFR62o22+CMYnNjmKd06uX9RD3jjUj9u=Q@mail.gmail.com>
 <2263e480-ce7c-4e85-bc90-ba095d4711db@aklaver.com> <CANzqJaB-Sb_KXJZGB++9n9ymMLC0_YB876acX1tNNdjsPskbWw@mail.gmail.com>
 <a2d3e910-3f6e-42a0-858b-65a90da6ab7c@aklaver.com>
In-Reply-To: <a2d3e910-3f6e-42a0-858b-65a90da6ab7c@aklaver.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Fri, 13 Feb 2026 15:17:36 -0500
Message-ID: <CANzqJaCybV8TjOODr8XFEzjNLLGeUzEuWNhVXGGepDxAZLR70A@mail.gmail.com>
Subject: Re: pg_restore failed on foreign key constraint
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000070958b064aba4c99"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaCybV8TjOODr8XFEzjNLLGeUzEuWNhVXGGepDxAZLR70A%40mail.gmail.com>
Precedence: bulk

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

On Fri, Feb 13, 2026 at 12:35=E2=80=AFPM Adrian Klaver <adrian.klaver@aklav=
er.com>
wrote:
[snip]

> >
> > Thus, while new and modified records are being added
> > to public.access_email at the source, they are not making it to the
> > Target database.  That plus "--disable-triggers" lets
> > the public.rel_user_email loads succeed on the target even though it
> > breaks RI.
>
> This means you know what the issue is now?
>

Yes it does. =F0=9F=98=80

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

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

<div dir=3D"ltr"><div dir=3D"ltr">On Fri, Feb 13, 2026 at 12:35=E2=80=AFPM =
Adrian Klaver &lt;<a href=3D"mailto:adrian.klaver@aklaver.com">adrian.klave=
r@aklaver.com</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_con=
tainer"><div>[snip]=C2=A0</div><blockquote class=3D"gmail_quote" style=3D"m=
argin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left=
:1ex">
&gt; <br>
&gt; Thus, while new and modified records are being added <br>
&gt; to=C2=A0public.access_email at the source, they are not making it to t=
he <br>
&gt; Target database.=C2=A0 That plus &quot;--disable-triggers&quot; lets <=
br>
&gt; the=C2=A0public.rel_user_email loads succeed on the target even though=
 it <br>
&gt; breaks RI.<br>
<br>
This means you know what the issue is now?<br></blockquote><div></div></div=
><div><br></div><div>Yes it does.=C2=A0=F0=9F=98=80</div><div><br></div><sp=
an class=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D=
"gmail_signature"><div dir=3D"ltr">Death to &lt;Redacted&gt;, and butter sa=
uce.<div>Don&#39;t boil me, I&#39;m still alive.<br><div><div>&lt;Redacted&=
gt; lobster!</div></div></div></div></div></div>

--00000000000070958b064aba4c99--