Re: alter table owner doesn't update acl information

"Madeleine Theile" <mt@theile.net> writes:
> But what if he doesn't? Then the only possibility is to drop all the
> views and recreate them as another user in order to fix the issue with
> the acl rights.

See ALTER OWNER.  The intention is to make you give away all the owned
objects before getting rid of the user.

            regards, tom lane