Re: CREATE SCHEMA IF NOT EXISTS

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: CREATE SCHEMA IF NOT EXISTS
Дата
Msg-id 1349204729-sup-3710@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: CREATE SCHEMA IF NOT EXISTS  ("Dickson S. Guedes" <listas@guedesoft.net>)
Ответы Re: CREATE SCHEMA IF NOT EXISTS
Список pgsql-hackers
The fundamental issue with this patch hasn't been answered sufficiently,
I think.  Consider the following sequence of commands:

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.

I think this needs more thought, and in any case it needs more
comprehensive regression test and documentation (i.e. at least the
examples ought to explain what would happen in such cases).

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services



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

Предыдущее
От: Noah Misch
Дата:
Сообщение: Re: Raise a WARNING if a REVOKE affects nothing?
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: Hash id in pg_stat_statements