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

Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> Well, since CREATE LANGUAGE creates the functions internally, it does
> make a certain amount of sense that the functions are also handled
> internally when you do stuff to the language.

It *might* create the functions internally, or it might not. Admittedly
the present behavior is somewhat skewed by historical compatibility
considerations, but as long as the functions are independently creatable
objects I don't think it makes sense to have ALTER LANGUAGE messing with
them.

We'd be heading down a very slippery slope if we did that, too ---
should ALTER AGGREGATE touch the underlying functions? How about ALTER
CONVERSION propagating to the underlying function? Or ALTER TYPE to its
underlying I/O functions? Or ALTER DOMAIN to the underlying type? Etc.
If we did change this, how do we not break pg_dump's ability to
replicate a situation where tbe ownerships had been different?

regards, tom lane