Re: a modest improvement to get_object_address()

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: a modest improvement to get_object_address()
Дата
Msg-id CA+TgmobeCrQb-2kuL6BACHBy7T_pexOUn3C8HahSPF-i74S9sg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: a modest improvement to get_object_address()  (Cédric Villemain <cedric.villemain.debian@gmail.com>)
Ответы Re: a modest improvement to get_object_address()  (Cédric Villemain <cedric.villemain.debian@gmail.com>)
Список pgsql-hackers
On Wed, Nov 9, 2011 at 8:37 AM, Cédric Villemain
<cedric.villemain.debian@gmail.com> wrote:
> Maybe I miss something but:
> The ERROR message is misleading:  the schema 'x' does exist.

No, it doesn't.  The concurrent transaction has dropped it.

> And also
> why a drop schema would fail and a drop+create would success ?!

Because you can't comment on a schema that doesn't exist any more, but
you can comment on one that does.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Materialized views
Следующее
От: Jaime Casanova
Дата:
Сообщение: Re: Syntax for partitioning