"Tom Dunstan" <pgsql@tomd.cc> writes:
> On Sat, Apr 26, 2008 at 2:51 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Further, as already noted, if you do have to rewrite then a series of
>> manual ALTER COLUMN TYPE operations would probably be a *better* answer
>> than a monolithic implementation, because of the locking problems
>> involved in doing it in one transaction.
> I don't understand this if it's calling option 2 the monolithic
> implementation.
No, I was imagining an option-1 implementation trying to support
rewriting of all affected tables in a single "monolithic" command.
regards, tom lane