Re: CREATE SCHEMA IF NOT EXISTS

From: "David E(dot) Wheeler" <david(at)justatheory(dot)com>
To: fabriziomello(at)gmail(dot)com
Cc: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: CREATE SCHEMA IF NOT EXISTS
Date: 2012-08-16 17:49:43
Message-ID: 32D10431-F1A9-4F98-A23F-1D2CC15EFABB@justatheory.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Aug 16, 2012, at 10:36 AM, Fabrízio de Royes Mello wrote:

> The attached patch implement this feature:
>
> CREATE SCHEMA [ IF NOT EXISTS ] schema_name [ AUTHORIZATION user_name ] [ schema_element [ ... ] ]
> CREATE SCHEMA [ IF NOT EXISTS ] AUTHORIZATION user_name [ schema_element [ ... ] ]
>
> Now, PostgreSQL don't trow an error if we use "IF NOT EXISTS" in "CREATE SCHEMA" statement.
>
> So, I don't know the next steps...

Awesome, thanks! Please add it to the next CommitFest:

https://commitfest.postgresql.org/action/commitfest_view?id=15

Best,

David

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fabrízio de Royes Mello 2012-08-16 17:55:03 Re: CREATE SCHEMA IF NOT EXISTS
Previous Message Andrew Dunstan 2012-08-16 17:43:09 Re: CREATE SCHEMA IF NOT EXISTS