Re: Add option --drop-cascade for pg_dump/restore

2021-07-01 Thread Haotian Wu
Hi, I agree that —drop-cascade does not make sense for pg_dumpall, so I removed them. > are we expecting more things to appear after the semi-colon? No, I was just trying to “reuse” original statement as much as possible. Append “\n” manually should also do the job, and I’ve updated the patch

Add option --drop-cascade for pg_dump/restore

2021-04-08 Thread Haotian Wu
Hello, I'd like to propose adding `--drop-cascade` option for pg_dump/restore Usecase: I'd like to be able to restore an old custom format database dump as a single transaction ( so the current data won't lose if restore fails). The database has added some new constraints after backup so a CASC