I can not drop a user/role because an object depent on it.
- From: Ricky Tompu Breaky <ricky(dot)breaky(at)uni(dot)de>
- To: pgsql-general(at)postgresql(dot)org
- Subject: I can not drop a user/role because an object depent on it.
- Date: Thu, 1 Oct 2009 00:43:35 +0700
- Message-id: <20091001004335.2a1deb3f@uni.de> <text/plain>
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.
Home |
Main Index |
Thread Index