Skip site navigation (1) Skip section navigation (2)

Re: Validate for PL/pgSQL functions

From: "Ruediger Herrmann" <ruediger(dot)herrmann(at)gmx(dot)de>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Validate for PL/pgSQL functions
Date: 2004-10-20 17:07:25
Message-ID: 14317.1098292045@www56.gmx.net (view raw or flat)
Thread:
Lists: pgsql-novice
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


pgsql-novice by date

Next:From: Srinivas IyyerDate: 2004-10-20 21:18:42
Subject: connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
Previous:From: Bruno Wolff IIIDate: 2004-10-20 15:49:27
Subject: Re: '-U postgres' doesn't authenticate

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group