Andrew Dunstan <[EMAIL PROTECTED]> writes:
> Alvaro Herrera wrote:
>> Another alternative would be internally creating a different temporary
>> enum, rewriting the tables one by one each on its own transaction, and
>> finish by dropping the original enum and renaming the temporary 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
