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
