Re: best practice transitioning from one datatype to another

CG <cgg007@yahoo.com> writes:
> While transitioning from 8.1 to 8.4, I need to�transition to�the internal UUID type in place of the
contrib/uniqueidentifiermodule. I've built the database around uniqueidentifier, so nearly every table has one column
ofthat data type. It's going to be tedious to  

> ALTER TABLE foo ALTER COLUMN bar SET DATA TYPE uuid;
> ...repeat 600 times...

> I'll�also have to drop�and reload the�views and the rules on tables. It'll be tedious even if the tables have no data
inthem.  

> Can anyone recommend�a better/faster way to make the transition?

Couldn't you rename the type to uuid in the 8.1 database before you
dump?

            regards, tom lane