Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #1222: database owner should have implicit control - Mailing list pgsql-bugs

From Fabien COELHO
Subject Re: BUG #1222: database owner should have implicit control
Date
Msg-id Pine.LNX.4.58.0408190941330.31684@sablons.cri.ensmp.fr
Whole thread Raw
In response to Re: BUG #1222: database owner should have implicit control  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-bugs
Tree view 
> > "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 - coelho@cri.ensmp.fr

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: BUG #1224: Restarting postgres appends extra -D argument
Next
From: Frank van Vugt
Date:
Subject: vacuumlo fails in the presence of a index on expression - demo sql included