Postgres Pro
Downloads
Home   >   mailing lists

Re: I can not drop a user/role because an object depent on it. - Mailing list pgsql-general

From Bill Moran
Subject Re: I can not drop a user/role because an object depent on it.
Date
Msg-id 20090930134552.93286390.wmoran@potentialtech.com
Whole thread Raw
In response to I can not drop a user/role because an object depent on it.  (Ricky Tompu Breaky <ricky.breaky@uni.de>)
Responses Re: I can not drop a user/role because an object depent on it.  (Ricky Tompu Breaky <ricky.breaky@uni.de>)
List pgsql-general
Tree view 
In response to Ricky Tompu Breaky <ricky.breaky@uni.de>:

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

The easiest way to accomplish this is to stop postgres, delete the
postgres data directory and rerun initdb.

--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/

pgsql-general by date:

Previous
From: Ricky Tompu Breaky
Date:
Subject: I can not drop a user/role because an object depent on it.
Next
From: Daniel F
Date:
Subject: Weird behavior with "sensitive" cursors.