Marcin Inkielman <marn@xxxxxxxxxxxxx> 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
