Re: missing cache data for cache id 27 - Mailing list pgsql-general

From brian
Subject Re: missing cache data for cache id 27
Date
Msg-id 45B796E8.9060501@zijn-digital.com
Whole thread Raw
In response to Re: missing cache data for cache id 27  (Richard Huxton <dev@archonet.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: missing cache data for cache id 27
Next
From: Tom Lane
Date:
Subject: Re: missing cache data for cache id 27