I have hit this as well though unlike Tony my errors are generally not test
cases!
If for example you mistype a column/variable name inside the function
Postgres will create and allow the function to run as long as the path
through the function containing the error is not executed.
It would be nice to be told about the error on function
creation/modification. Although I feel this is almost a feature as it keeps
me honest and testing every possible path through my functions a little bit
more thoroughly than I might have been doing with Oracle and MSSQL....
It would still be nice to have some idiotproofing. Is there info on what
the check_function_bodies does check?
Oisin
----- Original Message -----
From: "Bruce Momjian" <pgman@candle.pha.pa.us>
To: <tony_caduto@amsoftwaredesign.com>
Cc: <pgsql-general@postgresql.org>
Sent: Monday, February 21, 2005 10:47 AM
Subject: Re: [GENERAL] is there anyway to get the backends IP address from
> Tony Caduto wrote:
>> Bruce,
>> On another note, is there plans to improve the type checking of stored
>> functions during the save/compile?
>> Currently I can pretty much make tons of mistakes (on purpose of course
>> :-) and they are not flagged as errors until runtime.
>> The biggest complaint I see from other DBAs (MS SQL, Oracle) is that
>> Postgres does little to no pre-runtime type checking.
>
> We have no plans to improve that. We do have 'check_function_bodies'
> which defaults to true and does some checking. Would you give us a
> particular example you would like improved?
>
> --
> Bruce Momjian | http://candle.pha.pa.us
> pgman@candle.pha.pa.us | (610) 359-1001
> + If your life is a hard drive, | 13 Roberts Road
> + Christ can be your backup. | Newtown Square, Pennsylvania
> 19073
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.306 / Virus Database: 266.1.0 - Release Date: 2/18/2005
>
>