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