Postgres Pro
Downloads
Home   >   mailing lists

Re: CREATE SCHEMA IF NOT EXISTS - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: CREATE SCHEMA IF NOT EXISTS
Date
Msg-id 502D312D.30804@dunslane.net
Whole thread Raw
In response to Re: CREATE SCHEMA IF NOT EXISTS  (Fabrízio de Royes Mello <fabriziomello@gmail.com>)
List pgsql-hackers
Tree view 
On 08/16/2012 01:36 PM, Fabrízio de Royes Mello wrote:
>
>
> 2012/8/15 David E. Wheeler <david@justatheory.com
> <mailto:david@justatheory.com>>
>
>     On Aug 15, 2012, at 11:31 AM, Fabrízio de Royes Mello wrote:
>
>     >> Is there any reason not to add $subject? Would it be difficult?
>     >
>     > Looking to the source code I think this feature isn't hard to
>     implement... I'm writing a little path to do that and I'll send
>     soon...
>
>     Cool, thanks!
>
>
> 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...


Please see
<http://wiki.postgresql.org/wiki/Developer_FAQ#I_have_developed_a_patch.2C_what_next.3F>

cheers

andrew

pgsql-hackers by date:

Previous
From: Fabrízio de Royes Mello
Date:
Subject: Re: CREATE SCHEMA IF NOT EXISTS
Next
From: "David E. Wheeler"
Date:
Subject: Re: CREATE SCHEMA IF NOT EXISTS