Re: CREATE SCHEMA IF NOT EXISTS

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