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 syntax checks are minimal and errors can still get through. I'm sure a patch that improves it would be welcome :-) > 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 may cost a lot of money). > So I'd like to checkin only syntactically correct (also with > correct references). Since the application is critical, hopefully you're running regression tests in a non-production environment before modifying the production system. Is that not the case? Regardless of how much syntax checking the DBMS does, it would still be prudent to test as many code paths as possible for semantic correctness. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
