checking pgsql functions - Mailing list pgsql-sql

From Enrico Weigelt
Subject checking pgsql functions
Date
Msg-id 20050421023537.GB16782@nibiru.borg.metux.de
Whole thread Raw
Responses Re: checking pgsql functions  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: checking pgsql functions  (Michael Fuhr <mike@fuhr.org>)
List pgsql-sql
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 may cost a lot of money).
So I'd like to checkin only syntactically correct (also with 
correct references).

Is it possible somehow ?


cu
-- 
---------------------------------------------------------------------Enrico Weigelt    ==   metux IT service
 phone:     +49 36207 519931         www:       http://www.metux.de/ fax:       +49 36207 519932         email:
contact@metux.decellphone: +49 174 7066481
 
----------------------------------------------------------------------- DSL ab 0 Euro. -- statische IP -- UUCP --
Hosting-- Webshops --
 
---------------------------------------------------------------------


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Function to either return one or all records
Next
From: Tom Lane
Date:
Subject: Re: checking pgsql functions