Re: missing cache data for cache id 27

From: brian <brian(at)zijn-digital(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: missing cache data for cache id 27
Date: 2007-01-24 17:27:04
Message-ID: 45B796E8.9060501@zijn-digital.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-01-24 17:33:14 Re: missing cache data for cache id 27
Previous Message Markus Schiltknecht 2007-01-24 17:10:19 Re: STOP all user access except for admin for a few minutes?