> > "ALTER SCHEMA foo OWNER TO bla" if you're a super user. > > And using 8.0... I saw that but was looking for a 7.4 solution...
Maybe: UPDATE pg_namespace SET nspowner=<bla-number> WHERE nspname='foo'; -- Fabien Coelho - [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster