cache lookup failed - Mailing list pgsql-sql

From Graham Vickrage
Subject cache lookup failed
Date
Msg-id NDBBJABDILOPAOOMFJHOAEJKCAAA.graham@digitalplanit.com
Whole thread Raw
Responses Re: [SQL] cache lookup failed  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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



pgsql-sql by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [SQL] database rights?
Next
From: M.Mazurek@poznan.multinet.pl
Date:
Subject: date_part, too many results?