On 7/16/21 9:40 AM, Tom Lane wrote: > vignesh C <vignes...@gmail.com> writes: >> On Tue, Jul 13, 2021 at 9:16 PM Wu Haotian <wht...@gmail.com> wrote: >>> 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? > That would require pg_restore to try to edit the DROP commands during > restore, which sounds horribly fragile. I'm inclined to think that > supporting this option only during initial dump is safer. > >
Maybe, but that would push back the time when you would need to decide you needed this quite a lot. We could also have pg_dump stash a copy of the CASCADE variant in the TOC that could be used by pg_restore if required. I'm not sure if it's worth the trouble and extra space though. cheers andrew -- Andrew Dunstan EDB: https://www.enterprisedb.com
