Re: Possible bug with ALTER LANGUAGE ... OWNER TO ...

Erik Jones <ejones@engineyard.com> writes:
> I've just run up against a problem with ALTER LANGUAGE ... OWNER
> TO ... wherein the change of ownership does not propagate to a
> language's handler and validator functions preventing you from
> dropping the role if it created a language.  I'm assuming a valid
> workaround is manually change the owner of the handler and validator
> functions but I'd think that changing a languages owning role should
> propagate to any other objects created when the language was created.

Why?  The underlying functions are independent objects, in the general
case.

What you really want for this case is REASSIGN OWNED, I think.

            regards, tom lane