Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group