On Tue, 10 Oct 2006, Tom Lane wrote:
Richard Ray <[EMAIL PROTECTED]> 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
On Tue, Oct 10, 2006 at 04:07:19PM -0500, Richard Ray wrote:
> On Tue, 10 Oct 2006, Jim C. Nasby wrote:
>
> >On Tue, Oct 10, 2006 at 02:22:53PM -0500, Richard Ray wrote:
> >>I need to drop a superuser account. I get
> >>
> >>dba=# drop role bram;
> >>ERROR: role "bram" cannot be dropped because s
Richard Ray <[EMAIL PROTECTED]> 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.
regards, tom lane
---(end of broadcast)---
TIP 2: Don't
On Tue, 10 Oct 2006, Jim C. Nasby wrote:
On Tue, Oct 10, 2006 at 02:22:53PM -0500, Richard Ray wrote:
I need to drop a superuser account. I get
dba=# drop role bram;
ERROR: role "bram" cannot be dropped because some objects depend on it
DETAIL: owner of view teacher
owner of type teacher
own
On Tue, Oct 10, 2006 at 02:22:53PM -0500, Richard Ray wrote:
> I need to drop a superuser account. I get
>
> dba=# drop role bram;
> ERROR: role "bram" cannot be dropped because some objects depend on it
> DETAIL: owner of view teacher
> owner of type teacher
> owner of view temp1
> owner of typ
My understanding is that, in 8.1, you'd need to revoke the privileges
before being able to drop the role/user.
8.2 seems to have two additional nice commands: "drop owned" command to
remove the objects owned by the user, and "reassign owned" to change the
ownership and give the objects to someon
