Re: missing cache data for cache id 27

[brian <brian@xxxxxxxxxxxxxxxx>]

Richard Huxton wrote:
> 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?

Ach! 8.1.4, sorry.

b