Postgres Pro
Downloads
Home   >   mailing lists

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

From Dickson S. Guedes
Subject Re: CREATE SCHEMA IF NOT EXISTS
Date
Msg-id CAHHcreo7jTvFdiHkLXTuHjF9MiQT5DjtXcvMWqVZ-yz11wyBog@mail.gmail.com
Whole thread Raw
In response to Re: CREATE SCHEMA IF NOT EXISTS  (Fabrízio de Royes Mello <fabriziomello@gmail.com>)
Responses Re: CREATE SCHEMA IF NOT EXISTS
List pgsql-hackers
Tree view 
2012/8/16 Fabrízio de Royes Mello <fabriziomello@gmail.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@guedesoft.net - skype: guediz
http://guedesoft.net - http://www.postgresql.org.br

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Regression tests fail once XID counter exceeds 2 billion
Next
From: Bruce Momjian
Date:
Subject: Re: RFC: list API / memory allocations