Re: Patch to add support of "IF NOT EXISTS" to others "CREATE" statements
| От | Fabrízio de Royes Mello |
|---|---|
| Тема | Re: Patch to add support of "IF NOT EXISTS" to others "CREATE" statements |
| Дата | |
| Msg-id | CAFcNs+qZKeK+MT+ftTpFFbD3mxFVLKvXEXZuKothoFBb6oGyLQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Patch to add support of "IF NOT EXISTS" to others "CREATE" statements (Peter Eisentraut <peter_e@gmx.net>) |
| Список | pgsql-hackers |
On Thu, Jun 20, 2013 at 1:24 PM, Peter Eisentraut <peter_e@gmx.net> wrote:
Well, my intention is do that for all CREATE commands.
--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Blog sobre TI: http://fabriziomello.blogspot.com
>> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
>> Twitter: http://twitter.com/fabriziomello
On 6/20/13 11:04 AM, Robert Haas wrote:I tend to agree.
> I kind of don't see the point of having IF NOT EXISTS for things that
> have OR REPLACE, and am generally in favor of implementing OR REPLACE
> rather than IF NOT EXISTS where possible.
I agree if is possible to have OR REPLACE then we must do that, but in other hands
I don't see a problem if we have support to both IF NOT EXISTS and OR REPLACE. In
some cases we don't really want to replace the object body if its already exists so
IF NOT EXISTS is useful to don't break the transaction inside a upgrade script.
>> > Btw., I also want REPLACE BUT DO NOT CREATE.If you run an upgrade SQL script that is supposed to replace, say, a
> That's a mouthful. What's it good for?
bunch of functions with new versions, you'd want the behavior that it
replaces the existing function if it exists, but errors out if it
doesn't, because then you're perhaps connected to the wrong database.
It's a marginal feature, and I'm not going to pursue it, but if someone
wanted to make the CREATE commands fully featured, there is use for this.
Well, my intention is do that for all CREATE commands.
Regards,
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Blog sobre TI: http://fabriziomello.blogspot.com
>> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
>> Twitter: http://twitter.com/fabriziomello
В списке pgsql-hackers по дате отправления: