| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | dfgpostgres <dfgpostgres3(at)gmail(dot)com> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Can "on delete cascade" dependency be used in pgdump or similar ? |
| Date: | 2026-02-27 22:57:54 |
| Message-ID: | CAKFQuwZ-PvXH_0QCxxWm9FujnyLQxVKo+aGDzOSqdxKeANzTFw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Feb 27, 2026 at 3:40 PM dfgpostgres <dfgpostgres3(at)gmail(dot)com> wrote:
> But what would be really neat is to leverage that cascade on delete stuff
> 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2026-02-27 23:13:52 | Re: Can "on delete cascade" dependency be used in pgdump or similar ? |
| Previous Message | dfgpostgres | 2026-02-27 22:39:39 | Can "on delete cascade" dependency be used in pgdump or similar ? |