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 ? -- 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
