Re: fmgr_info: function 2714160: cache lookup failed - Mailing list pgsql-general

From Jan Wieck
Subject Re: fmgr_info: function 2714160: cache lookup failed
Date
Msg-id 200107091518.f69FI6707951@jupiter.us.greatbridge.com
Whole thread Raw
In response to fmgr_info: function 2714160: cache lookup failed  (Steve Wampler <swampler@noao.edu>)
List pgsql-general
Steve Wampler wrote:
>
> Can someone explain to me what this error is and how to avoid it?
> (Results from an INSERT through JDBC on 7.1.2 with RH Linux).

    You  must  have  droppend  a  function that was referenced by
    another  object   (view,   operator,   aggregate,   whatnot).
    Recreating  the  function  only doesn't help, because they're
    referenced  by  OID.  You  have  to  drop  and  recreate  all
    dependant objects as well.


Jan

PS: No, Bruce, I don't start on pg_depend right now :-)

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Transactions in rules..
Next
From: Martijn van Oosterhout
Date:
Subject: [PATCH] Partial indicies again