I am fairly new to Postgres. I noticed that the stored procedures written in pgplsql are checked only for syntax errors and nothing more at compile time. It does not even do that basic error checking like if the table/field names or variable names used in the procedure are even valid. This causes ugly compile time like error at run time.
Is there a configuration setting to increase the error checking level or any tool available to do the same.
Thank you,
Arun M