Skip site navigation (1) Skip section navigation (2)

pgsql: Support CREATE SCHEMA IF NOT EXISTS.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Support CREATE SCHEMA IF NOT EXISTS.
Date: 2012-10-03 23:47:26
Message-ID: E1TJYf0-00014M-Om@gemulon.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Support CREATE SCHEMA IF NOT EXISTS.

Per discussion, schema-element subcommands are not allowed together with
this option, since it's not very obvious what should happen to the element
objects.

Fabrízio de Royes Mello

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/fb34e94d214d6767910df47aa7c605c452d11c57

Modified Files
--------------
doc/src/sgml/ref/create_schema.sgml     |   27 +++++++++++++++++++++++
src/backend/commands/extension.c        |    1 +
src/backend/commands/schemacmds.c       |   17 +++++++++++++++
src/backend/nodes/copyfuncs.c           |    1 +
src/backend/nodes/equalfuncs.c          |    1 +
src/backend/parser/gram.y               |   35 +++++++++++++++++++++++++++++++
src/include/nodes/parsenodes.h          |    1 +
src/test/regress/expected/namespace.out |   13 +++++++++++
src/test/regress/sql/namespace.sql      |    9 ++++++++
9 files changed, 105 insertions(+), 0 deletions(-)

pgsql-committers by date

Next:From: Heikki LinnakangasDate: 2012-10-04 07:36:43
Subject: pgsql: Fix typo in comment, and reword it slightly while we're at it.
Previous:From: Alvaro HerreraDate: 2012-10-03 21:22:21
Subject: pgsql: refactor ALTER some-obj SET OWNER implementation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group