| From: | "Dickson S(dot) Guedes" <listas(at)guedesoft(dot)net> |
|---|---|
| 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-17 00:44:22 |
| Message-ID: | CAHHcreo7jTvFdiHkLXTuHjF9MiQT5DjtXcvMWqVZ-yz11wyBog@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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?.
Best.
--
Dickson S. Guedes
mail/xmpp: guedes(at)guedesoft(dot)net - skype: guediz
http://guedesoft.net - http://www.postgresql.org.br
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2012-08-17 00:46:19 | Re: RFC: list API / memory allocations |
| Previous Message | Bruce Momjian | 2012-08-17 00:09:01 | Re: Regression tests fail once XID counter exceeds 2 billion |