pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedcache lookup failed
4+ messages / 4 participants
[nested] [flat]
* cache lookup failed
@ 2000-02-24 17:08 Graham Vickrage <graham@digitalplanit.com>
2000-02-24 22:14 ` Re: [SQL] cache lookup failed Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 4+ messages in thread
From: Graham Vickrage @ 2000-02-24 17:08 UTC (permalink / raw)
To: pgsql-sql
I am relatively new to postgres, and am struggling with the following,
I am trying to set up a trigger on a table that deletes the foreign key
references in the child table,
I'm executing the delete command in the usual way (assuming already
connected)-
delete from website where website_id = '$website_id';
which works fine when there is no trigger on the table but once the trigger
is created I get the following error -
fmgr_info: function 47172: cache lookup failed
Has anyone seen a similar problem, any help would be greatly appreciated.
Cheers
Graham
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [SQL] cache lookup failed
2000-02-24 17:08 cache lookup failed Graham Vickrage <graham@digitalplanit.com>
@ 2000-02-24 22:14 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 4+ messages in thread
From: Tom Lane @ 2000-02-24 22:14 UTC (permalink / raw)
To: Graham Vickrage <graham@digitalplanit.com>; +Cc: pgsql-sql
"Graham Vickrage" <graham@digitalplanit.com> writes:
> I am trying to set up a trigger on a table that deletes the foreign key
> references in the child table,
> delete from website where website_id = '$website_id';
> which works fine when there is no trigger on the table but once the trigger
> is created I get the following error -
> fmgr_info: function 47172: cache lookup failed
This sounds like it could be a bug in Postgres, but you'll need to give
more details. The full definitions of both tables and the trigger
function would help. Also, what version are you using?
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
* cache lookup failed
@ 2001-09-12 14:05 victor <victor@work.ro>
2001-09-12 15:00 ` Re: cache lookup failed Peter Eisentraut <peter_e@gmx.net>
0 siblings, 1 reply; 4+ messages in thread
From: victor @ 2001-09-12 14:05 UTC (permalink / raw)
To: pgsql-sql
Hi,
I have this function:
CREATE FUNCTION add_one (integer) RETURNS integer AS '
BEGIN
RETURN $1 + 1;
END;
' LANGUAGE 'plpgsql';
from postgres doc.
When I try somethin like this:
SELECT add_one(4);
I get :
ERROR: fmgr_info: function 20086: cache lookup failed
please tell me what it's rong.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: cache lookup failed
2001-09-12 14:05 cache lookup failed victor <victor@work.ro>
@ 2001-09-12 15:00 ` Peter Eisentraut <peter_e@gmx.net>
0 siblings, 0 replies; 4+ messages in thread
From: Peter Eisentraut @ 2001-09-12 15:00 UTC (permalink / raw)
To: victor <victor@work.ro>; +Cc: pgsql-sql
victor writes:
> CREATE FUNCTION add_one (integer) RETURNS integer AS '
> BEGIN
> RETURN $1 + 1;
> END;
> ' LANGUAGE 'plpgsql';
>
> >from postgres doc.
> When I try somethin like this:
>
> SELECT add_one(4);
>
> I get :
>
> ERROR: fmgr_info: function 20086: cache lookup failed
Possibly you have dropped and recreated the plpgsql language handler after
the function was already created. If so, recreate the function.
--
Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2001-09-12 15:00 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-02-24 17:08 cache lookup failed Graham Vickrage <graham@digitalplanit.com>
2000-02-24 22:14 ` Tom Lane <tgl@sss.pgh.pa.us>
2001-09-12 14:05 cache lookup failed victor <victor@work.ro>
2001-09-12 15:00 ` Peter Eisentraut <peter_e@gmx.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox