CG <cgg007@xxxxxxxxx> writes: > While transitioning from 8.1 to 8.4, I need to transition to the internal UUID type in place of the contrib/uniqueidentifier module. I've built the database around uniqueidentifier, so nearly every table has one column of that 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 in them. > 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
