Re: missing cache data for cache id 27

brian wrote:
> I'm getting the above error when i try to replace a function of mine. It 
> seems i have two problems: the latest dump (through phpPGAdmin) works 
> fine, except that a function that should return a record was replaced 
> without the column definition list, so calls on it are failing.
> 
> from pg_dump:
> CREATE OR REPLACE FUNCTION getserviceprovidertotalsbytype() RETURNS 
> SETOF record AS $$
> 
> should be:
> CREATE OR REPLACE FUNCTION getserviceprovidertotalsbytype(OUT name text, 
> OUT id INT4, OUT total INT4) RETURNS SETOF record AS $$

What version of PostgreSQL and what version of pg_dump are we talking 
about here?

-- 
   Richard Huxton
   Archonet Ltd