urgent help on function/trigger

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

Предыдущее
От: "Eric Jain"
Дата:
Сообщение: RE: COUNT DISTINCT
Следующее
От: "Oliver Elphick"
Дата:
Сообщение: pg 7.0.2-2 vacuum slowness / loop? (fwd)