From: | Jorge Godoy <jgodoy(at)gmail(dot)com> |
---|---|
To: | PostgreSQL General ML <pgsql-general(at)postgresql(dot)org> |
Subject: | ERROR: missing cache data for cache id 27 |
Date: | 2007-02-04 15:24:38 |
Message-ID: | 87mz3uhsql.fsf@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi!
There was a discussion with this same subject last week that seemed to be
caused by dump/restore with a wrong phpPgAdmin version.
I'm seeing the same error message for a development database where I always
use psql directly to make the maintenance and I had no dump/restore before it
started happening.
I'm using PostgreSQL 8.1.4 and psql 8.1.4 as well.
================================================================================
% LC_ALL= LANG= psql --version
psql (PostgreSQL) 8.1.4
contains support for command-line editing
================================================================================
I created two plpgsql functions with the following signatures:
================================================================================
CREATE OR REPLACE FUNCTION neolab.f_v_resultados_situacao(
p_amostra_id INTEGER, p_analise_id INTEGER,
OUT o_situacao TEXT, OUT o_data_previsao DATE) AS $_$
(...)
$_$ LANGUAGE plpgsql STABLE STRICT;
CREATE OR REPLACE FUNCTION neolab.f_v_resultados_situacao(
p_amostra_analise_id INTEGER,
OUT o_situacao TEXT, OUT o_data_previsao DATE) AS $_$
(...)
$_$ LANGUAGE plpgsql STABLE STRICT;
================================================================================
(The second overloads the first.)
They were created but I couldn't update their code because of the missing
cache data error. If I drop the function and recreate it, all goes well, but
I can't "REPLACE" it.
If I drop the first function, then I can REPLACE the second. If I don't, then
I get the missing cache error for both.
Is there some way to reset this cache so that I can investigate the cause of
the problem or would I have to recreate the database (i.e. a dump + dropdb +
createdb + restore)?
TIA,
--
Jorge Godoy <jgodoy(at)gmail(dot)com>
From | Date | Subject | |
---|---|---|---|
Next Message | Jamie | 2007-02-04 15:48:28 | When to use compound PK instead of a FK? |
Previous Message | Bruce Momjian | 2007-02-04 03:56:34 | Re: Windows default editor for psql \e |