| From: | Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com> |
|---|---|
| To: | "Dickson S(dot) Guedes" <listas(at)guedesoft(dot)net> |
| Cc: | Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: CREATE SCHEMA IF NOT EXISTS |
| Date: | 2012-08-17 13:16:30 |
| Message-ID: | CAFcNs+qW7DeNV7+PcBD9HzZnm5TZsNhTVXhbRR9xurP-kFG6pA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
2012/8/16 Dickson S. Guedes <listas(at)guedesoft(dot)net>
> 2012/8/16 Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>:
> > 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.
>
> I started testing this, but I didn't see regression tests for it.
> Could you write them?.
>
>
The attached patch contains regression tests for it.
Regards,
--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Blog sobre TI: http://fabriziomello.blogspot.com
>> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
>> Twitter: http://twitter.com/fabriziomello
| Attachment | Content-Type | Size |
|---|---|---|
| create_schema_if_not_exists_v2.patch | application/octet-stream | 5.7 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fabrízio de Royes Mello | 2012-08-17 13:42:26 | Re: CREATE SCHEMA IF NOT EXISTS |
| Previous Message | Peter Eisentraut | 2012-08-17 05:43:21 | Re: external_pid_file not removed on postmaster exit |