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 по дате отправления: