Re: CREATE SCHEMA IF NOT EXISTS

2012/8/17 Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>

> Excerpts from Dickson S. Guedes's message of vie ago 17 10:37:25 -0400
> 2012:
> > 2012/8/17 Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>:
> > >
> > > 2012/8/17 Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
> > >>
> > >> Excerpts from Fabrízio de Royes Mello's message of vie ago 17 09:16:30
> > >> -0400 2012:
> > >>
> > >> > The attached patch contains regression tests for it.
> > >>
> > >> I think you're missing support in copyfuncs.c and equalfuncs.c for the
> > >> new field in the node.
> > >
> > > You're completely right, thanks...
> > >
> > > The attached patch add support for the new field in the node in
> > > "copyfuncs.c" and "equalfuncs.c".
> >
> > Maybe I'm missing something but shouldn't it being handled in
> extension.c too?
>
> Please be more explicit? I don't know what you mean.
>
>
Returning conversation to the list.

I think he talked about this piece of code:

diff --git a/src/backend/commands/extension.c
b/src/backend/commands/extension.c
index 8512cdb..e359a9c 100644
--- a/src/backend/commands/extension.c
+++ b/src/backend/commands/extension.c
@@ -1374,6 +1374,7 @@ CreateExtension(CreateExtensionStmt *stmt)
csstmt->schemaname = schemaName;
csstmt->authid = NULL; /* will be created
by current user */
csstmt->schemaElts = NIL;
+ csstmt->if_not_exists = false;
CreateSchemaCommand(csstmt, NULL);

/*

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