Marcin Inkielman <marn(at)wsisiz(dot)edu(dot)pl> writes:
> I am migrating a relativly huge database from postgres 7.2 to 8.0. I
> need to alter schema
> for sth about 500 tables and twice as many other objects. Do I need to
> sth other on a new database than:
I'd suggest updating to 8.1 (where there's ALTER SET SCHEMA commands)
instead of trying to mess with the system catalogs by hand. Your sketch
fails to account for updating pg_depend, and I'm not sure offhand if you
missed anything else.
regards, tom lane