Re: fmgr_info: function 2714160: cache lookup failed

From: Jan Wieck <JanWieck(at)Yahoo(dot)com>
To: Steve Wampler <swampler(at)noao(dot)edu>
Cc: postgres-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: fmgr_info: function 2714160: cache lookup failed
Date: 2001-07-09 15:18:06
Message-ID: 200107091518.f69FI6707951@jupiter.us.greatbridge.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)Yahoo(dot)com #

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Wampler 2001-07-09 15:39:04 Re: fmgr_info: function 2714160: cache lookup failed
Previous Message Martijn van Oosterhout 2001-07-09 15:17:14 [PATCH] Partial indicies again