Re: ToDo: pg_backup - using a conditional DROP - Mailing list pgsql-hackers

From Torello Querci
Subject Re: ToDo: pg_backup - using a conditional DROP
Date
Msg-id CA+igE6TvsXw3vhXnu5gptDv9=PFa_z0jC=xXJXZqVUeTUq6P=A@mail.gmail.com
Whole thread Raw
In response to ToDo: pg_backup - using a conditional DROP  (Pavel Stehule <pavel.stehule@gmail.com>)
List 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 by date:

Previous
From: Pavel Stehule
Date:
Subject: ToDo: pg_backup - using a conditional DROP
Next
From: Kohei KaiGai
Date:
Subject: Refactoring on DROP/ALTER SET SCHEMA/ALTER RENAME TO statement