Re: language handlers in public schema? - Mailing list pgsql-hackers

Tom Lane wrote:

>Andrew Dunstan <andrew@dunslane.net> writes:
>  
>
>>Is there any reason for us to keep putting the language handler 
>>functions in the public schema?
>>    
>>
>
>I believe one of the issues there is that pg_dump doesn't dump functions
>that are in pg_catalog.  You could possibly fix it to make an exception
>for functions that are referenced by pg_language entries, but I think
>this would be a nontrivial change.
>  
>

Hmm. Could we not just add something this condition:
or pg_catalog.format_type(prorettype, NULL) != 'language_handler'

in pg_dump.c around line 2191?

I'd like to get this done, but I don't think I'll have time before July 
1. How about putting it on the TODO list?


cheers

andrew