Re: Function with default value not replacing old definition of the function

Dimitri Fontaine <dfontaine@hi-media.com> writes:
>> The sanest answer I can see is "so, don't do that".

> Is there any warning level message at CREATE FUNCTION time for the  
> user/dba to know he's doing something... border line, almost shooting  
> himself in the foot?

It's not that easy to produce a message that wouldn't be annoying noise.
In particular, it's hard to know whether functions in different schemas
would represent a problem or not.
        regards, tom lane