Hi all,
Oups, I forgot to put the ML in copy of my reply :-(
[...]
> > ERROR: fmgr_info: function 16594: cache lookup
> failed
> Most likely this means something happened to the
> call handler function
> for plpgsql. Look in pg_language to see the
> "lanplcallfoid" value for
> plpgsql; is it 16594?
Yes :
scheduling=# select lanplcallfoid from pg_language
where lanname = 'plpgsql';
lanplcallfoid
---------------
16594
(1 row)
> Do you have an entry in
> pg_proc for
> "plpgsql_call_handler", and if so what does it look
> like?
scheduling=# select * from pg_proc where
proname='plpgsql_call_handler';
proname | proowner | prolang | proisinh
| proistrusted | proiscachable | proisstrict |
pronargs | proretset | prorettype | proargtypes |
probyte_pct | pro
perbyte_cpu | propercall_cpu | prooutin_ratio |
prosrc | probin
----------------------+----------+---------+----------+--------------+---------------+-------------+----------+-----------+------------+-------------+-------------+----
------------+----------------+----------------+----------------------+---------------------------------
plpgsql_call_handler | 1 | 13 | f
| t | f | f |
0 | f | 0 | | 100
|
0 | 0 | 100 |
plpgsql_call_handler | /usr/local/pgsql/lib/plpgsql.sl
Please note I have remove the old binary and stop all
processes using it (Apache/PHP) before doing the
installation of the new release.
> regards, tom lane
Regards, Laurent
PS: Sorry Tom for my duplicate sending
=====
The misspelling master is on the Web.
_________ 100 % Dictionnary Free !
/ /(
/ Dico / / Pleins d'autres fautes sur
/________/ / http://go.to/destroyedlolo
(#######( /
Quoi, des fautes d'orthographe! Pas possible ;-D.
___________________________________________________________
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
