Add option --drop-cascade for pg_dump/restore

Поиск
Список
Период
Сортировка
От Haotian Wu
Тема Add option --drop-cascade for pg_dump/restore
Дата
Msg-id CADHB_-Bk2zQdzi14gmjt=4k3+p1=TkibQwfeEaqAr1Zkd=T6AQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Add option --drop-cascade for pg_dump/restore
Список pgsql-hackers

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 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:


Design & Implementation


Basically I'm following the changes in adding `--if-exists` patch: https://github.com/postgres/postgres/commit/9067310cc5dd590e36c2c3219dbf3961d7c9f8cb . pg_dump/restore will inject a CASCADE clause to each DROP command.



The attached patch has been tested on our old backup. I'm happy to get some feedback.
Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: SQL-standard function body
Следующее
От: Andres Freund
Дата:
Сообщение: Re: SQL-standard function body