[Zope] Re: ZPyGreSQL error

[Ross J. Reedstrom]

On Thu, Oct 21, 1999 at 01:36:01PM -0600, Bruce Elrick wrote:
> Howdy...
> 
> Hope someone can help on this...
> 
> I get the following error:
>     <!--
>      Error type:  pg.error
>      Error value: ERROR:  fmgr_info: function 21121: cache lookup failed
>      -->

Hi Bruce - 
This is a PostgreSQL backend error, being propogated all the way up
through all those layers of software... I have'nt looked at it closely,
but I'll take a stab. You say only DELETEs error. The message above
is from the 'function manager' interface (fmgr) Looks to me like your
DB has referential integrity implemented using trigger functions, and
one of them is failing.  Take a look at the postgres postmaster logs
(perhaps after bumping the debug switch -D=5 or so) and find which one
is erroring. Not a Zope problem, probably.

<snipped traceback>

> Bruce Elrick, Ph.D.                       Saltus Technology Consulting Group
> Personal: belrick@home.com                          IBM Certified Specialist
> Business: belrick@saltus.ab.ca          ADSM, AIX Support, RS/6000 SP, HACMP
                                                ^^^^^^^^^^^^^^^^^^^^^^^
Hmm, you wouldn't know anything about this old RS/6000 N40 laptop I got cheap,
would you? ;-)

Ross


P.S. 

I just noticed that this email came directly to me, as well as to the Zope
list. Because of the way my procmail scripts work, duplicates like this
will get routed to my Zope list folder, rather than my work inbox. For
error reports (involving the ZPyGreSQLDA) if you'd like to email me
directly and get quicker response, please re-send or forward a copy to
my email address, rather than just CC:ing me. Since I'm so behind on the
lists, I've started grepping for references to PostgreSQL and the DA,
so I might find them anyway, but you never know.

-- 
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu> 
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St.,  Houston, TX 77005