Skip site navigation (1) Skip section navigation (2)

ERROR: plpgsql: cache lookup from pg_proc failed -- Why?

From: "zivit" <zivit(at)congruency(dot)co(dot)il>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: ERROR: plpgsql: cache lookup from pg_proc failed -- Why?
Date: 2001-01-18 16:28:14
Message-ID: 001c01c0816b$a8e02700$c8dea8c0@congruency.co.il (view raw or flat)
Thread:
Lists: pgsql-novice
We have the following problem on executing trigger: ERROR: plpgsql: cache
lookup from pg_proc failed.
We did 'createlang plpgsql' to our database, and then created function and
trigger.
The creations of function and respective trigger  were successfully be done.
On executing query that run the trigger with its function, the above error
is appeared.
What to do? Why we got this error?

Thank you.
Best regards,
Zivit Botushansky

Congruency Ltd.
3 Magshimim St., Kiriat Matalon, POB. 7813
Petah-Tikva 49170, Israel
Email:  zivit(at)congruency(dot)com
Phone:  +972-3-9240204 (ext:229)
Fax  :  +972-3-9210757
web : www.congruency.com


Responses

pgsql-novice by date

Next:From: Stefan Waidele jun.Date: 2001-01-18 16:40:34
Subject: Interval output format
Previous:From: Nabil SayeghDate: 2001-01-18 14:28:02
Subject: FOREIGN KEY ... REFERENCES ...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group