Thread: stored procedure compilation error checking

stored procedure compilation error checking

From
"Mani, Arun"
Date:

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

Re: stored procedure compilation error checking

From
Peter Eisentraut
Date:
On Monday 11 August 2008 20:15:37 Mani, Arun wrote:
> Is there a configuration setting to increase the error checking level or
> any tool available to do the same.

No