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.
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? |