Re: Error in pgAdmin II:frmSQLOutput.cmdDelete_Click: -2147467259 - ERROR: fmgr_info: function 16593: cache lookup failed

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Doherty, Jim" <doherty(at)tri(dot)sbc(dot)com>, <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Error in pgAdmin II:frmSQLOutput.cmdDelete_Click: -2147467259 - ERROR: fmgr_info: function 16593: cache lookup failed
Date: 2003-01-13 20:25:23
Message-ID: 03AF4E498C591348A42FC93DEA9661B8259A92@mail.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi Jim,

This error comes from PostgreSQL, not pgAdmin and basically says that
something is calling a function that had OID 16593 but no longer exists.
Check all your triggers and SQL functions and make sure none are
missing.

Regards, Dave.

-----Original Message-----
From: Doherty, Jim [mailto:doherty(at)tri(dot)sbc(dot)com]
Sent: 13 January 2003 20:18
To: pgadmin-support(at)postgresql(dot)org
Subject: Error in pgAdmin II:frmSQLOutput.cmdDelete_Click:
-2147467259 - ERROR: fmgr_info: function 16593: cache lookup failed


I am getting this error anytime I try to delete a row in a table
with a trigger calling a function that looks for
existing references. Any Idea what is causing this ?


Error in pgAdmin II:frmSQLOutput.cmdDelete_Click: -2147467259 -
ERROR: fmgr_info: function 16593: cache lookup failed

Jim Doherty
An IRISH Proverb
"There is no success without discipline"

Office: 512-372-5443 Fax: 512-241-5443
EMAIL: doherty(at)tri(dot)sbc(dot)com
Principal Member Technical Staff <mailto:jim_doherty(at)email(dot)com>
SBC - Technology Resources Inc.

This e-mail and any files transmitted with it are the property
of SBC, are confidential, and are intended solely for the use of the
individual or entity to whom this e-mail is addressed. If you are not
one of the named recipient(s) or otherwise have reason to believe that
you have received this message in error, please notify the sender at 512
372-5443 and delete this message immediately from your computer

Browse pgadmin-support by date

  From Date Subject
Next Message Catarina Monica 2003-01-14 10:07:28 Postgres 7-3-1 in powerPC
Previous Message Doherty, Jim 2003-01-13 20:17:53 Error in pgAdmin II:frmSQLOutput.cmdDelete_Click: -2147467259 - E RROR: fmgr_info: function 16593: cache lookup failed