Re: alter table owner doesn't update acl information - Mailing list pgsql-general

On Thu, 2005-05-12 at 16:15 -0400, Tom Lane wrote:
> "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
>

Try it, it doesn't work!
I can give you examples in case you need them.

Cheers,

Madeleine