checking pgsql functions

From: Enrico Weigelt <weigelt(at)metux(dot)de>
To: pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: checking pgsql functions
Date: 2005-04-21 02:35:37
Message-ID: 20050421023537.GB16782@nibiru.borg.metux.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)metux(dot)de
cellphone: +49 174 7066481
---------------------------------------------------------------------
-- DSL ab 0 Euro. -- statische IP -- UUCP -- Hosting -- Webshops --
---------------------------------------------------------------------

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2005-04-21 03:25:11 Re: checking pgsql functions
Previous Message Tom Lane 2005-04-20 21:06:16 Re: Function to either return one or all records