Let's say you have a database which is owned (as well as all the contents within it) by the postgres internal user.
Having created or inherited a mess, how do you fix it?
database1=# REASSIGN OWNED BY postgres TO foo ;
ERROR: cannot reassign ownership of objects owned by role postgres because they are required by the database system
Is there some way simpler than going through every object of every type and doing an "ALTER <TYPE> <OBJECTNAME> OWNER to..." ?
This is on 9.2.4, but I think it applies to all versions.
Cheers,
Jeff