> You have a syntax typo
> IF NEW.SITE_REFERNCE = SITE_REFERENCE
>
> IF NEW.SITE_REFERENCE = SITE_REFERENCE
PROBABLY
> ----- Original Message -----
> From: "Ismail Bouabdallah" <bouabdi9@cs.man.ac.uk>
> To: <pgsql-sql@postgresql.org>
> Sent: Monday, March 04, 2002 8:32 PM
> Subject: [SQL] PL/pgsql
>
> > ERROR: fmgr_info: function 56664: cache lookup failed
> >
But this message I've got when I've not deleted trigger on table. Try to
delete and create trigger function and trigger again.
GOOD LUCK!
Dinar