Re: How to remove a superuser

From: Richard Ray <rray(at)mstc(dot)state(dot)ms(dot)us>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: How to remove a superuser
Date: 2006-10-11 13:02:07
Message-ID: Pine.LNX.4.64.0610110759530.12126@rray.drdc.mstc.ms.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, 10 Oct 2006, Tom Lane wrote:

> Richard Ray <rray(at)mstc(dot)state(dot)ms(dot)us> writes:
>> I can reassign the view but not the type.
>
> You don't need to reassign the type's ownership, because it's just part
> of the view.
>

After I reassigned all the views I was allowed to drop the user.

Thanks

> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Andrew Sullivan 2006-10-11 14:28:44 Re: postgres in HA constellation
Previous Message Brandon Aiken 2006-10-11 12:56:09 Re: [ADMIN] Copying data from table to table (cloned tables)