Обсуждение: strange error: ERROR: fmgr_info: function 2980747: cache lookup failed

hi,

I was playing around with pgsql 7.2.1 and i've discovered something strange.
when i try to update a record i get this strange error:
ERROR:  fmgr_info: function 2980747: cache lookup failed

i've also tried to downgrade to 7.2.0 but to no avail. (and yes, i made sure
7.2 was running and not 7.2.1).

it happens sometime when i do a query like this:
update tablename field='bla' where id = some_number;

it's really weird, it's only bugging on one of my tables.

(i'm running cygwin 1.3.10, pgsql 7.2.1/7.2.0)
any thoughts?

thnx in advance

cuong wrote:
>
> hi,
>
> I was playing around with pgsql 7.2.1 and i've discovered something strange.
> when i try to update a record i get this strange error:
> ERROR:  fmgr_info: function 2980747: cache lookup failed

Is it an ODBC issue ?

> i've also tried to downgrade to 7.2.0 but to no avail. (and yes, i made sure
> 7.2 was running and not 7.2.1).
>
> it happens sometime when i do a query like this:
> update tablename field='bla' where id = some_number;

Doesn't the table have triggers ?

regards,
Hiroshi Inoue
    http://w2422.nsk.ne.jp/~inoue/