I'd like to propose adding `--drop-cascade` option for pg_dump/restore
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 CASCADE DROP is needed.
This allows for restoring an old backup after adding new constraints,
at the risk of losing new data.
There're already some requests for supporting cascade drop: