From: Tom Lane <tgl@sss.pgh.pa.us>
To: Archibald Zimonyi <archie@netg.se>
Cc: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: Function problems, cache lookup failed
Date: Thu, 01 Aug 2002 10:01:09 -0400
Message-ID: <7021.1028210469@sss.pgh.pa.us> (raw)
In-Reply-To: <Pine.LNX.4.44.0208011140020.20187-100000@elvegris.netg.se>
References: <Pine.LNX.4.44.0208011140020.20187-100000@elvegris.netg.se>
Archibald Zimonyi <archie@netg.se> writes:
> ERROR: fmgr_info: function 18308: cache lookup failed
> I have no idea what this is, can anyone help me?
The aggregate links to the function by OID. You deleted the function
and recreated it, which means it's a new function with a new OID and
so the aggregate is broken.
You'll need to drop and recreate the aggregate too. Next time use
CREATE OR REPLACE FUNCTION so you don't need to do that. (With
CREATE OR REPLACE, you are just modifying the existing function,
so its OID doesn't change.)
7.3 will prevent this sort of mistake...
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, archie@netg.se
Subject: Re: Function problems, cache lookup failed
In-Reply-To: <7021.1028210469@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox