Re: CREATE SCHEMA IF NOT EXISTS

Поиск
Список
Период
Сортировка
От Fabrízio de Royes Mello
Тема Re: CREATE SCHEMA IF NOT EXISTS
Дата
Msg-id CAFcNs+p9cFGX9YFir-Cp3jOc8HvfWxMRcLr7uyc_kia5b1NhZw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: CREATE SCHEMA IF NOT EXISTS  ("David E. Wheeler" <david@justatheory.com>)
Ответы Re: CREATE SCHEMA IF NOT EXISTS
Re: CREATE SCHEMA IF NOT EXISTS
Re: CREATE SCHEMA IF NOT EXISTS
Список pgsql-hackers


2012/8/15 David E. Wheeler <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...

Regards,

--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Blog sobre TI: http://fabriziomello.blogspot.com

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: The pgrminclude problem
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: CREATE SCHEMA IF NOT EXISTS