On Wed, 30 Sep 2009 11:38:19 -0700 Adrian Klaver <aklaver@xxxxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
