Re: I can not drop a user/role because an object depent on it.

----- "Ricky Tompu Breaky" <ricky(dot)breaky(at)uni(dot)de> wrote:

> On Wed, 30 Sep 2009 11:38:19 -0700
> Adrian Klaver <aklaver(at)comcast(dot)net> wrote:
>
> > On Wednesday 30 September 2009 10:43:35 am Ricky Tompu Breaky
> wrote:
> > > Dear my friends....
> > >
> > > I can not drop a user because another object need it. How can I
> know
> > > which object need it? I really want to drop everything inside my
> > > PostgreSQL, to reset my installation really from beginning.
> > >
> > > postgres=# drop user ivia;
> > > FEHLER: kann Rolle »ivia« nicht löschen, weil andere Objekte
> davon
> > > abhängen DETAIL: Eigentümer von Datenbank iVia
> > > 7 Objekte in Datenbank iVia-->mytranslation: Error: can not
> delete
> > > Role »ivia«, because another object depend on it DETAIL: owner of
> > > Database iVia.
> > > postgres=#
> > >
> > > I've dropped the database iVia.
> > >
> > > Thank you very much in advance.
> >
> > To clarify did you try to DROP USER ivia before or after you
> dropped
> > the database iVia ?
> >
>
> RB>It's solved. Thanks for your reply. You're correct, I wanted to
> drop
> RB>the user after I dropped the database. Now I know from you that in
> RB>PostgreSQL, I have to drop the user first before dropping the
> RB>database.

Not to belabor the point, but you have it backwards. The database needs to be dropped first, then the role/user. The database is owned by the role/user.

Adrian Klaver
aklaver(at)comcast(dot)net