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(at)justatheory(dot)com
> <mailto:david(at)justatheory(dot)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