Re: Problems with ENUM type manipulation in 9.1

Поиск
Список
Период
Сортировка
От Josh Kupershmidt
Тема Re: Problems with ENUM type manipulation in 9.1
Дата
Msg-id CAK3UJRF3r69tXQaLxPQq-TPL_CZekbxX0nboKxsac1biXsZupg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Problems with ENUM type manipulation in 9.1  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: Problems with ENUM type manipulation in 9.1
Список pgsql-bugs
On Wed, Sep 28, 2011 at 10:51 AM, Alvaro Herrera
<alvherre@commandprompt.com> wrote:
> Excerpts from depstein's message of mi=E9 sep 28 07:21:17 -0300 2011:
>> Anyway, the procedure that we used (based on
>> http://en.dklab.ru/lib/dklab_postgresql_enum/) does the necessary
>> checks before removing enum values.

Not exactly; that code is rife with race conditions. For instance, how
does the "Check data references" loop ensure that previously-checked
tables don't get a new row containing the forbidden enum_elem before
the function is finished?

Josh

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Problems with ENUM type manipulation in 9.1
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #6231: weird to_timestamp behaviour with out of range values