Re: Re: [COMMITTERS] pgsql: Update: < * Allow adding enumerated values to an existing

Andrew Dunstan <andrew@[EMAIL PROTECTED]
> writes:
> Alvaro Herrera wrote:
>> Another alternative would be internally creating a different tem****ary
>> enum, rewriting the tables one by one each on its own transaction, and
>> finish by dropping the original enum and renaming the tem****ary one.
>> This solves the deadlock problem.

> What happens when someone tries to join two of the tables, one that has 
> been converted and one that hasn't? You might not have deadlock, but you

> won't have type integrity either, ISTM.

Not to mention the mess you'll be left with if the process fails after
converting some of the tables.

			regards, tom lane

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers