Erik Jones wrote: > > On Dec 8, 2008, at 1:42 PM, Tom Lane wrote: > >> Erik Jones <ejones@xxxxxxxxxxxxxx> 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. > > While I understand what you're saying, in the general case, in this > specific case I have a hard time grokking it. I guess I was thinking in > terms of a language owning it's handler and validator functions but I now > see that dropping a language doesn't also drop the underlying functions, > which I also find unintuitive. 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. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
