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: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Fri, 27 Feb 2026 15:57:54 -0700
Message-ID: <CAKFQuwZ-PvXH_0QCxxWm9FujnyLQxVKo+aGDzOSqdxKeANzTFw@mail.gmail.com>
Subject: Re: Can "on delete cascade" dependency be used in pgdump or similar ?
To: dfgpostgres <dfgpostgres3@gmail.com>
Cc: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000fe020f064bd62c5f"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwZ-PvXH_0QCxxWm9FujnyLQxVKo%2BaGDzOSqdxKeANzTFw%40mail.gmail.com>
Precedence: bulk

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

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

>  But what would be really neat is to leverage that cascade on delete stuf=
f
> to just pgdump project "a" and use that to create "a_archive".
>
> Can pgdump do something like that ?
>

No, it cannot.

Is there a better way to approach this problem of archiving one project
> (remembering that we do have the "on delete cascade" set up) ?
>
>
Nothing built into core.  The only additional feature you could leverage is
on delete triggers.  But you'd need some custom code for maintenance to
ensure all relevant tables have the cascade delete and on delete triggers.

David J.

--000000000000fe020f064bd62c5f
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 Fri, Feb 27, 2026 at 3:40=E2=80=AFPM dfgpostgres &lt;<a=
 href=3D"mailto:dfgpostgres3@gmail.com">dfgpostgres3@gmail.com</a>&gt; wrot=
e:</span></div></div><div class=3D"gmail_quote gmail_quote_container"><bloc=
kquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:=
1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div>=C2=A0Bu=
t what would be really neat is to leverage that cascade on delete stuff to =
just pgdump=C2=A0project &quot;a&quot; and use that to create &quot;a_archi=
ve&quot;.=C2=A0=C2=A0</div><div><br></div><div>Can pgdump=C2=A0do something=
 like that ?</div></div></blockquote><div><br></div><div class=3D"gmail_def=
ault" style=3D"font-family:arial,helvetica,sans-serif">No, it cannot.</div>=
<div class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-seri=
f"><br></div><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 dir=3D"=
ltr"><div>Is there a better way to approach this problem of archiving one p=
roject (remembering that we do have the &quot;on delete cascade&quot; set u=
p) ?</div><div><br></div></div></blockquote><div><br></div><div class=3D"gm=
ail_default" style=3D"font-family:arial,helvetica,sans-serif">Nothing built=
 into core.=C2=A0 The only additional feature you could leverage=C2=A0is on=
 delete triggers.=C2=A0 But you&#39;d need some custom code for maintenance=
 to ensure all relevant tables have the cascade delete and on delete trigge=
rs.</div><div class=3D"gmail_default" style=3D"font-family:arial,helvetica,=
sans-serif"><br></div><div class=3D"gmail_default" style=3D"font-family:ari=
al,helvetica,sans-serif">David J.</div><div class=3D"gmail_default" style=
=3D"font-family:arial,helvetica,sans-serif"><br></div></div></div>

--000000000000fe020f064bd62c5f--