Thread: Validate for PL/pgSQL functions

Hello,

Is there a way to "validate" the PL/pgSQL statements in (trigger-)functions.
With validate I mean check syntax and ensure that all referenced database
objects do exist.

Regards
Ruediger

--
+++ GMX DSL Premiumtarife 3 Monate gratis* + WLAN-Router 0,- EUR* +++
Clevere DSL-Nutzer wechseln jetzt zu GMX: http://www.gmx.net/de/go/dsl

Hm,

fortgot to say that I am working with 8.0 beta 3. Though I am sold on
Postgres, the validation it does on PL/pgSQL is very basic.
While it is convenient that Postgres allows to create PL/pgSQL that
references object not yet existent, I would like to be able check the
PL/pgSQL completely and be reported when syntax is invalid or objects
don't exist.
Is there any way?

TIA
Ruediger

--
+++ GMX DSL Premiumtarife 3 Monate gratis* + WLAN-Router 0,- EUR* +++
Clevere DSL-Nutzer wechseln jetzt zu GMX: http://www.gmx.net/de/go/dsl