On Sat, Jan 18, 2014 at 11:12 PM, Stephen Frost <sfr...@snowman.net> wrote: > > Fabrízio, can you clarify the use-case for things like CREATE AGGREGATE > to have IF NOT EXISTS rather than OR REPLACE, or if there is a reason > why both should exist? Complicating our CREATE options is not something > we really wish to do without good reason and we certainly don't want to > add something now that we'll wish to remove in another version or two. >
Hi Stephen, First I'm really sorry about the long time without an answer. I'm very busy in this start of the year. Well I have a scenario with many servers to deploy DDL scripts, and most of them we must run without transaction control because some tasks like CREATE INDEX CONCURRENTLY, DROP/CREATE DATABASE, CLUSTER, etc. When an error occurs the script stops, but the previous commands was commited, then we must review the script to comment parts that was already executed and then run it again. Until now is not a really trouble, but in some cases we must deploy another DDL script that contains a new version of some object before we finish to fix the previous version that was in production, and if we have CINE for all CREATE objects this task will more easy because we just run it again without care if will replace the content and do not produce an error. I know that is a very specific case, but in my mind I don't see any problem to have CINE and COR to this objects. The behavior is totally different. Regards, -- Fabrízio de Royes Mello Consultoria/Coaching PostgreSQL >> Timbira: http://www.timbira.com.br >> Blog sobre TI: http://fabriziomello.blogspot.com >> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello >> Twitter: http://twitter.com/fabriziomello