Re: ToDo: pg_backup - using a conditional DROP

Поиск
Список
Период
Сортировка
От Torello Querci
Тема Re: ToDo: pg_backup - using a conditional DROP
Дата
Msg-id CA+igE6TvsXw3vhXnu5gptDv9=PFa_z0jC=xXJXZqVUeTUq6P=A@mail.gmail.com
обсуждение исходный текст
Ответ на ToDo: pg_backup - using a conditional DROP  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-hackers
2011/11/15 Pavel Stehule <pavel.stehule@gmail.com>:
> Hello,
>
> there is a request on enhancing of pg_backup to produce a conditional
> DROPs. A reason for this request is more simple usage in very dynamic
> production - cloud BI solution.
>
> pg_backup can have a new option "--conditional-drops" and then pg_dump
> will produce a DROP IF EXISTS statements instead DROP statements.
>
> Ideas, comments?
>
I think that if there is other way to get the same result in other way
is better to use it without add new options.

In this case, if you are on unix environment, I suppose that you can
use external batch to manipulate the output file, like "sed" I
suppose.
Obviusly this is my personal opinion.


Best Regards
Torello
> Regards
>
> Pavel Stehule
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>


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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: ToDo: pg_backup - using a conditional DROP
Следующее
От: Kohei KaiGai
Дата:
Сообщение: Refactoring on DROP/ALTER SET SCHEMA/ALTER RENAME TO statement