I am planning to enhance PgAccess in order to handle plpgsql functions
(to define, delete , inspect and modify them).

In this respect, I would like to know :

1. what is the value of prolang field in pg_proc table for plpgsql
functions (on my system is 43009, but it this value stable?)

2. are plpgsql functions interpreted at execution time ? If not (just
for the record) is this a big performance penalty ? Should I reconsider
writing them in "C" for triggers for example , or for the most often
called functions ?

3. in order to modify a function's source, to change to field procsrc in
pg_proc table ? Or should I "drop function ..." and "create function
..." again ?


Please CC: me directly to teo@flex.ro

Thanks in advance,
Constantin Teodorescu
FLEX Consulting Braila, ROMANIA

Fri, 06 Nov 1998 07:32:10 +0000
Constantin Teodorescu <teo@flex.ro>
A plpgsql question !