urgent help on function/trigger

From: jprem <jprem(at)srmsoft(dot)co(dot)in>
To: pgman <pgman(at)candle(dot)pha(dot)pa(dot)us>, postgresql <pgsql-general(at)postgresql(dot)org>
Subject: urgent help on function/trigger
Date: 2000-07-17 09:53:17
Message-ID: 3972D78C.52EFE1A2@srmsoft.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hello,
i have a procedure and a trigger as below
______________________________________________________________________
create function FUNCTEST () returns opaque
as
'begin
delete from X where COLX in (select COLX from X
where COLX not in (select COLY from Y ));
return null;
end;'
language 'plpgsql';

create trigger TRIGTEST after delete on Y for each row
execute procedure FUNCTEST();
________________________________________________________________________

i need some tuples to be deleted from X while i delete some from Y.

the function and trigger are created without any problem.
when i delete a tuple from Y , i get the following error.
_________________________________________________________________________

ERROR: fmgr_info: function 152480: cache lookup failed
_________________________________________________________________________

why this error is due to ? can anyone help me on this ?
thanx in advance.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Oliver Elphick 2000-07-17 09:57:21 pg 7.0.2-2 vacuum slowness / loop? (fwd)
Previous Message Jurgen Defurne 2000-07-17 07:29:09 Re: Parallel databases?