Re: CREATE SCHEMA IF NOT EXISTS
Fabrízio de Royes Mello <fabriziomello@gmail.com>
From: Fabrízio de Royes Mello <fabriziomello@gmail.com>
To: Pgsql Hackers <pgsql-hackers@postgresql.org>, Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: "Dickson S. Guedes" <listas@guedesoft.net>
Date: 2012-08-17T21:22:16Z
Lists: pgsql-hackers
Attachments
- create_schema_if_not_exists_v5.patch (application/octet-stream) patch v5
2012/8/17 Alvaro Herrera <alvherre@2ndquadrant.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@gmail.com>:
> > >
> > > 2012/8/17 Alvaro Herrera <alvherre@2ndquadrant.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
Commits
Same data as JSON:
GET /api/v1/messages/:b64id/commits
the thread's linked commits as JSON, with link sources.
API reference →
-
Document the lack of reading the PGDATABASE environment variable in
- 483c2c1071c4 9.3.0 cited