2011/11/15 Tom Lane <t...@sss.pgh.pa.us>: > Pavel Stehule <pavel.steh...@gmail.com> writes: >> 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. > > That is not going to be possible unless we commit to having an IF EXISTS > option for every type of DROP statement, now and in the future. > Even then, it's not apparent to me that it solves any real use-case. > You're probably better off just using --clean and ignoring any errors. >
ook Regards Pavel Stehule > regards, tom lane > -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers