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@xxxxxxxxxxxxxxxx>
To: <tony_caduto@xxxxxxxxxxxxxxxxxxxx>
Cc: <pgsql-general@xxxxxxxxxxxxxx>
Sent: Monday, February 21, 2005 10:47 AM
Subject: Re: 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@xxxxxxxxxxxxxxxx | (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
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)
