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
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? |