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@gmail.com>