----- "Ricky Tompu Breaky" <ricky.breaky@xxxxxx> wrote: > 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. 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@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
