Re: Problems with ENUM type manipulation in 9.1 - Mailing list pgsql-bugs

From Josh Kupershmidt
Subject Re: Problems with ENUM type manipulation in 9.1
Date
Msg-id CAK3UJRF3r69tXQaLxPQq-TPL_CZekbxX0nboKxsac1biXsZupg@mail.gmail.com
Whole thread Raw
In response to Re: Problems with ENUM type manipulation in 9.1  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Problems with ENUM type manipulation in 9.1  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problems with ENUM type manipulation in 9.1
Next
From: Tom Lane
Date:
Subject: Re: BUG #6231: weird to_timestamp behaviour with out of range values