MIME-Version: 1.0
References: <CAAcmDX_zrfbQ2ixpGH_92SqeM=OJs5wPuW2_F-P+SefjoQGUOQ@mail.gmail.com>
In-Reply-To: <CAAcmDX_zrfbQ2ixpGH_92SqeM=OJs5wPuW2_F-P+SefjoQGUOQ@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Sat, 28 Feb 2026 17:39:37 -0500
Message-ID: <CANzqJaDGNSrgbbAs7VoLHCgkFOf0c75WeyoWTsVKRrFoWC3gTw@mail.gmail.com>
Subject: Re: Can "on delete cascade" dependency be used in pgdump or similar ?
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000f8a753064bea0717"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaDGNSrgbbAs7VoLHCgkFOf0c75WeyoWTsVKRrFoWC3gTw%40mail.gmail.com>
Precedence: bulk

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

On Fri, Feb 27, 2026 at 5:40=E2=80=AFPM dfgpostgres <dfgpostgres3@gmail.com=
> wrote:

> pg 15.15 on linux
>
[snip]

>  Is there a better way to approach this problem of archiving one project
> (remembering that we do have the "on delete cascade" set up) ?
>

Yes.  postgres_fdw is what you want.  It will let you:
INSERT INTO archive.projects SELECT * FROM projects WHERE project=3D'a';
INSERT INTO archive.child1 SELECT * FROM child1 WHERE project=3D'a';
INSERT INTO archive.child2 SELECT * FROM child2 WHERE project=3D'a';
INSERT INTO archive.grandchild1 SELECT * FROM  archive.grandchild1 WHERE ..=
.

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

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

<div dir=3D"ltr"><div dir=3D"ltr">On Fri, Feb 27, 2026 at 5:40=E2=80=AFPM d=
fgpostgres &lt;<a href=3D"mailto:dfgpostgres3@gmail.com">dfgpostgres3@gmail=
.com</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_container"><=
blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-l=
eft:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr">pg=C2=A01=
5.15 on linux</div></blockquote><div>[snip]=C2=A0</div><blockquote class=3D=
"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(2=
04,204,204);padding-left:1ex"><div dir=3D"ltr">=C2=A0Is there a better way =
to approach this problem of archiving one project (remembering that we do h=
ave the &quot;on delete cascade&quot; set up) ?</div></blockquote></div><di=
v><br></div><div>Yes.=C2=A0 postgres_fdw is what you want.=C2=A0 It will le=
t you:</div><div>INSERT INTO archive.projects SELECT * FROM projects WHERE =
project=3D&#39;a&#39;;</div><div><div>INSERT INTO archive.child1 SELECT * F=
ROM child1 WHERE project=3D&#39;a&#39;;</div><div><div>INSERT INTO archive.=
child2 SELECT * FROM child2 WHERE project=3D&#39;a&#39;;</div><div>INSERT I=
NTO archive.grandchild1=C2=A0SELECT * FROM=C2=A0

archive.grandchild1=C2=A0WHERE ...</div></div></div><div><br></div><span cl=
ass=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmai=
l_signature"><div dir=3D"ltr">Death to &lt;Redacted&gt;, and butter sauce.<=
div>Don&#39;t boil me, I&#39;m still alive.<br><div><div>&lt;Redacted&gt; l=
obster!</div></div></div></div></div></div>

--000000000000f8a753064bea0717--