Re: CREATE SCHEMA IF NOT EXISTS

Поиск
Список
Период
Сортировка
От David E. Wheeler
Тема Re: CREATE SCHEMA IF NOT EXISTS
Дата
Msg-id 6C98E3D5-F93F-4BED-B8CF-BBE2072AB2D3@justatheory.com
обсуждение исходный текст
Ответ на Re: CREATE SCHEMA IF NOT EXISTS  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Ответы Re: CREATE SCHEMA IF NOT EXISTS
Список pgsql-hackers
On Oct 2, 2012, at 12:08 PM, Alvaro Herrera <alvherre@2ndquadrant.com> wrote:

> create schema if not exists foo create table first (a int);
> create schema if not exists foo create table second (a int);
>
>
> As far as I can see, with the patch as it currently stands, you would
> end up with only table "first" in the schema, which seems very
> surprising to me.

Yeah, I think the second should die. CINE should only work if there are no other objects created as part of the
statement,IMHO. 

Best,

David




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

Предыдущее
От: "David Johnston"
Дата:
Сообщение: Re: Raise a WARNING if a REVOKE affects nothing?
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: CREATE SCHEMA IF NOT EXISTS