Re: I can not drop a user/role because an object depent on it.

From: Bill Moran <wmoran(at)potentialtech(dot)com>
To: Ricky Tompu Breaky <ricky(dot)breaky(at)uni(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: I can not drop a user/role because an object depent on it.
Date: 2009-09-30 17:45:52
Message-ID: 20090930134552.93286390.wmoran@potentialtech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In response to Ricky Tompu Breaky <ricky(dot)breaky(at)uni(dot)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/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2009-09-30 18:09:10 Re: Weird behavior with "sensitive" cursors.
Previous Message Ricky Tompu Breaky 2009-09-30 17:43:35 I can not drop a user/role because an object depent on it.