insert failed

Поиск
Список
Период
Сортировка
Искать

insert failed

От:
s.chava@wcom.com (Srinivasa Rao Chava)
Дата:
Hi, 
when we try insert into a table, the inset is failing with cach look
up failure error.

 
Below is the complete statement and error generated.

DEPG=> insert into EXTRANET_SECTION (ID, section_name,
parent,extranetname) values (255,' Main',0, 'test');
ERROR:  fmgr_info: function 19464: cache lookup failed
DEPG=> 


ANy help !!please

Re: insert failed

От:
Stephan Szabo <sszabo@megazone23.bigpanda.com>
Дата:
On 15 Aug 2001, Srinivasa Rao Chava wrote:

> Hi, 
> when we try insert into a table, the inset is failing with cach look
> up failure error.
> 
>  
> Below is the complete statement and error generated.
> 
> DEPG=> insert into EXTRANET_SECTION (ID, section_name,
> parent,extranetname) values (255,' Main',0, 'test');
> ERROR:  fmgr_info: function 19464: cache lookup failed
> DEPG=> 

Do you have any rules or triggers defined on the table
(for example foreign keys)?

Re: insert failed

От:
Srinivasa R Chava <s.chava@wcom.com>
Дата:
Yes, there is a trigger on the table. Is there any problem with
triggers?

-- 

Srinivasa R Chava (Chava) 
Application Developer
Corporate Intra/Internet Systems
WORLDCOM - http://www.worldcom.com/ - NASDAQ:WCOM 
500 Clinton Center Drive (Corporate Headquarters)
Clinton, Mississippi (MS) USA  39056
(601)460-3122 / vnet4603122 / (800)844-1009 / FAX(601)460-8257

Re: insert failed

От:
Stephan Szabo <sszabo@megazone23.bigpanda.com>
Дата:

On Wed, 15 Aug 2001, Srinivasa R Chava wrote:

> Yes, there is a trigger on the table. Is there any problem with
> triggers?

It probably is saying it can't find the trigger function.  This
usually happens if you drop and recreate the function without
dropping and recreating the trigger.

FAQ