Re: Add option --drop-cascade for pg_dump/restore - Mailing list pgsql-hackers

From vignesh C
Subject Re: Add option --drop-cascade for pg_dump/restore
Date
Msg-id CALDaNm0tNO6v_+W5uBKUmScpUaq9DDFut=OTFvokt=BqTTDWYQ@mail.gmail.com
Whole thread Raw
In response to Re: Add option --drop-cascade for pg_dump/restore  (Wu Haotian <whtsky@gmail.com>)
Responses Re: Add option --drop-cascade for pg_dump/restore  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Add option --drop-cascade for pg_dump/restore  (Wu Haotian <whtsky@gmail.com>)
List pgsql-hackers
On Tue, Jul 13, 2021 at 9:16 PM Wu Haotian <whtsky@gmail.com> wrote:
>
> > 2) I felt pg_dump will include the cascade option for plain format and
> > pg_restore will include the cascade option from pg_restore for other
> > formats. If my understanding is correct, should we document this?
>
> I may not understand it correctly, are you saying
> pg_dump will include the cascade option only for plain format, or
> pg_dump will enable the cascade option for plain by default?

pg_dump support plain, custom, tar and directory format, I think,
cascade option will be added by pg_dump only for plain format and for
the other format pg_restore will include the cascade option. Should we
document this somewhere?

> > 4) Is it possible to add a few tests for this?
>
> Looks like tests should be added to
> `src/bin/pg_dump/t/002_pg_dump.pl`, I'll try to add some.

Yes, that should be the right place.

Regards,
Vignesh



pgsql-hackers by date:

Previous
From: Aleksander Alekseev
Date:
Subject: Re: proposal: enhancing plpgsql debug API - returns text value of variable content
Next
From: James Coleman
Date:
Subject: Re: [PATCH] Use optimized single-datum tuplesort in ExecSort