urgent help on function/trigger

Поиск
Список
Период
Сортировка
От jprem
Тема urgent help on function/trigger
Дата
Msg-id 3972D78C.52EFE1A2@srmsoft.co.in
обсуждение исходный текст
Ответы Re: urgent help on function/trigger
Список 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.


В списке pgsql-general по дате отправления: