> I wouldn't try this without running it against a test database copy first.
> I've already discovered that a backend change to a column data type like your
> describing can disrupt indexes, views, and analyze rows based on the table --
> the last time I did such, I ended up having to dump and reload the database
> to get everything responding reliably.
Yeah, I just remembered table types and pg_depend entries, so I'm not
really keen to do it any more :/
Chris