pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
cache 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