Cache lookup failed with FUNCTION + TRIGGER

Поиск
Список
Период
Сортировка
Искать
От
Stéphane FILLON
Тема
Cache lookup failed with FUNCTION + TRIGGER
Дата
Msg-id
000201bede95$30933640$c40a8280@portable
Список
Дерево обсуждения
Cache lookup failed with FUNCTION + TRIGGER "Stéphane FILLON" <fillons@offratel.nc>
Re: [SQL] Cache lookup failed with FUNCTION + TRIGGER Tom Lane <tgl@sss.pgh.pa.us>
I have one table client :

create table client( nocli int4,....
);

create function client() returns opaque as '
begin if new.nocli ISNULL then    raise exception "nocli null"; end if;
end;
' language 'plpgsql';

create trigger client before insert on client
for each row execute procedure client();

When I try to insert a tuple in client I have the following error:

"ERROR: fmgr_info: function 149857: cache lookup failed"

Where does this come from ? That's not the first time that I have this kind
of message!!

Please H E L P !!!!

RedHat 5.2
PostgreSQL 6.5.1


Regards,

Stephane FILLON


В списке pgsql-sql по дате отправления
От: Howie
Дата:
От: astromonk
Дата:
Сообщение: sequences not reliable?
FAQ