Re: [SQL] checking pgsql functions

2005-04-20 Thread Michael Fuhr
On Thu, Apr 21, 2005 at 04:35:37AM +0200, Enrico Weigelt wrote: > > Is it possible to check plpgsql functions before they're actually > into the database, as it's done w/ sql functions ? What version of PostgreSQL are you using? 8.0 and later have a validator function for PL/pgSQL, although its

Re: [SQL] checking pgsql functions

2005-04-20 Thread Tom Lane
Enrico Weigelt <[EMAIL PROTECTED]> writes: > Is it possible to check plpgsql functions before they're actually > into the database, as it's done w/ sql functions ? 8.0 does a little bit of this, and 8.1 will do more... regards, tom lane ---(end of

[SQL] checking pgsql functions

2005-04-20 Thread Enrico Weigelt
Hi folks, Is it possible to check plpgsql functions before they're actually into the database, as it's done w/ sql functions ? Often I've got the problem that a function still contains some syntax errors (well, nobody's perfect), but my application is quite critical (a single crashing trigger m