Bruce Momjian <pgman@candle.pha.pa.us> writes:
>> No, I don't think that's very related; that's a simple matter of
>> implementing an ALTER FUNCTION command. The other thing will require
>> figuring out how to do dependency tracking.
> Got it. Let me ask, if they change the column type, would they use
> ALTER FUNCTION to then update to match the new column type. As I
> understand it, the problem is that this does not happen automatically,
> right?
My vision of ALTER FUNCTION is that it would let you change the function
body, and perhaps also the function language and attributes (isCachable,
isStrict). It would NOT allow you to change the function's parameter
types or return type, because that potentially breaks things that depend
on the function. To do that, you should have to create a new function.
regards, tom lane