stored procedure compilation error checking

From: "Mani, Arun" <amani(at)essvote(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: stored procedure compilation error checking
Date: 2008-08-11 17:15:37
Message-ID: B7D2DB00E612CA49A445B375B0F433830AAE4749@ESSOMAEXC2.essvote.corp.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2008-08-11 18:06:56 Re: stored procedure compilation error checking
Previous Message Scott Marlowe 2008-08-11 16:58:05 Re: big database with very small dump !?