| From: | Constantin Teodorescu <teo(at)flex(dot)ro> |
|---|---|
| To: | "pgsql-hackers(at)postgreSQL(dot)org" <pgsql-hackers(at)postgreSQL(dot)org> |
| Subject: | A plpgsql question ! |
| Date: | 1998-11-06 07:32:10 |
| Message-ID: | 3642A5FA.EE081F36@flex.ro |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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(at)flex(dot)ro
Thanks in advance,
Constantin Teodorescu
FLEX Consulting Braila, ROMANIA
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Constantin Teodorescu | 1998-11-06 08:18:57 | Re: [INTERFACES] crypt not included when compiling libpgtcl !!!!!!! |
| Previous Message | Thomas G. Lockhart | 1998-11-06 07:08:28 | Re: [HACKERS] PL/pgSQL a great procedural language for PostgreSQL |