Re: Bug #608: cache lookup failed

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
fautessur 
/________/ /    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