Re: BUG #3725: plsql does not report unknown functions at compile time - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #3725: plsql does not report unknown functions at compile time
Date
Msg-id 23952.1194371821@sss.pgh.pa.us
Whole thread Raw
In response to BUG #3725: plsql does not report unknown functions at compile time  ("Roger" <ramoloney@hotmail.com>)
List pgsql-bugs
"Roger" <ramoloney@hotmail.com> writes:
> At compile time, plpgsql does not report unknown functions. For example, if
> I have a function.
>   p_Func(a,b,c)
> and I have calls to it such as:
>   p_Func(a)
>   p_Func(a,b)
> these are not reported at compile time. They are only found at run time.

This isn't a bug, no matter how much you complain about it.

If we made plpgsql reject such cases, it would break a whole lot of
things --- for example it would become impossible to create a pair of
mutually recursive functions.  Moreover, it's not hard to think of
cases where it's simply not possible to check when the function is
created, because you can't be certain what input datatypes will be
involved and so it's not clear which function is to be called.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Test suite fails on alpha architecture
Next
From: Tom Lane
Date:
Subject: Re: BUG #3724: Duplicate values added to table despite unique index